DSXchange

If you are on DS 7.5 or above then any argument in a routine can be used as a parameter value. So your routine can return 0 or 1 and also return an argument with the real value you what passed back. You may need to add an argument to do this. I think the same is true for variables within the sequenc...

I was told IBM/Ascential had a tool to automate this conversion as well as converting from Informatica. It does not convert everything but supposed to convert most. Ask them. Ray may know.

I forgot ExecSH. Shell scripts are another big problem.

The biggest problem I have seen is the "/" to "\". This can be fixed pretty easy if you know some tricks. Most of my routines plan for this so they can fix themselves. The rest are usually in parameters so they are easily fixed. Otherwise just export and import. If you hardcoded path names then you ...

A lot of the time it does not have permission to write to a hashed file or the log file therefore it cannot tell you why it failed.

Buzzword forum or double speak. Good idea. Those you can do, Those who can't teach or buzzword you to death.

If you type HELP SQL then you can see some of what is supported. UNIQUE and other commands are used by Pick/Prime style commands. Universe is a derivative of Prime Information which is a derivative of Pick. Some of these keywords are used in both SQL and Pick style commands so it is difficult to kno...

You are welcome.

I have used Universe for many years and I learn something new from Ray's code all the time. I figured others might get lost if they try to figure it out.

Even if you are really good with Universe then Ray's code is very advanced. This can dump DS_METADATA to a xml file or a comma deleimted. This is not the same code originally posted. To break it down a little bit. Command = "SELECT DS_METADATA WITH DSRID LIKE " : Quote("0X'" ...

It disconnected me 3 times today. It is slow too.

IBM charges for hyperthreading almost like it is another CPU. So watch it.

You want me to post the rest then let me know.

This is stored in DS_METADATA. It is hard to import the metadata for these repository tables. You have to trick DataStage into doing it. Also the columns you need are not included in the product so you have to create these columns. You need to know quit a bit about Universe in order to do this. Thes...

You need to download EtlStats from the links on my signature.

The system tables are part of the DataStage engine. The respoitory tables are what I think you want a list of. The repository tables usually start with DS or RT. Most of what you want is in either DS_JOBS or DS_JOBOBJECTS. You can access these through SQL. The DataStage engine is an old version of a...