DSXchange

There's no such thing as bulk load in DataStage.

Bulk load is a technique for adding new records to a database tables rapidly.

DataStage is able to invoke most databases' bulk load utilities.

Many techniques are available.

The three most obvious are Switch stage, Filter stage and Transformer stage.

Did you Search DSXchange for "will partition despite" or similar?

This has been reported and solved many times.

Essentially the solution is to set "preserve partitioning" in the upstream stage on the reference input to a Lookup stage to "Clear".

You can place it job control. Use DSExecute() and specify both the commmand and the Data Set descriptor file as full pathnames.

What it means is that it (the sequence (= Controller)) had a problem at or near the point where it was either about to execute or actually executing the activity called Job1 (dare one assume that this is a Job activity?).

Beware, with this approach, that you must have sufficient AMPS available to service the request. 2 x 4 = 8 AMPS.

Perhaps siva4joy can, since the thread has been marked as resolved.

Customary practice here on DSXchange is, when you mark a thread as resolved, to make a post indicating how it was resolved, so as to aid future searchers.

Except that you can use regular expressions, which I've only really seen in Informix.

Welcome aboard. We encourage you to Search before posting, because there are very few new problems, problems that have not been encountered previously. It may be that RT_CONFIG4575 is corrupted, it may be that the file system where your project is has become full (especially if you have more than 45...

Why not use a simple DataStage job? How do you identify the rows that you want to compare? Or is the question that you want to compare domains? (That is, the set of values in a column in Table A versus the set of values in a column in Table B. Information Analyzer can do that.) What's specific about...

You're paying an official support provider to help you.

Personally I don't access DSXchange at 3am my time. Now that I've read your post, I find it outside the scope of my skills and, ordinarily, would not respond at all because of that.

You can always incorporate the server job functionality into a server shared container and use that in the parallel job.

Review Chapter 2 of Parallel Job Developer's Guide for restrictions - I don't believe you'll hit any of them in this case.

If the data type is Char(14) and fewer than 14 characters are provided, DataStage will pad the field with the character specified in APT_STRING_PADCHAR, by default \0 characters, which parag.s.27 may be referring to as "control characters" since they are in Control Set 0.

Can you please advise the patch number?

I don't know the answer, because it will depend on how your data are actually encoded. And there's no way I can know this, so I suggest a more general approach.