DSXchange

All that trouble, when you could have downloaded the OpenSequentialFile routine!

Don't overload the machine, or get a more powerful machine.

You can use an Execute Command activity to execute dsjob, as others have noted. You can also use a Routine activity to call UtilityRunJob, or a routine of your own that submits the run request and exits without waiting for the job to finish. FUNCTION RunJobNoWait(JobName, InvocationID) $IFND...

Make sure that the field is declared as nullable everywhere it appears.

Why not just read the file with a Complex Flat File stage, which can handle these data types intrinsically?

Is it Thai in some rows and German in other rows, or a mixture in any given single row? If the former, you could read using the Thai map (TIS602?), which would reject rows with Thai-unmappable characters. In another job or another stream you could read using the ISO8859 map for German, which would r...

Why not just read the file with a Complex Flat File stage, which can handle these data types intrinsically?

The quick way is to right click on a warning message and "add rule to message handler". While in that dialog, click Help.

It will be in one of the manuals, but I don't have time to research which one. I'd guess Manager Guide would be the first place I'd look.

The answer to your first question is NO, which makes your second question moot.

A Filter stage uses something like regular expressions in its WHERE clause, but does not support the full gamut of regular expression functionality.

Functions can not be CALLed. Only stored procedures can be called.

Use your function in a SELECT statement, perhaps one that selects only one row (maybe from DUAL).

I doubt that the OP is using an Oracle Enterprise stage, as DB2 was specifically mentioned.

You can create a job-specific message handler to demote these warnings to informational.

Where (in which stage type) did you look?

A Routine activity in a job sequence