Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Triggering a job based on a DB2 table entry

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
sgiri
Warnings : 1

New User


Joined: 07 Aug 2007
Posts: 20
Location: chennai

PostPosted: Fri Jun 05, 2009 2:56 pm    Post subject: Triggering a job based on a DB2 table entry
Reply with quote

Guys,

I need to trigger an Annual job based on a DB2 table entry.
The Db2 table entry can happen any time in a year and the job has to be triggered exactly after 60 days from the date of the table entry.

The catch here is , we cannot use a daily job to check whether the DB2 entry has occured or not.

Is there a way to create such a job..
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Jun 05, 2009 3:07 pm    Post subject:
Reply with quote

How is the table update actioned
Back to top
View user's profile Send private message
sgiri
Warnings : 1

New User


Joined: 07 Aug 2007
Posts: 20
Location: chennai

PostPosted: Fri Jun 05, 2009 3:53 pm    Post subject:
Reply with quote

The table is updated by a cobol program.
The program checks for a certain condition, which occurs only once a year. Based on that it inserts the value into the table.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Jun 05, 2009 3:56 pm    Post subject:
Reply with quote

Can you not set a return code through the program to indicate that the update was performed, and then using conditional execution process a batch interface to the scheduling software to schedule the required second job in 60 days time ?
Back to top
View user's profile Send private message
sgiri
Warnings : 1

New User


Joined: 07 Aug 2007
Posts: 20
Location: chennai

PostPosted: Fri Jun 05, 2009 4:06 pm    Post subject:
Reply with quote

Can you pls elaborate more on setting a return code through the cobol job. I have never set it before..
Back to top
View user's profile Send private message
GlobalGyan

New User


Joined: 31 Jan 2006
Posts: 28

PostPosted: Fri Jun 05, 2009 4:32 pm    Post subject:
Reply with quote

QW RETURN-CODE
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Jun 05, 2009 4:39 pm    Post subject:
Reply with quote

Quote:
cobol job
Not COBOL job, using COBOL program
Code:
MOVE desired-RC TO RETURN-CODE.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Jun 05, 2009 4:47 pm    Post subject:
Reply with quote

GlobalGyan wrote:
QW RETURN-CODE
Only if MVS/QuickRef is installed.
Back to top
View user's profile Send private message
GlobalGyan

New User


Joined: 31 Jan 2006
Posts: 28

PostPosted: Fri Jun 05, 2009 4:52 pm    Post subject:
Reply with quote

Anuj Dhawan wrote:
GlobalGyan wrote:
QW RETURN-CODE
Only if MVS/QuickRef is installed.

Oh yes... true...

Are there systems where MVS/Qref not installed? What are the alternate solutions to this
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Jun 05, 2009 4:54 pm    Post subject:
Reply with quote

GlobalGyan wrote:
Are there systems where MVS/Qref not installed? What are the alternate solutions to this

Of course there are.

Reference manuals are the usual method of obtaining information.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Jun 05, 2009 4:57 pm    Post subject:
Reply with quote

Or google... mmmm...may be goggle...sorry for fast fingures... icon_wink.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jun 06, 2009 12:26 am    Post subject:
Reply with quote

Hello,

Quote:
The catch here is , we cannot use a daily job to check whether the DB2 entry has occured or not.
By what rule/requirement? Sounds like nonsense. . .

I suspect that something could be added to an already existing daily process and not require an entire new job. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
This topic is locked: you cannot edit posts or make replies. Job to wait and continue based on reply yugendran COBOL Programming 5 Wed Oct 05, 2016 1:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us