DSXchange

There's nothing about any "checksum" that is meant to be used to generate unique / surrogate keys, so you are completely off track there. What's wrong with a normal incrementing surrogate?

Space or permissions, I would guess. Does your importing user have the permissions it would need to create files in your project?

Better?

OK, it is "as below" now that I did a quickie wrapper job on your ascii art. :wink: :!: People, use code tags and make liberal use of the 'preview' option to make sure everything stays lined up. The forum software removes all whitespace from anything other than 'code', your works of art wo...

Not really sure what that would mean. How about some details? You haven't mentioned your source or targets, job design, anything... seems like that might help.

Right, take XML out of the picture for the moment. What is the characterset of your source and target? Do you have NLS installed?

ps. Moved to the proper forum.

Detail for us exactly what it was that you tried.

An exact search here rather than in the Help for "Cannot find record JOBPARAMINSTS" would show that you're not the first person to see this error.

In other words, way bigger than you need to worry about, I'd wager.

Ah... having a 64bit O/S doesn't guarantee that your application is also 64bit so Tony could very well be right. You'd need to verify the "bit-ness" of your DataStage version.

Trick interview "question".

Typically by double-clicking on it in the Manager. What kind of "more info" are you looking for?

So... new server? First attempts to connect to DB2 from it?

g_rkrish wrote:Sorry I think i am kinda confused you guyz

Way more than 'kinda', that first explanation was indecipherable.

XML stages are typically end points in a process, with the possible exception of an immediately following Sequence File stage to write the output to disk. I have no clue what kind of 'lookup' you would be doing or what kind of 'transformations' would be happening after the XML stage, can you clarify...