Hi All,
I am Loading multiple source files in .csv format into oracle tables.
I need to update the job control table with jobname,batchno,file name and file date information once after job is completed .
Please suggest me how to get file name ,file date ,batchno using server routine.
Which of the DSGet functions need to use to get the above fields information to store in oracle table.
Update Job Control Table using File Name,File date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How do you provide the file name to the job?
What is file date in this context?
What is batchno?
What is file date in this context?
What is batchno?
Last edited by ray.wurlod on Wed Oct 17, 2012 2:16 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 15
- Joined: Wed May 02, 2012 3:38 am
like audit history of job running
hello,
if you want to load the data into audit table. i can provide one server routine...
if you want to load the data into audit table. i can provide one server routine...