DSXchange

Given a particular job name, from the Datastage repository can I query(from Administrator or otherwise) to find out what is the source and target table names used in the Job. Assumption is that I use only one source and target table and I use the Dynamic RDBMS stage for both. (If not familiar with D...

No. I will need a unique preassigned value which will never change.
Thanks for the SQL format. That was better.

Thanks Michael.

Kim, This is to assign unique serial numbers to jobs and it is to comply
with some organizational standards.

Regards,
SGT

Thanks for the solution. I understand that it will be the responsibility of the development team to maintain unique and proper serial numbers in the short description.

Can the query me modified just to return the jobname and nothing else. I do not want to see the root path and such things.

My requirement is this: I have to assign some sort of user defined serial numbers to all the jobs in my project. For instance Job1 - SERIAL1001 Job2 - Serial1002 Job3 - Serial1003. One way of doing this could be adding the serial number to the job name. But if possible I want to avoid it. Using this...

Okay let us assume that I am not going to set anything. I just want to query and use the values in DS_JOBS. Can somebody tell me what all are the columns in DS_JOBS and how to query them. For example the job name has to be queried using "NAME". Also I want to know what is this Description....

When I query the Administrator SELECT * FROM DS_JOBS I see the columns Job Name, Description, No. and Category. Now it allows me to use Name and Category in the where clause but how to query for the Description and No. Also how do I set the number. Is this some internal serial number. Can I set it t...

Unfortunately there is no proper standard where we used table definitions. But the table names are hardcoded.

I need to find out all the jobs in a project which accesses a particular Database table.
What is the easiest way to get this list?
Thanks,
SGT