#DateForumTypeThreadPost
1813 May 2015 @ 03:33 PDTDatabaseReplyERROR IN CASTING DECIMAL TO INTEGERTry bigint
1727 Apr 2015 @ 07:19 PDTGeneralReplyHow to find multiple occurrence of a word in a string if the number of occurrences of the word is not knownRecursive can be useful.
1622 Apr 2015 @ 06:39 PDTDatabaseReplyreplace 3rd and 9th position In a string REGEX_REPLACE can be used in TD 14 ,if your string is having limited length.But,it may not be suitable for longer fields. substr would be a good option. Thanks, Yuva. ...
1510 Apr 2015 @ 01:39 PDTDatabaseReplySQL to find out Match in a group of the same table Self join?
1420 Mar 2015 @ 03:44 PDTDatabaseReplyNon duplicate row selection queryIs it possible to create one more column?. If yes, then rec md5 sum of the columns excluding direct_id can be created, which can be used in partition by. This will improve the performance, I hope. ...
1318 Mar 2015 @ 01:03 PDTDatabaseReplyOn Commit Preserve Rows taking much time Can you post the ddl and select?.   Thanks and regards, Yuva.
1218 Mar 2015 @ 12:59 PDTDatabaseReplyNon duplicate row selection queryLogic given by me may not work..since direct_id is different...My bad :(   Thanks Yuva
1117 Mar 2015 @ 07:11 PDTDatabaseReplyNon duplicate row selection queryIf you have access to DDLS, Create a temp table as set table - Table 1 Insert the rows from the source to "Table 1" Insert the rows from "Source"  minus "Table1&quo...
1013 Mar 2015 @ 07:12 PDTDatabaseReplyQuery    SEL NAME,SUM,FIRST_VALUE(SUM) OVER(ORDER BY NAME ASC ROWS UNBOUNDED PRECEDING)-SUM FROM T1 ..This is the correct one.. @adityapatel  
913 Mar 2015 @ 07:10 PDTDatabaseReplyQuerySEL NAME,SUM,(SEL SUM FROM (SEL SUM FROM P1 QUALIFY ROW_NUMBER() OVER( ORDER BY NAME ASC)=1) A) - SUM FROM P1 This sould work.   Thanks Yuva    
813 Mar 2015 @ 02:36 PDTDatabaseReplyQueryIf your TD version is 14, then first value can be used. SEL NAME,DIFF,FIRST_VALUE(DIFF) OVER(ORDER BY NAME ASC ROWS UNBOUNDED PRECEDING)-DIFF FROM T1  
711 Mar 2015 @ 12:14 PDTGeneralReplyDate format DD-MON-YYYY to YYYY-MM-DD Its working...there could be some syntax error..check it... SEL  CAST('01 APR 1999' AS VARCHAR(15)) AS T1, TO_CHAR(TO_DATE(T1,'DD MON YYYY') ,'YYYY-MM-DD HH:MI:SS')...
610 Mar 2015 @ 06:22 PDTGeneralReplyIs Null conditions in ON (Join) Vs. Is Null in WhereIts about the order or precedence in which the query is executed. Case 1: Left outer join is performed and then where condition is applied. Case 2: Lefter outer join is performed only on the rows...
531 Jul 2014 @ 01:22 PDTDatabaseReplyDistribution in ampsThanks....
422 Jul 2014 @ 07:09 PDTDatabaseReplyBlank space check based on the positionIF the no of characters to be validated for numeric is less, then you can use "IN" option. But, not good for more no of columns or alphanumeric...Best option would be to go for UDF i...
322 Jul 2014 @ 06:53 PDTDatabaseTopicDistribution in ampsHi,  In a system of 190 amps,Whenever I create a table 1 kb is assigned to each vproc by default summing to 190 kb. Why is this space assigned to each vproc. When I q...
228 Aug 2009 @ 06:19 PDTToolsTopiccommand issue in mloadHi,I am using the following .accept command in MLOAD to accept a system variable..LOGTABLE ****_WORK.LT_*****MLOAD ; .RUN FILE LOGON; .SET SRC TO '&SYS...
106 Aug 2009 @ 06:52 PDTUDATopiclogon failure in bteq: CLI error: CLI0282 REQUESTED TDP UNAVAILABLEHi, I use logon using .LOGON TDP1/userin,password; in bteq. When I run this bteq thru jcl in mainframe, the job runs successfully.But When I run this same logon script using REXX, the logon...

Pages