#DateForumTypeThreadPost
922 Jan 2012 @ 05:43 PSTDatabaseReplyINTEGER/BYTEINT accumulation and presentation Hi ,  Are there any changes in TD13 release ? We also faced similar issues , wherein value of 960 converted it to value -64 ( ripping in multiples of 256) , in TTU12 but when it was mig...
830 Jul 2011 @ 10:55 PDTTrainingReplyTeradata 12 CertificationHi All, Anyone given the TE0-121 Teradata Basics recently ? Can you please share if the WBT(Introduction to TD ) is enough for the exam prep ? Thanks.
730 Jul 2011 @ 10:46 PDTDatabaseReplyColumn compression and Table header sizeHi Dieter & Teradata Gurus, What is the maximum row length in TD 12 allowed ? & I am creating the below table, and get the error msg (Maximum Possible row length in the table is too large ) & i...
626 Apr 2011 @ 12:17 PDTDatabaseReplyCase When Statement in TeradataHi Dieter, I have a small doubt .Request your help - Supose i have the below query with 1 insert and 7 select statements with UNION ALL clause b/w them.The FROM and the where clause is identic...
525 Apr 2011 @ 12:48 PDTUDAReplyCASE StatementI have a Insert select query like - Insert tatement - 7 Select query with UNION ALL clause between them .All the SELECT CLAUSE have identical , FROM AND WHERE CLAUSE CONDITION. (FCF01 being chan...
420 Mar 2011 @ 05:59 PDTGeneralReplyTeradata XML services--Help needed with XML ShreddingAnd executing the abpve statement,gives the error "Cant connect with database.",after replacing userid,password and databasename.Any suggestions please ? call sysxml.gen_db_canonical_schema('da...
320 Mar 2011 @ 05:52 PDTGeneralReplyTeradata XML services--Help needed with XML ShreddingHi , I am trying to execute the following statement,and it is going for sleep,and finally i have to abort to get out of it from SQA.According to Orange book,it should ask for a file to save the ...
213 Mar 2011 @ 11:57 PDTToolsReplyLoading XML dataHi All, I need some help on xml services,for shredding & publishing , it will b eof great hep if someone can provide basic steps and a sample code. Regards Shobhit
112 Feb 2011 @ 12:28 PSTDatabaseReplycode check well i m not sure if there si a faster way to find out the max,other than using max function,but as suggested above try replacing disitinct with group by and remove trim clauses in the where clause...