I am wanted to obtain a pipe delimited output while reading from hashed file
Code: Select all
dssh << EOF > $filename
select * from hash;
>EOF
Is there anything similar to as
Code: Select all
set colsep '|'
Moderators: chulett, rschirm, roy
Code: Select all
dssh << EOF > $filename
select * from hash;
>EOF
Code: Select all
set colsep '|'
Code: Select all
SELECT col1, '|', col2, '|', col3 FROM hashedfile;
Code: Select all
SELECT TRIM(CAST(col1 AS VARCHAR)),'|'.TRIM(CAST(col2 AS VARCHAR)) FROM hashedfile;