DSXchange

What stage type are you using? What defines "rejected"?

Assuming ASCII or equivalent: all characters whose code is below 32 characters in the range "A" through "Z" (assuming you want to keep only lower case alphabetics) all characters whose code is above 128 You can be somewhat selective in the first and last of these if you know, for example, that Ctrl-...

If all checkpoints are removed at the end, isn't meaning that the controller adds checkpoints(as flow successfully validated) for all activties, unless Job3 is aborted? No. Checkpoints are only added for all activities that do not fail, unless the activity is marked "do not checkpoint run". Therefo...

Initialize a stage variable with a string containing every other character and another containing the number of spaces that there are characters in the first. Use a Convert() function to map from one to the other.

Not as directly as you would like. Depending on the actual database some degree of prefetch buffering and in-process row buffering may be possible. Also depending on the actual database you may be able to invoke its export facility to bulk unload the data as the Filter command of a Sequential File s...

Are the DB2 environment variables, such as DB2INSTANCE, set for the user you are using to execute the orchdbutil command? Have you executed the dsenv script?

Would you be surprised if there isn't?

You can load it quite happily. What you can't do is view it with View Data. But you can view it with TOAD, sqlplus and the like.

There should be no difference in the process based upon job type.

Only design-time components are exported - parallelism is not determined until run-time in parallel jobs.

The main factor is the available processing resources (CPU, memory, disk space, network bandwidth). The next is the volume of data to be processed. In an ideal world a job with N nodes will process data in 1/N the time needed by one node. Provided, of course, that the hardware and operating system o...

You can read it with any text viewer/editor.

With no commercial relationship I recommend UltraEdit, which can FTP the file to your client machine for viewing.

It worked because they are not null. "" is not the same thing as null. We know that "" is a string and that it contains precisely zero characters. Null means that we do not know what the value is. Null is not possible in a text file; only a "representation of null" is possible. This is because a tex...

Use the formatting tool in the code editor to make the End statements' dependencies easier to see.

The Importer's Preview does not use osh - it is quite different from View Data in parallel jobs, so this result does not really come as a surprise.