InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 21:14:36 GMT20http://www.teradata.com/teradataforum/Topic15922-10-1.aspxI would not be able to cast it as the SQL is generated dynamically. I thought to cast it to char with length based on column length from the table, but since I see that it is 4, that is also had to to be dropped.Fri, 26 Jun 2009 06:28:13 GMTprajithvarreirhttp://www.teradata.com/teradataforum/Topic15922-10-1.aspxHello,Integer-date has a length 4, there is no issue with that. Try by casting it to CHAR/VARCHAR, that should solve the issue.HTH!Regards,AdeelFri, 26 Jun 2009 05:49:36 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic15922-10-1.aspxI have some issues with TD Export command. The SQL I use in export command is SELECT BUSINESS_UNIT ,' | ',EFFDT ,' | ',EFF_STATUS FROM ABC The output of this is spooled to a file called ABC.txt. $ head ABC.txt01454 | 06/0 | A | 01731 | 06/0 | A | G0360 | 06/0 | A | 01700 | 06/0 | A | 01810 | 06/0 | A | 01500 | 06/0 | A | When I run the query in query man, I get correct data. Result set attached below01454 | 01/01/2006 | A |01731 | 01/01/2006 | A | G0360 | 01/01/2006 | A | 01700 | 01/01/2006 | A | 01500 | 01/01/2006 | A | Interestingly, when I check DBC.COLUMNS, I find that this date field is has a column width 4.ColumnName ColumnType ColumnLengthBUSINESS_UNIT CV 5EFFDT DA 4EFF_STATUS CV 1Code Snippet of the BTEQ script as follows/****************************************************************************************Set the export file as table name with extension as .txt****************************************************************************************/.SET FULLYEAR ON;.EXPORT DATA FILE=$TABLE_NAME.txt/****************************************************************************************Run the select statement in the file created by shell script****************************************************************************************/. run file $COL_FILE_NAME.SET FORMAT OFF;.EXPORT RESETFri, 26 Jun 2009 05:40:02 GMTprajithvarreir