Teradata Forums / Data Warehousing / Teradata / How to get Output as a pipe delimited file? / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 20:22:04 GMT20RE: How to get Output as a pipe delimited file?http://www.teradata.com/teradataforum/Topic10988-1-1.aspxyou may use code like this too.select cast(CUST_ID||'|'||CUST_NAME||'|'||......UPDATE_DATE||'|'||UPDATE_TIMEas char(250))---(must be big enough to hold all columns plus commas)from CUSTThu, 20 Mar 2008 13:25:35 GMTSomeshRE: How to get Output as a pipe delimited file?http://www.teradata.com/teradataforum/Topic10988-1-1.aspxif you are using BTEQ .SET SEPARATOR 'string' BTEQ manual has an example for .set separator "|".Thu, 20 Mar 2008 12:59:04 GMTShawHow to get Output as a pipe delimited file?http://www.teradata.com/teradataforum/Topic10988-1-1.aspxHi,I wrote a SQL in Teradata and the report needs to be in the pipe delimited format.I was told that I need to add another select with all the column names seperated with pipes (||) to get that.Can't really find any info.Can someone help me with this?ThanksRajivWed, 19 Mar 2008 19:06:10 GMTRajivTx