how to write data from stored procedure to a file

mn_sudeep · #1 (**permalink**) 01-18-06, 03:37

hi
i have written a stored procedure in db2 v 8.2 using SQL. now i write the data into a temporary table in the data base. i want to write it into a file. how to do this in the stored procedure? can anyone help me?
thanks in advance
sued

ritz · #2 (**permalink**) 01-18-06, 04:21

Hi,

One way you could achieve this would be writing a user defined function in LANGUAGE C and then invoke this function in your SQL procedure.

HTH
Ritz

sathyaram_s · #3 (**permalink**) 01-18-06, 05:30

You can find an example at
http://www-128.ibm.com/developerwork...0302izuha.html

Using a Java UDF is another option

HTH

Sathyaram

Quote:

Originally Posted by ritz

Hi,

One way you could achieve this would be writing a user defined function in LANGUAGE C and then invoke this function in your SQL procedure.

HTH
Ritz

Internet Services

Web Development

Digital Marketing

Consumer Tech