#DateForumTypeThreadPost
802 Aug 2015 @ 02:01 PDTToolsTopicBTEQ Merge failed- DDL changes on tableHello,   I have a BTEQ script which was running fine, it has a MERGE stmt. the table in which data was MERGED to has got a new column added and the database default is defined for the new co...
719 Jul 2015 @ 05:41 PDTToolsReplyET stmt with no BT in BTEQ; failed with error Thank very much. one more question- had this been with a BT before the ET statement and bunch of SQLs and if some SQL fails, in that case, data committed to DB will get rolled back, is it correct? ...
617 Jul 2015 @ 04:55 PDTToolsTopicET stmt with no BT in BTEQ; failed with error Hello, In a BTEQ script we have an ET statement by mistake without a BT and BTEQ failed with below error when it encountered ET. I have a question, there are several SQLs before this ET and all of ...
507 May 2015 @ 12:54 PDTDatabaseTopicWHERE clause usage on Left outer joinHi,   I have a question about the usuage of filter condition in WHERE clause vs ON clause of LOJ. My query is - SEL * FROM (SEL T1.COL1,T2.COL2,T2.COL4 FROM TABLE1 T1 LEFT OUTER JOI...
431 Mar 2015 @ 04:57 PDTDatabaseReplyHow to find if a varchar field has 9 digit intergersHi, is there any other way to find this out? I would like to know how to find if a varchar field has integer values with length 9? this field is 90 chars in the table. the challange is the val...
330 Mar 2015 @ 09:58 PDTDatabaseReplyHow to find if a varchar field has 9 digit intergersI am on TD 14.10.0.11..   not sure how to check on source defined as LATIN or UNICODE? could you pls help.   Is there any other function instead? Thanks!
227 Mar 2015 @ 08:03 PDTDatabaseReplyHow to find if a varchar field has 9 digit intergersHi dnoeth,   Thanks much for your response. I tried both REGEXP functions you provided, I get the error - Error Code 6706: The string contains an untranslatable character. this field is an ...
125 Mar 2015 @ 02:26 PDTDatabaseTopicHow to find if a varchar field has 9 digit intergersHi, I would like to know how to find if a varchar field has integer values with length 9? this field is 90 chars in the table. the challange is the value 9 digit integer could be mixed with v...