#DateForumTypeThreadPost
1903 Feb 2015 @ 02:43 PSTDatabaseReplyCalling a teradata stored procedure by shell scriptI don't think case stmnt supports here document in unix. you can try below solution : ###file run_sp1.sh##### #!/bin/ksh TDPId=******* LoginId=******* Paswrd=*******...
1802 Feb 2015 @ 01:22 PSTDatabaseReplyBest file format supported by Teradata - FASTLOAD Basicaly teradata fastload supports following Format :   1)'Formatted' (This will be the best format for fastload/multiload). 2)'Text' 3) 'Delimited'...
1702 Feb 2015 @ 01:09 PSTDatabaseReplyCalling a teradata stored procedure by shell scriptHi Khushal, Below code will help you to acheive your requirement. ################################################################## #!/bin/ksh   TDPId=********** LoginId=...
1602 Nov 2014 @ 04:33 PSTDatabaseReplyError : A column or character expression is larger than the max size. Maximum output length of regexp_replace is exceeding. select TYPE(REGEXP_REPLACE( 'REQUESTTEXT','TEST','HELLO',1,1,'I') )  o/P: VARCHAR(8000) CHARACTER SE...
1531 Oct 2014 @ 12:58 PDTDatabaseReplylength of a stringyou can use CHARACTER_LENGTH in TD.
1431 Oct 2014 @ 12:56 PDTDatabaseReplyInvalid TimeI dont think so this can give a error.You are missing something.Can you post table ddl..??
1329 Oct 2014 @ 06:21 PDTDatabaseReplyMLOAD error code need to be capturedYou need to caputre value of SQLCODE variable not SQLSTATE variable in a procedure then you can join this table (FLOAD_ON_TABLES)  with DBC.ERRORMSGS to see the Errormsg for tha...
1229 Oct 2014 @ 04:40 PDTDatabaseReplyDate field behaving different in different environmentyou can apply format string in date field. SELECT current_date AS A ,CAST(cast(current_date as date format 'dd/mm/yyyy') AS CHAR(10)) AS B , CAST(CAST(current_date AS CHAR(10)) AS DAT...
1128 Oct 2014 @ 08:24 PDTToolsReplyTPUMP QuestionYou can't delete flat file using tpump or by any TD load utility .You need to delete flat file using sed or any unix equivalent command.
1028 Oct 2014 @ 07:49 PDTDatabaseReply[6760] Invalid timestampYou need to bring both side to same data type. WHERE CAST(col AS DATE) = CAST('14/11/2012' AS DATE FORMAT 'dd/mm/yyyy')  
904 May 2014 @ 11:20 PDTGeneralReplyTPT handling the CSV with date and timestamp columntry this:     :ROW_TIME(TIMESTAMP(0),FORMAT ''YYYY-MM-DDbhh:mi:ss'') if this doesn't help then please paste entire script and logfile.
808 Feb 2014 @ 09:59 PSTDatabaseReplyQuestion regarding Fastload @singhabh....jitlumar:   Q:how to load files with enclosing data values  ?   Ans: if you want to load encolsing value you can specify following attrbiutes in TPT&n...
723 Jul 2013 @ 12:29 PDTDatabaseReplyLoading Fixed Width File using Teradata SQL Importyes i am sure.
617 Jul 2013 @ 11:50 PDTDatabaseReplyI want to separate the full name in two parts Hi, you can use INITCAP function if your on TD 14 else try to install oracle UDF from developer exhange.    eg: SEL INITCAP('nILESH'); SEL INITCAP('bHAW...
517 Jul 2013 @ 11:32 PDTDatabaseReplyLoading Fixed Width File using Teradata SQL ImportHi, You cannot  import or export Fixed Width File using Teradata SQL    because SQL assistant accepts delimited file  only. you can use bteq import if file is small ...
430 Apr 2013 @ 03:00 PDTDatabaseReplySecondary indexesyou can use PPI also but for that you will need to create new table with PPI define on that  and you have to do insert select from the old table to use PPI.it will help you in future when you ...
330 Apr 2013 @ 02:27 PDTDatabaseReplyAbout Partitioned Primary Index (PPI)hi, you do not need to add the field People_Subscription_Start_DT in PPI. yes you need PPI if you want to add range.
230 Apr 2013 @ 02:18 PDTToolsReplyTPT with named pipedid you exported the file from windows to linux or vice versa...?...you will get this type of error when  file  contians bad character like ^I,^M this usually happens when you transfer f...
124 Sep 2012 @ 11:51 PDTDatabaseReplyQuery Execution Error Teradata SQL Assistant 13.10 hii pradeesh, im also getting th same error  "Object reference not set to an instanc of an object" Unexpected Error.Refer to the following file for details: C:\Users\----\AppDat...