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
Inserting SYSDATE and Jobname to Oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Last edited by ray.wurlod on Fri Dec 02, 2011 12:42 am, 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.
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: