|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/9/2008 8:36:14 PM
Posts: 8,
Visits: 176
|
|
Hi,
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?
Thanks
Rajiv
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:12:49 PM
Posts: 117,
Visits: 231
|
|
if you are using BTEQ
.SET SEPARATOR 'string'
BTEQ manual has an example for .set separator "|".
Shaw
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 8/26/2008 4:53:36 PM
Posts: 50,
Visits: 220
|
|
you may use code like this too.
select cast(
CUST_ID||'|'||
CUST_NAME||'|'||
...
...
UPDATE_DATE||'|'||
UPDATE_TIME
as char(250))---(must be big enough to hold all columns plus commas)
from CUST
|
|
|
|