DSXchange

Post the exact syntax you used.

Then rebuild the hashed file (or build another) with your single key field.

And then expect multiple matches on that partial key. And you'll need to create an index over it if you have any performance issues.

Do you think its possible to pass a column name from the source to the select clause in the stored procedure. Of course or I wouldn't have suggested it. Input parameters can certainly be leveraged inside the procedure code and you can bind column values to input parameters. What database are we tal...

Do an exact search for "jobmonapp".

You might find this post helpful.

Somewhat surprised that there isn't a simple property in the stage to allow it to skip the first X rows when reading the file, other tools support this.

Why would you not just build a job to source from the dataset/file and call the stored procedure once for each input row? Am I missing something?

Not quite sure why anyone would assume a binary image, I'd imagine it's simply uuencoded or perhaps via MIME or yEnc. Plenty of command line options for the decoding part in that case.

Please try to use meaningful subjects, I've changed yours from "DataStage" to something more... appropriate.

Oracle, please learn how to post without quoting everything all the time. Use the Reply to topic link unless you actually have a need to quote something.

... or write it to a file and have the second job read that 'SQL File'.

As noted, random <> unique.

Contact your official support provider.

You've asked this question more than once and gotten the same answer each time... not sure why you feel the need to keep asking it.