Hi,
I have a datastage project, in which, from oracle tables, I write on sqlserver tables.
The server is on unix machine.
The insert statement, via odbc stage, doesn't work.
Among the fields target to load, there are sqlserver datetime and timestamp.
I do not know how to convert timestamp datastage in those two formats.
Please, can someone help me!?
Thank you
datastage and sqlserver: datetime and timestamp
Moderators: chulett, rschirm, roy
Hi,
You mean to say that your sources is Oracle and target is sqlserver.
In that case just take substring of 19 for the Oracle timestamp
for ex LnkFromOracle.Timestamp[1,19] assuming LnkFromOracle as your link name from oracle and Timestamp as your column name from oracle which has to be loaded to sqlserver
Thanks,
Major
You mean to say that your sources is Oracle and target is sqlserver.
In that case just take substring of 19 for the Oracle timestamp
for ex LnkFromOracle.Timestamp[1,19] assuming LnkFromOracle as your link name from oracle and Timestamp as your column name from oracle which has to be loaded to sqlserver
Thanks,
Major
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
Re: datastage and sqlserver: datetime and timestamp
Hi
use timestamp with 23,3 it will works
use timestamp with 23,3 it will works