DSXchange

If $APT_DISABLE_COMBINATION is set to "true" then your run will not contain any references to combined operators. Check the first entry in the director log for the run and you will see the runtime value for this environment variable. Correct that error and re-run to localize the stage. Rem...

Is X1 nullable in your source link?

Turn on $APT_PRINT_SCHEMAS for this job, it will show the actual schemas between each of the stages in the job and goes a long way into finding the sources of errors.

"125"," WALT STEET "FIRST", LONDON UNITED KINGDOM ","3333"

is, unfortunately, an invalid format which DataStage cannot read. It should read:

But you aren't using AGENT_ID in DataStage, at least according to your SQL. The number datatype is represented as decimal in DataStage.

Where are you doing your left join? If in SQL, have you declared the X1 column as nullable in DataStage?

What data type is AGENT_ID, or are there any decimal data types involved at all?

I cut-and-pasted your 3 lines to a text file and then defined a sequential file stage with the default Quote=double setting and was successfully able to view the data. I suspect that you have another issue - try doing what I did to see if you can successfully read a quoted string with embedded delim...

Is the input sequential file defined with format field defaults of double-quotes as the quote character?

While I haven't come across this error before I would ask if this is a multinode installation and if this is a new error.

That error message answers your question. You will need to CAST this to a supported datatype in DataStage.

After doing a reset there should be a new entry in the director log starting with "...from previous run...". Could you re-check your log to make certain that you don't have this entry after resetting?

The upper bound of the memory usable by the lookup stage is also dependant upon the platform implementation, see the threads on AIX (i.e. this thread). Using a number of "1 million records" is a bit misleading -> are the records 5 bytes wide or 500?

If you open up a monitor window and then right-click on it, you can select the option "Show Instances" and that should answer your question.

I wonder if the installation was sucessful and/or complete.

Can you login using the browser front end by going to http://{YourServer}:9080