DSXchange

The issue isn't the join. You have done one insert and 12424 subsequent overwrites to the hashed file, thus you only have 1 record no join will ever bring back missing records.

If the source file is missing the job will fail all by itself.

The "Full Wurlod" has been banned from all WWF events due to excessive danger of the brain exploding.

Yes, that will work to get the datasets partitioned along the same key values.

[answer][/answer]

If there is only one row of data, then the only difference between a successful and a failed run is the status of the job. Are you certain that you want to force fail the job in these conditions? You can force a failure, but it is seldom recommended as part of a well thought out design. If you need ...

There should be a tab in the System panel on the server for the DataStage processes that you can open and look. Also, just open up a CMD session DOS window and enter the "telnet localhost" command.

I haven't seen that one before and don't know what it could mean. Can you try a "force compile" to see if that gets rid of the error?

Do you have any other jobs that use Informix stages, and do any of them work? I would at first assume that the installation and setup for the Informix connectivity has not been completed correctly.

I think that the password is hidden and encrypted in one or more of the .jar files as well; and I wouldn't know how to go about changing the encrypted values (yes, untar and look into /classes/ojb-conf.jar). Doesn't WebSphere administration interface offer a place where you can change the XMETA pass...

A derivation of "Convert("I","E",In.Col) will convert all "I"s in the column "In.Col" to "E"s.

Add a reject link to your oracle stage and see if any links go down that path.

I still don't understand why you don't declare the whole record as one long VarChar column and use length, then reformat according to your preferences if the record is well-formed.

sachin1 - the parameter is "MAXKEYSIZE" and it shouldn't be changed without good reason as changes can impact performance adversely.

Only the first error message is relevant. You don't have a valid fileset. How was this fileset created (i.e., with which stage) and which stage are you using to read it?