Time datatypes

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Time datatypes

Post by admin »

Hello! I am now having a problem with timestamp datatypes in SQL Server and DataStage.

Both my source and target tables are SQL Server tables, and each has a field that is of smalldatetime, size of 4. When I read the metadata in for these tables, DataStage translated a smalldatetime of 4 to a timestamp of 16.

If I change the metadata in my source and target stages to be a timestamp of size 4, it tells me that there is a metadata mismatch. If I leave everything as a timestamp of 16 in DataStage, I then get the error message that there is an "invalid cast character". I tried using the Oconv/Iconv to see if that would help, but it didnt.

Any ideas?

Thank you so much!!

Lola



Lola M. Ball
netLibrary, Inc.
3085 Center Green Drive
Boulder, CO 80301
Direct 303.381.8922
Fax 303.381.8900
Email lball@netLibrary.com
Locked