DSXchange

Does anyone still have the compile.job basic routine?

Regards,
Ogmios

We were thinking of automatically making backup copies of all of the DataStage jobs every night. The problem we're currently facing is that sometimes people leave DataStage open overnight or their connection drops and their Designer job remains locked, when we then schedule an automatic export of th...

Thank you, cd `cat /.dshome` bin/uv "LIST UV.ACCOUNT" | cat Does indeed provide parsable project information. Now I just have to figure out how make the column output wider (DataStage/UV has this annoying habit to split one field over multiple lines), but I will figure that one out. Ogmios

I'm having the following problem: I would like to retrieve the names of all of the projects in my DataStage Server together with their path. I can get this information if I execute "DSR_LICENSE" in uv when I'm located in a project directory. This gives me back a list containing all project...

I'm busy writing a reporting program on the jobs that ran last night in DataStage. For this I'm writing a BASIC job that will output the data of all of the jobs in a project: number of links written over all links, start time, job status, ... This will then later on be processed externally to report...

Could someone enlighten me how to delete rows from a table when selecting the rows to delete from the same table: my job consists of an ODBC source stage which selects the rows to be deleted from a table, the primary key of the rows is sent through a tansformer stage to a target ODBC stage where I w...

You would have to give some more information.

Usually the warning you see is that you're trying to insert data of a wrong type in a column. E.g. inserting a non-numeric value in an INTEGER column.

Ogmios

This is an easy one. You should specify the key columns of your table in the ODBC stage. If you do this the columns will appear in the WHERE clause of the delete.

Regards,
Ogmios
Belgium