DSXchange

ray.wurlod wrote:I would use Advanced Find in the Designer client. Created/modified filters are available in this tool. ...

Ray,

As the number of jobs are HUGE, we decided to go for re-usable solution which hardly require any manual intervention.

Any help in fixing the query would be much appreciated.

Note that creation timestamp and last modified timestamp are two different fields and also just because the last modified timestamp is newer does not necessarily mean that the job was modified. It could simply indicate that the same existing job design was imported and overwritten. I agree with you...

How is it "not serving the purpose"? Craig, Looks like JOBID is not the right key column for the joining condition. JOBID SK A surrogate primary key to identify each specific executable version of a job that has been run. In my output file, the job names are repeating multiple time though...

I have a requirement to get the list of all the jobs created newly / modified in 2017 in the production Datastage server. There is an option in the operational console which gives the create date for each job. As the number of jobs are huge, I had written a datastage jobs which hits DSODB tables and...

Hi, I have designed a job to pull the data from Oracle table and load into Teradata table. As the source table has around 3 millions records, I have used BULK as access method in TD connector which is throwing the below error: RDBMS code 3621: Cannot load table plan_demand_WT unless secondary index...

We can define MOD function as

MOD(m,n)= m-n*floor(m/n)

As we have Floor function available in datastage, this calculation could be done in a stage variable and the final value could be used.