Hi,
Before you establish connection to datastage,
call sqlplus in shell script,
alter the session in shell script
and then call datastage job using dsjob in shell script.
Ketfos
Inserting Oracle Date and Time data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Jun 04, 2004 2:30 am
- Location: Melbourne, Australia
- Contact:
I would use the TO_DATE function personally, but if you can't you will have to use Iconv and Oconv:
Code: Select all
Oconv(Iconv(YourDate, "D-YMD[4,2,2]"), "D-DMY[2,A3,2]")
Cheers,
Dave Nemirovsky
Dave Nemirovsky
Exactly! Set the data type to Date or Timestamp and the Oracle stages will automatically use the appropriate TO_DATE function. That's why it's important to make sure the fields are properly formatted before they hit the output stages. BTW, as noted, only two digits for the seconds are allowed in an Oracle DATE field.
It's all in the pdf documentation for the various stages, you'll find them in the 'Docs' directory under your client install directory.
It's all in the pdf documentation for the various stages, you'll find them in the 'Docs' directory under your client install directory.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers