MVSFORUMS.com

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

Is there any way to get the intermediate output from Stored Procedure in UDB 8.1 to a console or a file?

Regards,
Vani

kolusu · Posted: Wed Nov 05, 2003 3:57 am Post subject:

vani,

If you are writing a stored proc using a prog lang like Java, COBOL, C etc, you can use these programs features to write to a file

If you are using a SQL Stored Procedure, you can write a UDF inn one of the above languages which takes the message as the argument and writes that to the file

check this link for A UDF for File Output and Debugging from SQL

http://www7b.software.ibm.com/dmdd/library/techarticle/0302izuha/0302izuha.html

Hope this helps...

cheers

kolusu