By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,786 Members | 1,131 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,786 IT Pros & Developers. It's quick & easy.

Writing data into a text file using Stored Procedure

P: n/a
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
Aug 29 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Aug 29 '06 #2

P: n/a
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
Aug 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.