#DateForumTypeThreadPost
1101 Sep 2013 @ 05:49 PDTDatabaseReplyDoes Teradata support database/schema aliasesHi,   Can you please elaborate on the Query? From the understanding it seems that You need to populate data into Schema/DB Prod from Test Schema/Db. If the owner of the Procedure has access ...
1031 Aug 2013 @ 03:22 PDTDatabaseReplyColumnName is missing with error messagesHi, You can't find out which field would give the Invalid Timestamp. Instead, you have to select each field and try to do the cast function.    SELECT cast(col2_dt as timestamp(0...
924 Aug 2013 @ 03:51 PDTDatabaseReplyWhich column should i select for Index creationHi, The PI of the column is choosen in Teradata for the Data Distribution. We can get the No of AMP's using this hashamp function. SEL HASHAMP()+1 -- This will give the No of Amps present in...
823 Aug 2013 @ 11:30 PDTDatabaseReplyLike Operator in TeradataHi Dieter, I didn't post the question. I just replied saying we can use TRIM. Very valuable information about the dbc.columnsV & dbc.columnsVX. I am actually working in TD 13. When i see ...
723 Aug 2013 @ 11:25 PDTDatabaseReplyCASE Statement -- CASE <expression>Hi Jackson, Your query is that. You are having an Table with column as A and i am having Sample like this, '0  ','ABC','DEF',etc. I should get the output as  NU...
623 Aug 2013 @ 11:14 PDTDatabaseReplyvolatile table as select..with data - not loading data Hi,    The modified update query is this, You are actually joining the Update table with the Source table. When you actually update an table, the table itself joined. Usually I...
523 Aug 2013 @ 10:58 PDTDatabaseReplyvolatile table as select..with data - not loading data Hi,   From what i see and understood from the query is that You want to Join the Temp1 table & SOmetable with date. Please find the modified query, You are selecting 2 columns from...
421 Aug 2013 @ 04:18 PDTDatabaseReplyImproper column reference in the search condition of a joined table SELECT DATE as SYS_DATE, T1.KSN_ID, T1.ITEM_ID, T1.DVSN_NBR, T2.CAN_CARR_MDL_ID, T2.NETWORK_DISTRB_CD, T3.KM_DAY70_CHK_STR_QTY, T5.LOCN_NBR,T5.SERV_DC_NBR, b.DC_CD, c.THIRTEEN_WK_FRCST, ...
320 Aug 2013 @ 09:13 PDTDatabaseReplyLike Operator in TeradataHi,  You can use the Query like this,  SEL * FROM DBC.COLUMNS WHERE DATABASENAME LIKE 'H%' AND DATABASENAME LIKE '%DB'; From My understaing, the Problem in the Query is...
218 Aug 2013 @ 11:38 PDTDatabaseReplyHow to define ARRAY of varying length? Hi Avi,   I didn't understand the Question Properly. The question from you must be The Array is of size VARCHAR(100) in length and the no of Array Elements would be passed in Ru...
117 Aug 2013 @ 12:19 PDTDatabaseReplyIssue with Number data type in Teradata 14.0Hi Suresh, In Teradata, We don't have NUMBER datatype prior to TD 14 instead we have Decimal Datatype which is more equivalent to Number datatype in Oracle. AS you  have mentioned,the Da...

Pages