DSXchange

I you cannot get the command to work at DOS, then it certainly won't work in DataStage. Do you have the MKS Toolkit or something similar installed? What kind of a program object is "xyz" and does it have an ending?

Since the UNIX level NLS_LANG setting is correct, I would look into your ORACLE setting. From SqlPlus or the tool of your choice, execute "SELECT * FROM NLS_SESSION_PARAMETERS;" to see what your database is set up as.

Exactly what conversion does this function do? Base64 (in a MIME context) is a known encoding scheme. "Binary", on the other hand, is not a specific encoding, it usually just means that the data is not in the standard displayable latin format. Do you want to convert Base64 encoded text bac...

Were they able to log back in to the other instance while the 31538 instance was down?

This talk of UNIX commands on a window server is confusing me a bit. First of all, from a DOS session, can you execute your ""/fld1/fld2/fld3/fld4/xyz *.txt" command? From TCL you would need to execute the "DOS" command, as the "SH" command calls up the /bin/sh com...

I would recommend making a VarChar stage variable "svCAT" derived by "Link_Inv_Retraite_VCN.CATEGORIES[1,2]:','" then the constraint: NOT(IsNull(Link_Inv_Retraite_VCN.ACT_INITIAL) OR IsNull(Link_Inv_Retraite_VCN.LISS_FINAL)) AND INDEX('07,15,01,16,02,',svCAT,1) This uses the INDE...

reset the job and post the contents of the "...from previous run" entry. something is going wrong in your transform stage - is that where you are calling your routine?

I'm too far away from the docs, just add a transform stage, create the column and fill it using the builtin values for the current timestamp (CurrentTimestamp and CurrentTimestampMS).

How about giving us just a little bit of a hint as to what is going wrong. Doing a cut-and-paste of your error message would be a good start.

did IBM state why the compile might be particularly slow?

Don't use the Substrings() function. What datatype is "CATEGORIES"? Use either Substr() or the Link.Column[x,y] functionality. You don't need to convert back and forth fro integer.

The Convert() and Char() functions are documented in the BASIC Programmer's Guide. This code removes all the LF (0x10) characters from a string and replaces them with nothing. In the case of fixed length fields the character is removed and a space padded to the end of the string.

Does the error happen on row 1? Where does the Dynamic stage point to?

So, Oracle was upgraded from 10g to 11g and Datastage was not changed; yet you think that the reason for this slowdown in performance is due to DataStage? Have you had a DBA check Oracle and perhaps compare Oracle speeds (without involving DataStage) in queries before/after the upgrade. If that has ...

The "substrings" function is not the correct one to use, and in DataStage strings start at position 1. the "Matches" function is also not correct or required here. Try: Not(IsNull(Link_Inv_Retraite_VCN.ACT_INITIAL)) And Not(IsNull(Link_Inv_Retraite_VCN.LISS_FINAL)) And( (Link_Inv...