DSXchange

8.anything (now and future)

One vital point is that you must have Administrator access to be able to use the FIX option on UVFIXFILE. Another point is that fixtool is the preferred utility over UVFIXFILE these days. fixtool -file AW -level 5 [ -fix ] Again you need to be Administrator to use the -fix option. The fixtool comman...

Or you could purchase a premium membership. It's not expensive, at less than 30c (Rs12) per day, and helps to keep DSXchange going.

Ur was a city in ancient Babylon. The second person personal pronoun in English is spelled "you" or, in its possessive case, "your".

There's some really good news for you in version 8 - the ability to export off the results of a search.

I'd be using generated SQL, or rewriting the SQL so that it avoids the "shorthand" syntax and uses an explicit WHERE clause.

Check permission on ${DSHOME}/catdir and its contents. They need to be readable by all.

I think what Craig meant was for you to reveal how you have set up connectivity to Oracle from the DataStage server. We're talking environment variables and tnsnames.ora particularly here.

Most here would recommend exporting the jobs, effecting a global search-and-replace (with care) on the export file, then importing with overwriting. If you really know what you're doing you could edit the ROOT records in the DS_JOBOBJECTS hashed file directly but, if you don't, the best plan is prob...

I take it that the '-' character in the b.col2 comparison is a typing mistake.

Where does "date1" in the WHERE clause come from?

Should coldate be being provided from the DataStage job?

Why is there a parameter marker? Because there is an implied WHERE clause.

Could this be a "hard space" character from a Word document or similar?

I don't think the semi-colons within the CASE construct are correct, but it's been some time since I wrote Oracle queries in anger.

It was in at least two presentations at IOD 2008. I'm away from home base at the moment - maybe someone else can dig them out. It's also in the IBM training class "What's New in Version 8.0".

Do you have at least 2GB of memory in the client machine?

What property?

You CANNOT do this in a Sequential File stage.

You do it in a Wait For File activity in a job sequence, or in an external script.