Result set of a stored procedure

RaviKiranCH · Post by **RaviKiranCH** » 26 Nov 2009 1:21

Hi All,

One quick question..

I have a batch file where in it executes a Stored Procedure.

Can we get the result of this Stored Procedure in SYSOUT...?

Thanks

Ravi

gglau · Post by **gglau** » 26 Nov 2009 4:04

Whatever written to STDOUT and STDERR will go into SYSOUT. Check your batch script and in the stored procedure if these two output channels have been redirected else where.

RaviKiranCH · Post by **RaviKiranCH** » 27 Nov 2009 5:25

Hi,

Thanks for the inputs.

How do I check whether my STDOUT & STDERR have been redirected or not..?

Can you please make it clear with an Example.....

baralem · Post by **baralem** » 01 Dec 2009 1:58

if you are sendig the stored procedure output to a file you can use cat (unix) or type (windows) to append SP output to sysout.

regards
martin

GrahamH · Post by **GrahamH** » 04 Dec 2009 10:47

If you are on CONTROL-M EM 6.4.01 Fix Pack 2 or above, with CONTROL-M Server and Agent 6.3.01 Fix Pack 2 and above, you can use the new CONTROL-M for Databases feature. this allows you to run native SQL, SQL scripts and stored procedures against MS SQL, Oracle and DB2/UDB databases without the need for wrapper scripts, and can also capture your output into the CONTROL-M SYSOUT.

Regards.

Graham

shazmani · Post by **shazmani** » 05 Aug 2011 7:19

Hi… that was great stuff..

sahiwal Boards Results 2014

jacky0109 · Post by **jacky0109** » 19 Mar 2015 8:56

This was really some nice information for scheduler users. I am glad to read it here and thanks for sharing

Result set of a stored procedure

Result set of a stored procedure

Re: Result set of a stored procedure