Inserting SYSDATE and Jobname to Oracle table

vskr72 · Post by **vskr72** » Thu Dec 01, 2011 1:41 am

I am loading an Oracle table with daat from a SEQ file. THe table need a Sysdate and Job_name. Is it possible to derive these without using transformer stage? Just curious?

Kumar

major · Post by **major** » Thu Dec 01, 2011 6:17 pm

hi,

In your case the only other way is to populate sysdate and jobname in the seq file which you are loading to oracle table.

Thanks
Major

ray.wurlod · Post by **ray.wurlod** » Thu Dec 01, 2011 6:18 pm

SYSDATE yes.
JobName yes.

But only if you use user-defined SQL in the database stage, with SYSDATE specified explicitly and the JOBNAME hard-coded from the job that it's run from.

chandra.shekhar@tcs.com · Thu Dec 01, 2011 11:35 pm

Since you are using a Sequential File as a source, I dont think so that you can populate sysdate and jobname except in Tfr.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 02, 2011 12:42 am

Read my response again carefully.