All,
We currently don't have a distributed systems scheduler, but working on it, and we are trying to set dependancies between Mainframe Jobs and DataStage. Right now we can use FTP's to trigger things back and forth, but that is a lot of work. We were thinking of using tables, where a MF job would set a flag indicating it is done processing and DS would read the table for that process flag and check to see if it can process (kind of like the Wait for File). I believe I can read the table and then do a NAP in DS to wait and then read the file again, however, I am assuming that I would need to do this in Job control, but don't know how to code a Table Read in DS BASIC. Can anyone help or have a different idea of how to do this? Thanks.
JB
Dependancy Checks
Moderators: chulett, rschirm, roy
JB,
a couple of ideas are outlined in: http://www.tools4datastage.com/forum/to ... C_ID=84730
Hope this helps!
Stephan
a couple of ideas are outlined in: http://www.tools4datastage.com/forum/to ... C_ID=84730
Hope this helps!
Stephan
Hi,
you don't need to know how to use ODBC via batch job, though I implemented this a few times.
simply build a job which sets user status in a transformer dpending on the data read from the table.
then use a batch/control job written in DS Basic to run that job in a loop (with sleep) till the user status returnd says GO.
Good luck,
Roy R.
you don't need to know how to use ODBC via batch job, though I implemented this a few times.
simply build a job which sets user status in a transformer dpending on the data read from the table.
then use a batch/control job written in DS Basic to run that job in a loop (with sleep) till the user status returnd says GO.
Good luck,
Roy R.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: