A query on SELECT statement in DB2

**rajath26** · Aug 3 '10, 09:14 AM

I am retrieving 5 rows from a table in a DB2 database and while I issue the SELECT I wish to have the data come in this format:

<Row1Col1>,<Row 1Col2>,<Row1Col 3>,<Row1Col4>,< Row1Col5>
<Row2Col1>,<Row 2Col2>,<Row2Col 3>,<Row2Col4>,< Row2Col5>
............... ............... ..
.
.
.
.

Is there anyway I can do this with SELECT? I don't want to use EXPORT( DEL files have this format ) since I dont want to create a temporary file in between and I want to directly output SELECT result to an operating system pipe.

Thanks in advance for you help.

Regards,
Rajath