DSXchange

Here is a post that might help.

http://www.dsxchange.com/viewtopic.php?t=88891

Also the rule of thumb is to install in a folder with the version number like DataStage7.5 and DataStage7.1 as the folder names.

The SQL is also extract through Reporting Assistant. Pull up doc_tool.mdb in the Ascential folder on the client. Hold down the shift key when you open the Access database to by pass the menus. Create a new query. View SQL and paste this SQL below after you edit it. Select [PropName],[PropValue] From...

Vincent

I am sure IBM will appreciate the

cheaper customers

quote.

In older versions switch Command Stage to a Routine Stage and use ExecSH. Parameters should work fine.

Each SELECT can be output into a hash file. The hash file needs a key so you need know what fields make it unique but it should be whatever you used to join these tables together. It is also easy to figure it out based on your group by clause. If you want you can remove one SELECT at a time. After y...

uvwalk is cool. Thanks Ray.

Shivan Surely there is a better way to extract this data. This SQL is UGLY. Explain why it needs to be this UGLY. DataStage can be better utilized by not doing so much in a source query. You could probably take 36,000 records and load them into hash files and look this up one SQL statement at a time...

my job stacked I am not sure what that means. You can write to a hash file and then read it with a UV stage. Some of your assuptions are correct. You can do a range lookup on a UV stage. You have to do it with User Defined SQL. Loading hash files takes a while. It is faster to load it as a hash fil...

The output is only in the log or maybe in &PH&.

I think what Craig is saying when you tested it you changed directory to where the file was and then ran tar but when you run it from a job then it extracts the tar file into the project folder. Not the same.

I have never got a reply back whenever I asked for anything but a password change.

I just tried it and it works.

You always was Mom's favorite.

I got this email below. I just wanted to post this to let people know that this could run on Windows but I have never converted so you may need to do it yourself. Larcombe m is where the zip file is located. m is the page with the link to it. You need to unzip these files and look at them. There is ...

You had to bring in Mom into it. Didn't you?