DSXchange

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.

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

hello,

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

hi venky

please provide server routine