DSXchange

Great search Rob. That ought'a tone things down a bit.

No doubt. Within no time we shall be talking in femto and atto seconds. Zepto and yoctoseconds are not far off either.

Are you loading into a table or a simple flat file?

Where exactly are you getting stuck? As Craig suggested, go into the source code of UtilityHashLookup() change the specific code and make your own routine. Here ill help you with that. ************************************************************************* * Copyright (C) 2004, 1997-2003 A...

Please search (Exact) on key words "Row out of sequence"

Try inserting just one record from your favourite tool, other than datastage, or maybe from command line. See if it gives the same error. If it does then you need to report this to your dba so that he/she can make that table writable.

Hehe, i think we are trying to prove the same thing. THats exactly what i said, SqlServer stores milliseconds and Db2 microseconds. Ah what the hell, Potato Potaato, same thing

I am pretty sure Craig. Check thiswebsite out. Scroll down to the heading "Precision". It has a table layed out for timestamp precision for Db2, Oracle and SqlServer.

chulett wrote:Closer... milliseconds.

Really, I was under the impression that SQLServer stores milliseconds (length 23) and DB2 stores microseconds (Length 26).

Yea, it does sound cool doesnt it. But corrections, nano is a billionth of a unit. Micro is a millionth of a unit which DB2 stores. So, my apologies. Db2 will add the microseconds upon insert.

ICE wrote:But I can run that sub-job by using batch job and also I can run the calling job itself.

Ok, i guess i missed that part. But it does look wierd. Well guess the value is being passed with thos 'back ticks'. Need more info from the OP.

Looking at the error message, it looks like its coming from a database stage. So the problem is in one of his jobs, where he needs to surround parameter names with hashes.

Didnt you get your problem resolved here

Enclose the parameters within hashes (#).

What do you mean by DataStage format??? If you mean internal format then it can be manipulated with OCONV. For time, again, use ICONV/OCONV functions with "MTS". But MTS doesnt handle anything lower than seconds. DB2 will add the nano seconds.