Hello,

I am trying to solve a problem to redirect output from a sql command to a delimited file

I am doing

db2 connect to $database user $username using $password
db2 select * from x > file.out
db2 terminate

I am struggling to get an option that allows me to write to a delimited file(file.out). The default is it is writing in a fixed width flat file

Could any of you please help me in this

any help is greatly appreciated

Thanks

Try the export command. See the Command Reference for the correct options to get a delimited output file.

Thanks for the repply
I could use the export , but the export has to have different set of privilages which I dont have.
the other thing is export is creating a file on the DB Server , which I dont have privilage to

so I am forced to create this wey

Thanks for the repply

Try:You may need to convert numeric and date/time fields to their character representations for the concatenation to work.

Thanks
This should work