DSXchange

Yes. The dsenv file needs to be sourced every time you start a fresh session to set the environment variables.
Source the dsenv in your .profile so that it gets executed everytime you login.

O yes. It is unix and not windows . You only need char(010). Check the row count of your target. How do you know its not showing up? Also try to run in sequential mode and see if its working. To parse the input record, you need to write a custom C program that inserts a new line character after ever...

Just the way you showed.

Are there any other surrounding error/warning messages? See if this post helps.

Welcome Aboard
Enclose your ascii art in [code] tags. Its hard to tell the design otherwise.
The other oci stages might be waiting to finish the query. Are your queries just simple selects or complex joins and other functions?

Substrings are pretty fast. It should not have any performance impact. Run a test on 25% of your expected input.

Well then in the transformer, you can substring and add Char(013):Char(010) after every fifth position. This way you are adding a unix new line character which will split them.

Is it a single column input and single column output?

Sure. You can pass the delete command in the OPEN/CLOSE option of the enterprise stage and do your regular operation of load or upsert.

Allocating memory with malloc, like the one I allocated for result, does allocate equivalent to the size of a char pointer. As I have written many more px routines after this one, I found out that its better to explicitly specify the size of the input string rather than just the pointer (Had memory ...

You need to parse the value out of the very first entry of the log. Before you run the job, get the event id by the "-lognewest" option. At the end of the job, get the "logdetail" for that particular (event Id + 1). This will be the very first entry of your run which will contain all the parameter v...

ArndW- You are 100% correct. I just wanted to make sure whether a simple 'dsjob -ljobs' command is working for the OP or not, sitting on the same engine ofcourse. Once that was out of the way, then the OP could have brought in the other tokens. I know my previous post sounded like the -user option i...

Consequently, you can load your value into a staging table and then use your sql query to join this staging table. Thats another way.

No. If you turn on "Multi-row result set". You should not get any warnings.

Yes. The best way is to convert your code to C++ code.
These function exist in C++ versions as well. Look at the Parallel Advanced Developer's guide.