DSXchange

When you read the three pertinent chapters in the Parallel Job Developer's Guide what did you discern the differences to be?

I would be happy to read these chapters for you, in return for my usual fee.

Then don't apply a DateToString() function. Just assign CurrentDate() to this column. You can change the display format (but not the storage format, which is "date") by selecting this row in the Columns grid, right click, choose Edit Row, and provide the date format string there. If you want all dat...

A lookup against table2 with the Transformer output constrained to put only those records for which the lookup succeeded will satisfy your requirement.

The two SDK routines KeyMgt... manage generation of sequence numbers by keeping each sequence name as a record in a hashed file called SDKSequences, which is automatically created as necessary. Sequences in SDKSequences can be initialized with simple INSERT or UPDATE statements, or with a routine. S...

What is the data type of current_dt?

Out of band null is represented in DataStage as 10000000 (binary). You can represent this as 128 in decimal, 200 in octal or 80 in hex. For example \x80

Post your record schema, and the row for which the error was generated. Remember that row numbers begin at 0.

If you have the permissions you can just delete them - no special procedures are required. Make sure to use the recursive form of delete, just in case they have contents.

First, CurrentDate() returns a date. There is no format. When you use DateToString() you can specify a format. Derivation expressions do not contain "=" characters to assign values. Try just DateToString(CurrentDate(), "%mm/%dd/%yyyy") as the derivation of the current_dt fi...

The data volumes I would expect to process with a parallel job would make the risks involved in using CRC32 too great. CRC32 has about a one in four million chance of generating false positives. Parallel jobs have their own, quite efficient, change detection mechanisms; the Difference stage, the Com...

Use find to determine where liborchgeneral686.so is on your file system.
Make sure that its parent directory appears in LD_LIBRARY_PATH.
Which stage generated this error?

Your difficulty is with your operating system's output line length limit. You may be able to modify that. You could certainly adapt your Convert() function to remove the line terminators as well (on UNIX - on Windows you'd need Ereplace()). Or you could use ls -1 to get a single COLUMN of output, an...

Perhaps we could introduce a fee for searching when experienced posters fail to search?

The partitioning of the Data Set is determined by the job that created it.

Are you using Overwrite or Append in the slow "load" job?

Even when used as a target a Sequential File stage may have multiple File properties, writing to different files. In this case it will execute in parallel mode unless constrained to do otherwise.