DSXchange

Not in this case; I actually cut-and-pasted the custom SQL from the job that didn't work to my copy of the job and it also worked.

Is one line all it is supposed to show? Also, what is "LinesWithoutHeader"?

It is too bad that the whole DataStage product was dropped because of a function that could be coded within DS/BASIC in a matter of hours. I hope that Java works out well as an ETL tool for them.

What happens when you try "view data" in the DB2 stage?

I was a strange error. Everything in the job looked correct. I made a copy, retyped in the identical manual SQL clause (which was just the default generated UPDATE clause with one added constraint put in) and -poof- the job ran. I couldn't get the original to run and since everything is now in order...

Arun - what sort of a table - DB2, SQL Server, Oracle, Teradata? Using which stage? does it happen on the first row?

Give us a chance, Arun - what is the link attached to on the other side of the transform stage? What does a "reset" show in the log file in the entry "from previous run" show?

That kind of limits your options. Perhaps you could add a "sacrificial" record to the file so that the bulk loader has something to do?

No, no files will contain the node name (thinking if perhaps the Informix files might reference the local machine... can't quite recall). Perhaps you could try a unix find on that directory tree and grep for the nodename, but I think you will be OK.

If you have DataStage just create the data and control files and not execute the bulk loader you can add your own logic to an after-job subroutine to optionally invoke the loader process or not. This can be in Ds/BASIC code or a UNIX shell script, whichever fits your needs and abilities best.

The COMMON mismatch is due to routines with different versions of the COMMON block in the catalog. As you surmise, this is probably due to problems during an upgrade.

Unofortunately, this is a PX job and OCONV() is not available.

Sengs,

sorry, I forgot to unmark my quoted post as premium; I've that and you can read the full post by Kim.

I searched "Square root of a negative number" with "all keywords" and found several matches.

I used the search button (you can find it at the top the screen) and found a thread which finished with I have seen this error before. If I remember correctly it is because you are trying to process 2 repeating groups at the same time. That was what kept DSJobReport job from working when I downloade...

I didn't recognize the UserId, but I did recognize the pPARAMETER format plus this is the only place I know of with a major field being ARRG_ID. We'll continue this offline. :D