DSXchange

Jerome, it wouldn't make sense for the filter to be quicker with smaller volumes; I'll take the Redbook entry at face value and admit that the transform stage will be faster than the filter stage. Since transforms are compiled into c++ routines they will be relatively quick at runtime, but the datat...

What failover mechanism have you implemented in AIX and in your database - these determine what sort of failover you can do in DataStage.

No, I do not think it is; the filter stage will be more efficient than putting a in transform stage with constraints.

Craig's link looks like a likely candidate for the error. "chmod -r" here we come...

There are DataStage Server routines to let you get the number of rows passing through specific links, they require a bit of programming. You could also use scripts to search through the job log and parse out the appropriate values, that might be simpler. Which method you use depends upon what you wa...

I've not encountered anything like your error before.

If you create a test project and create a test job in that do you also get the same error in that project? If so, it might be worth thinking about biting the bullet and re-installing DataStage from scratch.

Looks like you have hit on a limitation in the stage. Can you convert the decimal to a string prior to the SCD stage and see if that works?

Are the jobs that give this error job sequences or also normal server jobs?

Can you see if that changes when you explicitly make strings in the cells, i.e. '="2012-09-12"'?

How is that column being used in your SCD stage?

ODBC and Excel connections are problematical, at best. ODBC will determine the clumn datatypes dynamically, using the first couple of rows (this number can be adjusted in the ODBC settings). Thus a column that you think holds a date might be delivered to DataStage as a string or a number - and the n...

If you change your code to read Deffun DSRMessage(A1, A2, A3) Calling "*DataStage*DSR_MESSAGE" *Common /HashLookup/ FileHandles(100), FilesOpened Common /HashLookup/ FileHandles FileOpenStatus = 0 CALL DSLogWarn('--> At beginning of BeforeJobRoutin <--','') * If InputArg is empty, log a Wa...

If you look at the error message it states that the problem is occuring while converting from APT_Decimal to IntegerU64. This is an unsigned big integer and I suspect you are forcing this conversion somewhere. - Check the datatypes to ensure that you aren't forcing this conversion - Turn off operato...

What data type is "srchQueryDateRange " and what is the derivation for it?
the if-then-else construct you posted can't be used as the derivation for the stage variable. Also is "dateFormat" a parameter to your job?

There are very many different mappings possible when coming from mainframes, particularly for Japanese. Nobody here can tell you, you need to find out from the mainframe people which one they used; and possible also if there was any mapping done during the Mainframe -> DS Server FTP process.