IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2-Query execution thru a batch job


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Asokrani

New User


Joined: 08 Jun 2007
Posts: 18
Location: Connecticut

PostPosted: Wed Jul 11, 2007 12:36 am
Reply with quote

Hi ,

I would like to know how to submit a QMF batch job to get the execute the query ...Because when i submit a query in foreground its taking longer time and the estimation is going beyond 3000.


Thanks
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Wed Jul 11, 2007 3:26 am
Reply with quote

DB2 batch queries can run like this. DB2SS needs to be changed to subsystem you want to query.

Code:

//     JOBCARD
//*
//JS02 EXEC DSNTEP2,DB2=DB2SS,COND=(4,LT)     
//DYNSQL.SYSPRINT DD SYSOUT=*                 
//SYSIN    DD *                               
   SELECT *                                     
   FROM OWNER.TABLE
   WHERE  Conditions
/*                                           
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to get a stack trace on a looping... ABENDS & Debugging 5
No new posts Calling Java method from batch COBOL ... COBOL Programming 5
No new posts RC query -Time column CA Products 3
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Help in Automating Batch JCL jobs mon... JCL & VSAM 3
Search our Forums:

Back to Top