Update Job Control Table using File Name,File date

DSRajesh · Post by **DSRajesh** » Sat Aug 11, 2012 11:01 am

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.

ray.wurlod · Post by **ray.wurlod** » Sat Aug 11, 2012 4:57 pm

How do you provide the file name to the job?
What is file date in this context?
What is batchno?

venkateshrupineni · Post by **venkateshrupineni** » Wed Oct 17, 2012 6:54 am

hello,

if you want to load the data into audit table. i can provide one server routine...

DSRajesh · Post by **DSRajesh** » Tue Nov 13, 2012 3:35 pm

hi venky

please provide server routine

DSXchange

Update Job Control Table using File Name,File date

Update Job Control Table using File Name,File date

like audit history of job running