DSXchange

I prefer always to use decimal (base 10) argument with the Char and UniChar functions.

Isn't that the default when you choose direct write over SQL? Doesn't it invoke sqlldr under the covers?

Get to a UNIX prompt and execute the command Make sure that this directory pathname is mentioned in the PATH environment variable used by DataStage processes (the best place to ascertain this is the job log entry that lists environment variables).

Was the job compiled by you or someone else? Check the permissions on the named object.

There's no general solution to this problem unless your job design keeps records - or interrogates the target - to determine how far it got. You need to provide that value - probably via a job parameter - to a constraint expression (in a Filter or Transformer stage).

Why bother with a Transformer stage? A Sequential File stage has the functionality you require. Indeed you would need to create at least one custom routine to solve this with a Transformer stage.

Today the number of topics in the parallel forum caught up with the number of topics in the server forum (21844).

Sounds like an excuse for a party.

I don't believe the location of QS_TEMP is configurable.

Replace the target DB2 stage with a Peek stage temporarily and determine what values are being selected. You don't seem to have a "." between the schema name and the table name.

Care to share? I, for one, don't know for sure the answer to your question, which may be different for partitioned and non-partitioned tables.

There is no particular recommended bandwidth for DataStage client-server communication. At least 100BaseT LAN is assumed. Faster is better.

WriteBlk can write individual bytes (and ReadBlk can read them). Details in DataStage BASIC manual.

A good link to learn about date conversion is Date Conversion Demystified on PickWiki.

You may like to use a User Variables activity to break this into simpler expressions and avoid unnecessarily repeated Iconv() function evaluation. Convert("-", "", Oconv(Iconv(paramB, "DDMY"), "D-YMD[4,2,2]")) Convert("-", "", Oconv(Iconv(p...

The replies in your other post on this topic remain pertinent. There is precisely one way to call a parallel routine from DataStage, and that is from a parallel Transformer stage (or, perhaps, from a custom stage type). And, of course, one routine can call another, but I don't count that as "fr...