DSXchange

from document: if the Read mode property is set to PL/SQL and the Lookup type is set to Sparse, the connector matches by name the reference link columns with the parameters in the PL/SQL block. The connector maps the columns marked as key columns to PL/SQL input/output parameters and maps the remain...

I use the IBM InfoSprhere Information Server Manager to build and promote. One installation and 3 projects.

If anyone knows where to look for more informative error messages that may be logged on the server .. that would be great help.

The Dev, Prod, and QA projects are on the same aix machine.

Prod does not work on the promote.
QA works.

Coming from the same Dev job.

I have 3 projects on one server .. Dev, QA, and Prod. I build from Dev and promote to QA and/or Prod. Every job promotes fine except one: Failed: Unexpected error importing design. See the log in the Web Console for more details. I am not positive what the Web Console is but when I go to: Start bro...

Holy Smokes .. by making that 400000, I got the file to be read.
Who knew that a 32000 btye file would not work with 100k btye read size value.

Thank you very much .. I should have tried to make the value larger to start with but the 100000 seemed large enough.

chulett wrote:Which 8.x release are you running?

8.5

I know this topic has been approached many times and the answer is always "datastage couldnt find the record delimiter". However, in my case for testing purposes, I am building a file on aix that goes from 31990 to 32010 in length incrementing in length by 1 each time. I run the job after ...