DSXchange

What is your target. WHat the length in your source and target?

What solution is it? What same solution? Kindly Share.

For some odd reason Db2 UDB is behaving like this. But no sweats, a simple change of sql type gets the work done.
Thanks for your help and time guys.

Sorry Craig, that was a typo, I meant DML changes. The error message i am getting is [IBM][CLI Driver] CLI0114E An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007 This is when the sql type is set to timestamp and high nines are s...

O yes it would Craig. Even i was dazzeled at first why it wasnt accepting a true high nine timestamp. After a little bit of research, i found that, that particular column had a default value of high nines and maybe thats the reason its not accepting it. As i mentioned earlier, if i send even a nano ...

I wrote a routine once to add days, hours, mins, seconds, upto milliseconds. Click here and check out the very last post. As for adding months, its really depends upon your own requirements. Adding a month could mean adding either 30 days or 31 days or 28 days for Feb, OR it could mean just incremen...

Welcome Aboard Restartability has nothing to do with the scheduling piece. Restartability is something you design into your sequence. "Reset if required and then run" just tells DSEngine what to do. If a reset is required, the job will be reset and then run. If a sequence is controlling jobs then ch...

Put a PRINT Output right before the if statement. What's the value of Output?
Also make sure, as Craig mentioned, the file truely is of 0 bytes. Go to the unix level , do ls -ltr and check out the size of that file. Even if the file has column names, it will not be considered an empty file.

remove the quotes from 'type c:\parameters.txt' . I am not too familiar with DOS batch commands but basically you need an equivalent of echo. Does type do that?

Well the column is not nullable. And it wont work if i supply NULL. The only way system generates timestamp is if nothing is passed for that column. I cant do that.
Well, thanks Ray for your input. I think i have to stick to my workaround.
Regards,

It is some sort of access violation, thats what the error message states. Try to do an exact search on "Exception raised in GCI subroutine". You will see that this topic has been covered a lot here.

How can you be sure , then, that the abort is due to the hashed file? What exactly are you doing in the transformer stage? We need more info on your design so that we can pin point the problem, instead of us guessing what exactly is going on. That will be possible in the Hawk version which is equipp...

What other error message do you get?
It could be a number of reasons.
Do you have write permissions to that network?
Have you reached the 2GB limit for the hashed file?

Since its coming from a flat file. ISNULL() wont work. It doesnt work at times on flat files. Use the Len() function.
What Length does it give for empty column?
I mean from this row
20000000 ; 0 ; 0 ; 0 ;

Seems Odd. Try putting in a trim. If IsNull(field(trim(lnk_In.CF_String),";",5)) Then DateGenericToODBC(RunDate) Else DateGenericToODBC(field(trim(lnk_In.CF_String),";",5)) Also try If Len(field(trim(lnk_In.CF_St...