DSXchange

In a Sequence, write the values to a file or USERSTATUS in one job. Use a Routine Activity stage to retrieve and pass it as a Job Parameter to the job that needs it.

TABLE2 in the same db as TABLE1? Just use sql:
Otherwise, you got more 'splaining to do.

... and that looks to have fixed it. We were already stripping CHAR(252) and CHAR(253) from the field as they aborted the hashed loads. Just added 10 and 13 to the list, seemed like the LF was the actual culprit while the CR just became data. Odd that this didn't turn up earlier as a problem, unless...

It's a Director option under the Job menu.

mekrreddy wrote:Sql statements does not work exactly as of 7.5 in 8.1 when you join tables of Oracle database with higher version Oracle client connector. Works fine when I tried using Toad or Sql Plus but not in the stage.

Could you expand on this, please?

From your link, it sounds like a DB2 issue and one that you'd need to take to your DBA for resolution.

Right, always do. :wink: Guess this was a red herring. I tried the SELECT you suggested and the proper record values were selected. I also created a small job to send one value to the UV lookup and write the four resulting records to a flat file - they all were selected fine. So the behaviour we're ...

Thanks for the syntax. I don't think the problem is just with the browser as what started this whole witch-hunt was the fact that the job was exhibiting the behaviour as well. Or at least it was telling us a perfectly valid record was not being returned by the lookup and that led us to discover the ...

Sheesh - just to further complicate this, I ran the job that creates the hashed file in the Dev project, a separate server from the production server. It pulled down the same number or records and exhibits the exact same behaviour when doing View Data. :? Seems to be telling me it's not specific to ...

There was a known issue with DataStage on Itanium with regards to Oracle, sounds like the problem still exists. It doesn't correctly setup its Oracle components correctly and you manually need to create a link from where things live to where they really need to be to make it all work. I've posted ab...

Forgot to mention something - there is an index created over the first column of the hashed file to support the multi-row lookup via the UV stage. I'm wondering if as a first step I should delete and recreate just the index, see if that has any effect on the issue. However... what would the syntax b...

I've never seen behaviour like this before, so I turn to the collective for help as the client no longer has a support agreement. :? Many records written to a hashed file, all six fields are key fields. I don't think this matters, but for the record this is a pathed hash with a VOC record created fo...

Sorry, missed the 8.x tag.

Don't use a Sequential stage to read the file, replace it with a Folder stage: Folder -> XML Input -> Seq File Small files can be read entirely by the Folder stage, however larger ones will need to only send in the filename and have the XML Input stage do the actual reading via the 'URL/File path' o...

Looks like they want you to access things strictly through their web services and direct access of the underlying database is... discouraged.

Web Services Access

SharePoint Database Access