Hi,
I am trying to load a Timestamp into a UDB table using the following and I get the warning message below.
(OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:"))
WARNING MESSAGE:
TPA_CONTACT_PROCESSING..Dynamic_RDBMS_6: [DataDirect][ODBC DB2 Wire Protocol driver]Timestamp parameters with a scale, must have a scale less than ten and a precision equal to 20 plus the scale. You specified a precision of 26 and scale of 3. Error in parameter 26.
The Timestamp looks like this in UDB:
2005-10-13 13:27:36.934938
Thanks - - John
UDB Timestamp question
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Where are you deriving the microseconds. DataStage's Time() function only delivers milliseconds - you need the System() function to deliver microseconds (and, even then, the operating system must support microseconds, and you may need a routine so that you can set $OPTIONS appropriately).
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: 306
- Joined: Wed Jun 21, 2006 11:41 am