DSXchange

No offence meant to OP or Ray and ArndW. Quite a few posters here are non-native speakers of English (or have broken satire detectors). I have recently seen instances in the forum where more info was sought on suggestions like the one above, esp. when coming from experts. Maybe we need a BS indicato...

Nope.

The version you need is 7.5x2 (or 8 )

Create schema files for all tables Create a job that does nothing but compare two sets of data (Change capture or Difference stage) Turn RCP on Use a set of common columns as keys - audit columns can be a candidate key Mark all non key columns are values to true Pass the schema file names as paramet...

There was hardly a chance of that working out anyways

Why not pass a random string as parameter and substitute it for space within DS?

How about using a generic job and schema files for metadata?

Try this

typeset space=" "
dsjob -run -jobstatus -param some_param=$space myProject myJob


edit : you may have to put quotes around $space based on your shell. Unfortunately, I don't have access to one to try out.

Datastage does not install C++ compiler. You have to install one which is compatible with your operating system and DS version. Since you have mentioned V8 on Windows, that would be Visual Studio .Net 2003 or 2005. There was a free version of 2005 available, not sure you would be able to get it sinc...

Compiler "cl" not found

This is the problem. A compatible C++ compiler is either not installed or not in PATH

awk '/regex1/,/regex2/' will print everything between the first occurrence for regex1 to last occurrence for regex2. That should work for finding log entries for a job between two dates - as long as the log is chronological

PS: You will have to escape dates in regex,like - /2008\/07\/25/

You are on Unix.. why not pipe the output to grep(for a specific date) or awk/sed (for date range).

This still will not provide you logs for all projects in one go.

<answer></answer> or <answer /> - OP mentioned xml format

I have installed xmeta only on DB2 on Windows. The authentication is OS based, so essentially we could change the password for xmeta OS user to that of db user and it will work fine. I could use that method when password expired on our test system and found the policies did not allow re-use of passw...

Better at what? For every document you can point out with ODI/OWB being better, IBM might be able to show you ten that proves otherwise DS doesnt do ELT, but do you really need ELT? Is ELT provided by other vendors mature enough to be useful? DS might have better connectivity with different datasour...

Do you mean metadata workbench?
You can store key value pairs using Information Analyzer which can later be exported to datastage to be used a lookups - research Reference Tables in IA

dsjob -import and dssearch not available anymore