DSXchange

Setting DSHOME should be sufficient.

APT_RESPATH has a fixed relationship with DSHOME if default locations were used for installation.

Being Windows, you may need to re-boot for the change to environment variable value actually to take effect.

DSHOME is the location of your DataStage server engine. For example (if you installed in the default location on X: drive):

Join stage, sorted inputs, Partition on name and perhaps also on zip, state and city.

Log a warning for any activity that finishes with a status of other than OK. Detect this status in the controlling sequence.

I'm pretty sure that what was meant there was to remove the Oracle stage.

Think about possible causes of deadlock. Might the same key be arriving from more than one partition? Are you trying to insert into the same table as one from which you are selecting?

Run a separate job to select the max SK value. Park it somewhere, such as a file or the job's user status area. Use this to provide the initial value for some kind of generator (probably a Column Generator stage or a Transformer stage) when creating the rows to be inserted. Beware that your generato...

Welcome aboard. DataStage has a number of partitioning algorithms available, one of which is "DB2". Using this one, you name the DB2 table and the partitioning algorithms are matched. Of course, DPF partitioning must be in effect. Partitioning of tables in DB2 and Oracle (and, indeed, othe...

Sunny: Do you always advocate destroying some of the client's data?!!! Pillip: Try using one of the Chinese character maps (for example GB2312 or BIG5). Since you didn't specify simplified or traditional Chinese I can't be more specific than that. Most maps automatically handle the ASCII character s...

Since the problem was at record 0, you might also consider checking whether First Line is Column Names is set correctly.

Of course you can dig into the metadata, but there is no supported function for doing so - you will need to create your own.

Tip: look at the STAGECOM structure documented in DSD_STAGE.H within the dsinclude directory. You will need to know how to handle multi-valued fields programmatically.

You only get the common fields, the first five fields, from a dictionary listing. After that, the record structure is different for each different OLETYPE. (That this can be done was one of the reasons they decided to use hashed files originally for the Repository.) Some of the structure is document...

Where on your system do temporary files get created?

What is the value of UVTEMP in the uvconfig file?

Or, if you have NLS enabled, they may be representing characters that can not be mapped with the map setting you currently have in force when using View Data.

Push the data into a text file rather than into a Data Set, so that you can use a hex editor to see precisely which characters are involved.

Field #7 contains the invocation ID. It is not defined in the metadata, but can be accessed as EVAL "@RECORD<7>" AS INVOCATION_ID If your invocation IDs are longer than 10 characters, then you might include FMT '20L' after the AS clause as well. Invocation ID is also reported as part of th...