DSXchange

That would be the elements mentioned in the "as the key" comments above.

Do you mean creating a first record which contains the column names? Since that's based on the field names in the job and "." is not valid in a field name the stock answer on can you do this automagically would be no. You could create the record "before job" and then set your out...

You already asked this question yesterday, asking again isn't going to help and will just upset the natives.

Use Convert() to replace any numeric digit with a 9.

That's a database question for your DBA rather than a DataStage question.

Now rightly posted.

So, in that case, using a Routine Activity stage is the proper answer here.

No. Do what you are doing, using the proper stage and then (I assume) checking the results in any downstream triggers. Make sure you are detaching from the jobs you are checking! Question - were these jobs run by the current Sequence? I assume not, but wanted to ask and make sure the "why"...

I'd suggest contacting your official support provider.

Bottom line is CLOBs are not supported. What happens when there is more than one CLOB in your job? Have you try setting your Array Size to 1? I'd suggest looking into other tools... pl/sql perhaps? Have a chat with your DBA and see what ideas they have.

I'd also be curious how many indexes are on the table and if there are foreign keys to other tables, all of which slow things down. Also, how often are you committing? In spite of the fact that you said you didn't "mention any commit point" it must be doing so if you can see your changes i...

Why are you configuring ODBC for the Oracle Connector stage? You need an Oracle client installed and configured instead, do you have one on your DataStage server?

You don't need them in a Parallel job, there are PX equivalents you should be using instead. Unless you need to do this for some reason?

I'm assuming you meant in a Sequence job so off we go to the General forum. And are we talking about a custom / user-defined routine or something else?

First off, Server or Parallel job? You posted in the Server forum but marked your JobType as Parallel. And be specific regarding how you are doing this "join" - do you actually mean a lookup?