DSXchange

Thank you for all your responses . we got this requirement because in our environment , by mistake some of the other people migrating the jobs but forgetting to compile and because of which we are getting problems . To avoid that situation , we want to create a script which will scan through all the...

Hi All

I have a requirement of , create a script which will scan through all the set of jobs and then compiles if there are any jobs with "Not Compiled" State . Can anybody help me in this .

I would really appreciate your time and help on this.

Hi I am using Datastage Px version .I am trying to find out what job creates one dataset .I am using one query like SELECT NAME FMT '50L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL '@RECORD' LIKE '%dataset%' AND EVAL '@RECORD' LIKE '%dataset%' AND O...

Hi

In ETL Job I am doing load into a table using Oracle Enterprise stage and using the write method as LOAD . Is there anyway to specify the paths and names for the Log files , Bad Files and Discard files etc in ETL.

Can somebody help me on this . I would really appreciate Your time.

Hi Can we generate Statistics of a job as html document . I want to automize that part .So I created a batch file and I tried windows command of dsjob.exe as dsjob.exe /H=%Host% /U=%User% /P=%Password% ProjectName JobName > LogFile But I think I am missing something and hence I am not able to genera...

Hi

I am using using Datastage 7.5 version. I am having a quick query like , is it possible to find out for a given column in the metadata , what are all the jobs that column is referenced like that?

I would appreciate your help.

Sorry ..I did tried with the same query and was able to find out the job names .

Thanks for all your help and suggestions.

I am having one more question . Can we find out like in what job a particular dataset is used in the same way or will there be a different query or way for that?

I would really appreciate any suggestions.Thanks in advance.

Yes..It worked for me .But a small syntax change like I have used:

/dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL '@RECORD' LIKE '%x.dat%');"

Thanks for all your suggestions.

Hi Ray I was trying to run this query SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%x.csv%'); But it is failing DataStage/SQL: syntax error. Unexpected symbol. Token was "@RECORD". Any suggesti...

HI

We are using Datastage Parallel Extender and I am just wondering like is there any way I can determine how much CPU time the jobs are utilizing and how much memory they are using etc things .

I would appreciate any input .

Thanks.

HI I am experiencing a strange problem like I am writing data into a dataset .It is having more than 80 Columns in it .When I am attempting to write in to that the datastage job is failing with out giving any error messages . Is there any limitation on number of columns to writing into datasets ?? I...

Hi

Thanks for all your responses .

But I want to find out the status through command line and I want to avoid the uncompiled jobs by capturing the status of the uncompiled jobs also through command line .

So can you help me how can I achieve this?

Hi

I am trying to generate a report for all my datastage jobs . But in case some of the jobs were not compiled then it is giving an error message .


ERROR: Failed to open job

How to capture the status of those jobs , so that I can avoid to check those jobs from my report.

Thanks in advance.

Thanks Kenneth. I really appreciate your guidence and this one works .

Thanks again.