It is currently 23 Sep 2017 1:17


Post new topic  Reply to topic  [ 7 posts ] 
Author Message
PostPosted: 26 Nov 2009 1:21 
Offline
Nouveau
Nouveau
User avatar

Joined: 18 Jun 2009 12:00
Posts: 26
Location: Chennai
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


Top
   
 Post subject:
PostPosted: 26 Nov 2009 4:04 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Jun 2007 12:00
Posts: 317
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.


Top
   
 Post subject:
PostPosted: 27 Nov 2009 5:25 
Offline
Nouveau
Nouveau
User avatar

Joined: 18 Jun 2009 12:00
Posts: 26
Location: Chennai
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.....

_________________
Thanks Ravi


Top
   
 Post subject:
PostPosted: 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


Top
   
 Post subject:
PostPosted: 04 Dec 2009 10:47 
Offline
Nouveau
Nouveau
User avatar

Joined: 20 Jan 2006 12:00
Posts: 30
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


Top
   
 Post subject:
PostPosted: 05 Aug 2011 7:19 
Offline
Nouveau
Nouveau
User avatar

Joined: 05 Aug 2011 12:00
Posts: 1
Hi… that was great stuff..


sahiwal Boards Results 2014


Top
   
PostPosted: 19 Mar 2015 8:56 
Offline
Nouveau
Nouveau

Joined: 19 Mar 2015 8:52
Posts: 1
This was really some nice information for scheduler users. I am glad to read it here and thanks for sharing

_________________
PEC 5th Class Result 2015


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 7 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved