Writing data into a text file using Stored Procedure

[Praveen_db2]

Hi all

Db2 8.1.3 windows
Is there any way to write data into a text file using a stored procedure?
The way we return a cursor output to the calling application, can we
return data in a text file?

Regards
Praveen

[jefftyzzer]

See Serge's reply to the posting titled "CREATE TRIGGER -writing to
file???"--perhaps that recommendation will apply to your situation.

--Jeff

Praveen_db2 wrote:

Hi all

Db2 8.1.3 windows
Is there any way to write data into a text file using a stored procedure?
The way we return a cursor output to the calling application, can we
return data in a text file?

Regards
Praveen

[4.spam]

Hi.

I do this by my own java SP.
It looks like
call logger('any_valid_select_clause', 'file_name_on_server',
'encoding', ?);
where '?' is for output varchar parameter if something goes wrong.
This works on LUW and iSeries.

Sincerely,
Mark B.

Hi all

Db2 8.1.3 windows
Is there any way to write data into a text file using a stored procedure?
The way we return a cursor output to the calling application, can we
return data in a text file?

Regards
Praveen