Stored Procedure

[Aditya Tiwari]

Hi,
sorry to post same kind of questio again but i am new to this forum and do not know how to make a reply.
Here is my senario.

I want to read data from some tables and put them into a file(Tab delimineted file).
Later on i want to rad that file.
What could be the solution. Should i write procedures for that. If yes then how to write a procedure which will give o/p as a file and how to read a file from stored procedure.

Also help me how to reply to any query.:)

[Knut Stolze]

Post by Aditya Tiwari
Hi,
sorry to post same kind of questio again but i am new to this forum and do
not know how to make a reply. Here is my senario.
I want to read data from some tables and put them into a file(Tab
delimineted file). Later on i want to rad that file.
What could be the solution. Should i write procedures for that. If yes
then how to write a procedure which will give o/p as a file and how to
read a file from stored procedure.

You should not rely on files external to DB2 for something like that because
you have all sorts of problems:
- concurrency: access to the file must by synchronized
- no transaction control
- no buffering (besides file system cache)
- no backup/recovery mechanisms (besides DB2-external tools)

You should simply put the data in another table and the 2nd procedure
accesses this table.