DSXchange

Look in your job log to see what command was actually executed by ExecSH.

Storage in Data Sets is about the only recommended place to use unbounded VarChars. They are stored as you would expect from the designator in the score; as string[max=N]{prefix_bytes m} where m is the size of the binary number indicating how many characters are stored, and N is the maximum number o...

Why after-job?!!! I suggested a Filter command in a Sequential File stage. The command should be tr -d \x00 filename if reading the file.

If you must use an after-job subroutine, then you need to specify (redirect) input and output file names for the tr -d command.

You can use list_readu from the command line, and pipe the output through grep to determine whether there is any client attached to the project. For example, if the project name is CMARTDEV:

No, but you can apply Trim() function in a Transformer stage. Also investigate derivation substitution - you will only need to enter one Trim() function!

Show us what you attempted to do (including the SQL), so we don't have to guess.

Data Sets' structure is locked in once they're created. You must delete the Data Set if you wish to change its structure.

I think this is a case for custom code - either a parallel Routine or a BuildOp.

Two lookups. Two Lookup stages. In the upstream one determine the existence question - the value or NULL will be returned. In the downstream one test whether that value is null.

My bad. There is another environment variable that can be used to set the pathname of the directory. It's in the Reporting group.

So change the partitioning algorithm on Input Port #0 of the Lookup stage to Entire.

Your first misapprehension is that there is "a" process. There may be many, and precisely how many depends, on the job design, the currently chosen configuration (number of nodes), and the degree of optimization, particularly operator combination and inserted operators. Clearly, if you want to know ...

Explicit Sort stages allow you to more easily control the memory allocated to sorting, and to perform sub-sorts without re-sorting the already-sorted sort key columns.

All forms of sort will create extra processes. Look at the score to verify that this is the case.

Which part of "Please contact your supplier" was unclear?