DSXchange

Hi I am able to run the query and get the result . But I am seeing like this query is using a LIKE condition for the matching against the table index(UPCASE(@RECORD),'YOUR_TABLE_NAME',1) Is there any way , I can match exactly with the same string , cause in our case we have tables like x and xy .But...

Thank you . Now the query is working after I replaced the '' with the ' ' .But now I am wondering with the result of the query. I actually saw this query in the forum to get the jobs where a table has been used . In one of my job , I did not used the table explicitly anywhere in the query .But the r...

Thanks for the response. But I am failing to figure out the Problem with this universe query. I would really really appreciate any help in correcting this . /dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT DISTINCT DS_JOBS.NAME AS JOB_NAME FMT '100L', DS_JOBOBJECTS.NAME AS OBJECT_NAME FMT '...

Thanks for the reply.But I am confused here . I am running this command from Unix box at the project directory .

Is there anything I have to try differently. I am having a feeling that there is something wrong with the syntax I am using .


Any other Suggestions for me ?

I have tried this : /dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT DISTINCT DS_JOBS.NAME AS JOB_NAME FMT '100L', DS_JOBOBJECTS.NAME AS OBJECT_NAME FMT '100L', DS_JOBOBJECTS.OLETYPE FMT '100L', EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'TableNm',1) > 0 THEN 'FOUND' ELSE ''" AS FOUND F...

Hi I am using the query "SELECT DISTINCT DS_JOBS.NAME AS JOB_NAME FMT '100L', DS_JOBOBJECTS.NAME AS OBJECT_NAME FMT '100L', DS_JOBOBJECTS.OLETYPE FMT '100L', EVAL DS_JOBOBJECTS.'IF INDEX(@RECORD,'MYTABLE',1) > 0 THEN 'FOUND' ELSE ''' AS FOUND FMT '5L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.J...

Is there any Round about way for this like , take a table name and use the universe query to see if a job is using this or Not ?

Thanks for the Reply Ray. I have created a server job in which I am using the Universe stage and in there I am querying "SELECT DS_JOBS.NAME FMT '50L', DS_JOBS.CATEGORY,DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS.'@RECORD<14>' FMT '1000L' FROM DS_JOBS ,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOB...

HI I am using the query "SELECT DS_JOBS.NAME FMT '50L', DS_JOBS.CATEGORY,DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS.'@RECORD<14,4>' FMT '1000L' FROM DS_JOBS ,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND DS_JOBOBJECTS.OLETYPE IN ('CCustomOutput') AND EVAL DS_JOBOBJECTS.'@RECORD' ...

Hi Kim

Thanks for your response . But Yes , I am kind of failing while getting the Table properties for the Parallel jobs . I could not find out the job in the Etlstats though.

I would really appreciate all your time for helping me on this.

Thanks For your response . Till 2011 , we are not planning to migrate to 8.x and we are actually requesting for that . But in the mean while , we want to create the inventory. can you please tell me how can list out all the Properties for the Parallel job .I have tried this query. SELECT DS_JOBS.NAM...

Hi All Is there Any way I can find Out what are all the tables that are used in a datastage Job . In Our environment as the data Model changes dynamically , we want to prepare inventory of the list of tables and the jobs that are using them . This will be really helpful for us in order to prepare ki...

HI All As part of one of our requirements , I am actually selecting the list of jobs that are modified in a project using the below query: "SELECT SUBSTRING(DTM FROM 1 FOR 10) AS MODDATE,INSTANCE FMT '50L',REASON FMT '100L',MODIFIER FROM UNNEST DS_AUDIT ON MODS WHERE MODDATE='2009-08-13' AND CL...

I Am sorry. But when I have tried : "SELECT DISTINCT CAST(SUBSTRING(DTM FROM 1 FOR 10) AS DATE) FROM DS_AUDIT ; I am not getting any output . And when I am trying /dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT DISTINCT CAST(CURRENT_DATE AS VARCHAR) FROM DS_AUDIT ;" I am getting ...

Thanks for the Reoly Ray.But the Problem is , seems like the formats are wrong .I am testing for a job , but it is not giving the expected result .

Any Suggestions?