DSXchange

Version 6.x? Really?

Unsure what you mean by 'remote server path'. You'd need to FTP the files back to the DataStage server or otherwise make their location 'local' to the DataStage server via NFS (etc).

My understanding is the Director can only see logs when they are in hashed files, just like previous versions. When they're in XMETA, you have to check elsewhere, the web console? :? You can search for "rtlogging" or "rt_logging" (one of the two) for discussions on this option. A...

Solved the problem... three and a half years later? Or three and a half years ago? Assuming the latter.

Thanks. There are so few 64bit versions of DataStage I tend to forget they even exist.

Resolution or workaround, I've found in the past that the only array size that consistently worked for me when handling fields like CLOBs or TEXT was 1. And sometimes the DRS stage in a 'native' mode works when the equivalent native stage does not. For whatever that is worth.

What have you tried? There is a specific "URL/File pathname" option in the stage, have you tried using that?

There's no such thing as a "sparse" lookup in a Server job, you mean a straight reference lookup. They're similar, sure, but that nomenclature is specific to the PX product.

What are the specifics of the "without any success" part of your attempt to use a hashed file for this?

Delete altogether.

Give this a shot, see if it answers your question:

Sorry, but there's no "of course" with the issue of searching the forums, most of the time people just post. So if you haven't explicitly said that you've searched, it's the first question you're going to get. And if you've read all of the post here on the subject, I'm not sure what else a...

There are several reasons for that Oracle message, if you do an exact search here for "OCI has fetched truncated data" you'll see a number of conversations on the subject. Go through them and see if any of them help.

That's... silly.

Can you reverse the roles, use the sequential file as the input stream and do a sparse lookup against the phone table?

Load the file into a work table in your database and join that to your source table.

If you stopped and thought about it for a moment, you'd realize the answer is that "it is not possible" in that scenario.

Have you involved your DBA? I sure as heck would be banging on their door if I was in your shoes.