#DateForumTypeThreadPost
504 Jun 2015 @ 02:20 PDTGeneralReplyCASE is a solution?I have previously tried the below approach   LOCK ROW FOR ACCESS SELECT c.numb, SUM(c.results), CASE WHEN SUM(c.results) MOD 10 = '0' THEN   'Found in A but could be...
404 Jun 2015 @ 01:42 PDTGeneralTopicCASE is a solution?Hello,   I have a difficult task (or at least this is how I see it) to implement using SQL. Here is the case: - there are two tables: A and E each one having a numeric column. Each of the t...
320 May 2014 @ 05:37 PDTDatabaseTopic3541: The request to assign PERMANENT space is invalidHi,   I'm trying to move 20Go from a database that has 1220 GB Max Perm and 1000 GB Current Perm. Could somebody tell me why am I receiving the following error message when I try to do t...
204 Sep 2013 @ 02:32 PDTToolsReplyfastload insertion Thank you, Steven. Using UPDATE operator I was able to finish successfully the TPT operation.
103 Sep 2013 @ 08:16 PDTToolsReplyfastload insertion Hello, I have encountered the same problem while trying to insert values in the table TB_AGR_PAT_MOB_GRP:          STEP LOAD_EXP_TABLE (      &...