#DateForumTypeThreadPost
1122 Jul 2014 @ 01:15 PDTDatabaseReplyProlonged Responding State - for data load casesHi.. could anyone help ?
1015 Jul 2014 @ 02:57 PDTAnalyticsReplyFor AMP Number HASHMAP()+1We add '1' cause the AMP numbering starts from 0 (zero), not 1 (one). If your system has 32 Amps, the amps are numbered from 0 to 31. HashAmp() gives the max amp number and you add 1 to fi...
915 Jul 2014 @ 01:59 PDTDatabaseReplyPosition value for numeric, alphabets and blankYou can use CASE statement. CASE WHEN SUBSTR(ColumnName,1,1) <> 'B' AND SUBSTR(ColumnName,2,1) BETWEEN 1 AND 9 AND SUBSTR(ColumnName,3,1) BETWEEN 1 AND 9 THEN 'AB...
815 Jul 2014 @ 01:43 PDTDatabaseReplyAll AMP active for Updates based on primary indexhi dnoeth, I run update against view and the view is defined as locking row for access. Surprisingly, the same query in production results 1 Active Amp (as it should be), whereas in UAT its all AM...
714 Jul 2014 @ 03:54 PDTDatabaseReplyAll AMP active for Updates based on primary indexThanks Dixxie and Todd. I am running only single update at a time. My table is defined as MultiSet - I don't see why the behaviour would be different. I found out the number of Amps active f...
611 Jul 2014 @ 09:16 PDTDatabaseReplyBlank space check based on the positionPlease let us know, what exactly you want to acheive with some examples of input and desired output.
511 Jul 2014 @ 09:11 PDTDatabaseReplyExecute Query based on IF conditionIf you are using BTEQ, use dummy query to check condition:   / /*Below statement uses sys calendar table as dummy to check condition – if the condition is true, then the SQL ret...
411 Jul 2014 @ 08:59 PDTDatabaseReplyAll AMP active for Updates based on primary indexHow can rows be on every amp ? I have the primary index in where clause. Here is the explain plan:   The explain plan shows Single Amp Update.
311 Jul 2014 @ 05:16 PDTDatabaseReplyXML data - Relational table data ComparisonI faced similar situation. Either generate XML separately from tha table using your own code and compare both the XMLs OR load the XML into teradata and comapre the tables. Do let me know, if you...
211 Jul 2014 @ 05:10 PDTDatabaseTopicAll AMP active for Updates based on primary indexHi All, I am updating my tables based on primary index, however from the DBQL I see all the amps are active. Could someone explain, if this is expected ?   Cannot post the table structre fo...
111 Jul 2014 @ 04:46 PDTDatabaseTopicProlonged Responding State - for data load casesHi, I am loading data thru informatica to teradata in relational mode. i.e. the queries are are simple 'insert' and 'update' statements. All the requests are tied in BT-ET transact...