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 Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Need help in triggering a PL1 module ... Varungv99 IMS DB/DC 0 Fri Apr 07, 2017 10:01 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm


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