pipe delimited output from dssh

[mystuff]

Hi there,

I am wanted to obtain a pipe delimited output while reading from hashed file

Code: Select all

dssh << EOF > $filename
select * from hash;
>EOF

looks likes this file generates a tab-delimited output. I wanted a pipe-delimited output. I can't replace tabs with pipes, as the data might contain tabs.

Is there anything similar to as

Code: Select all

set colsep '|'

[ray.wurlod]

DataStage/SQL does not generated delimited output at all - it generates fixed width output.

To get pipe-delimited, the only way is to generate the pipe characters yourself.

Code: Select all

SELECT col1, '|', col2, '|', col3 FROM hashedfile;

Even then the data columns will be fixed width as specified in the file dictionary, so you may prefer to trim them (if the data type is Char or VarChar, or CAST before applying trim function). In the worst case:

Code: Select all

SELECT TRIM(CAST(col1 AS VARCHAR)),'|'.TRIM(CAST(col2 AS VARCHAR)) FROM hashedfile;