DSXchange

The modify stage is the original Orchestrate stage that allowed modification of column values, the transform stage came afterwards. They have a number of similarities; while the modify stage is an OSH call, transform stages are compiled c programs that are executed at runtime.

Your data is stored in UTF16 in the database so it would be best to set your NLS_LANG to the same and also specify that in your Oracle stage.

What UNIX platform are you on?

It is the "Universe Shell" that you are looking for, now renamed to the "DataStage shell". From the UNIX command line, ensure that you have sourced the 'dsenv' script, 'cd $DSHOME', then 'bin/dssh' to enter the environment. Beware that this is the central account and you can easi...

The error is not, as I had somehow thought from the error message, in the configuration file. What flavor of UNIX are you working on, while the posted suggestion should work I've never had to explicitly set this value as normally the working directory value is set correctly by the OS.

What are your runtime environment settings for NLS_LANG and ORA_NLS?

I suspect the answer lies in your APT_CONFIG file, please post it.

You could use database tables or re-engineer your processes to use datasets.

How is the data coming from the mainframe - that step might be your bottleneck, in which case any improvements to your DataStage jobs wouldn't increase throughput.

You've done a great job putting together a dynamic array but have chosen to use a loop instead of the very powerful LOCATE statement. Here's my suggestion: ... CountryCodes.Arr = CONVERT(",", @FM, ISO_CountryCodes) ; * Convert List to array LOCATE mailExt IN CountryCodes.Arr SETTING Ans EL...

Ok, now you've eliminated the Mainframe and the AIX machine from the equation, as you are seeing the 0xA2 character in your sequential file. If reading this with ISO-8859-1 then DataStage is almost certainly getting the correct character. Try writing a dummy program to read this file and output to a...

What stage are you using for Oracle and what are your NLS environment settings for Oracle?

As Priyad has already stated, you cannot update contents of a dataset. This would be a good case for using a table or multiple dataset files along the lines of what anbu has written.

I'm not sure of the syntax of your locsite command, if it means that the FTP should convert from IBM-037 to ISO 885-1 then your cent character should be 0x4a in the source (see http://www-1.ibm.com/servers/eserver/iseries/software/globalization/pdf/cp00037z.pdf) and 0xA2 after FTP. First off, locate...

With a partitioned DB2 database you may use DB2 partitioning, but it is not required. Using it will give you better performance in parallel reads and writes, though.