DSXchange

Nobody said it was not possible in DataStage. The point was that you are using a sledgehammer to repair a watch. If it can be done in SQL, do it in SQL. DataStage can issue the SQL, if you must, but it would be better using a reporting tool, either a database client tool or a business intelligence t...

What's the source of data? If the source is accessed via SQL, all you need to do is to incorporate an appropriate restriction in a WHERE clause.

OK now post the SQL generated by your target DB stage. That is, the INSERT statement.

From the original post, where the question was how to generate Hex 15.

In particular do NOT use a Field() function in this first debugging step.

The most basic step of all is to double the amount you pay for the software. Other than that, I fully support what Arnd had to say. Those who run this site do offer a "Server to Parallel Transition Lab", or you can learn parallel jobs from the ground up by enrolling in standard vendor classes, etc.

You can use the function Char(21) to generate this value. The argument to the Char() function must be a decimal number. Tip: If you are going to use this a lot, initialize a stage variable (in a Transformer stage) with this function, and do not provide a derivation for that stage variable. This way ...

... and is completely unrelated to your earlier problem with the activity variable.

... and you will get one record per processing node. The Transformer stage executes on each processing node, and therefore @OUTROWNUM can be 1 on each of these. Use properties of the Sequential File stage to ensure that only one row makes it into your job.

Don't pass it on the command line. Access it within the script.

... or even just "DYMD".

As this article indicates, the Iconv() function is very smart about being able to eliminate delimiters without you needing to specify what they are.

Because from the GUI the executing user is dsapi_server or dsapi_slave.

Pre-set the the password (and anything else you'd like) in an environment variable, and make reference to that environment variable in the script rather than hard-coding the password.

Express it in English. Make it a more specific question, and tell us what you are trying to achieve. U is also a registered user. Consult the Parallel Job Developer's Guide and discover what the Change Apply actually does (particular its relationship to the Change Capture stage) and you may find tha...