datastage and sqlserver: datetime and timestamp
Posted: Wed Dec 22, 2010 5:36 am
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
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