DSXchange

Most of what I know I learned from downloading the free Universe and making the examples work. I have worked with Universe for a long time so I knew what they were trying to do. The examples are terrible and take some effort to make them work. They do teach you how read and write to hash files and e...

It depends on the version of DataStage. It is DsObjects.dll now but it has been UniObjects before that it was UvObjects. I will check later today but it should be under DataStage or Universe.

How can you update anything then if you only have one of these?

What if you inserted 2 records before? It is not in the hash file. You job says it is an insert. Really it is an update.

There is your problem. You need to reflect in the hash file all the keys in the target otherwise your insert needs to be an update.

When you insert a record do you also update your hash file?

Ken is correct cache needs to off. All these need to be in one split file as well.

I do not get it. It looks like it is working perfect then. What is it that we do not understand.

I think your key to the hash file needs to be just the first field not the first 3 fields.

Ken is always correct on how DataStage works but because the first 3 columns are all part of the key then it did it correct. The type changed on the first 2. The date changed on some of the other ones. I am not sure I see a problem.

A key field with a space on the end is a different record than one without the space. Hash file keys are exact matches. The same is true for upper and lower case keys.

You will have to do some work to convert it to a routine but it will get you close.

This is how you call DSGetStageInfo. This code is a part of DsWebMon. subroutine DwnGetMonitor(JobName, MonitorGrid) * ----------------------------------------------------------------------- * Program Name : DwnGetMonitor * Program Dir : DWNBP * Created by : Kim Greggory Duke * Copyright ...

Informix has an unload option which will create a sequencial file fast. Their ODBC drivers are slow.

I do not remember the syntax for unloading a table.

Download EtlStats.zip from my tips page.

I forgot the SQL statement above is controlled by a job named GenHtmlJobLog. This job figures out the job number from the job name to make the proper replacements above. So you do some complicated stuff with these jobs.