Search found 37 matches

by yabhinav
Tue Aug 04, 2009 3:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is it possible to pass a job parameter inside another?
Replies: 17
Views: 6184

Is it possible to pass a job parameter inside another?

Hi, Here's what im looking for let say i have i have a parameter by the name parcode = 'abc' and i have another parameter partranslation = 'alphabets #parcode#' when i use the parameter partranslation in my transformer it is displaying "alphabets #parcode#" instead of "alphabets abc&q...
by yabhinav
Wed Jul 29, 2009 1:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to update multiple jobs
Replies: 3
Views: 1006

Thanks for the advice , it worked!! and it was much faster than opening them manually and making the changes
by yabhinav
Wed Jul 29, 2009 12:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to update multiple jobs
Replies: 3
Views: 1006

How to update multiple jobs

Hi,
We have 50 jobs that are calling an oracle function in an oracle stage. We have recently changed the name of the function, so i need to update the all the 50 jobs!! Is there a way in this can be done in one shot?

Thanks,
Abhinav
by yabhinav
Tue Jun 09, 2009 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to parse a datastage job and fetch all col derivations
Replies: 12
Views: 4476

Is this functionality available on 7.5 version??
by yabhinav
Tue Jun 09, 2009 4:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to parse a datastage job and fetch all col derivations
Replies: 12
Views: 4476

Here's why we need such a requirment. Our system gets its data from various source like mainframes, db2 and MQs. And we perform a lot of calulations on the incoming feed and then send it to our warehouse, which serves as a reporting platform to other applications. The plan is to have an intermediate...
by yabhinav
Tue Jun 09, 2009 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to parse a datastage job and fetch all col derivations
Replies: 12
Views: 4476

Thank you all for your suggestions. I've been trying export the job as an xml and parse it, but i guess this is gonna take me some time.

Will update as soon as i come up with something

Regards,
Abhinav
by yabhinav
Mon Jun 08, 2009 6:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to parse a datastage job and fetch all col derivations
Replies: 12
Views: 4476

How to parse a datastage job and fetch all col derivations

I need to come up with a way to export all the columns used in datstage job into an text file. The details have to be stage wise. For Example : Suppose i have a job which has 3 stages (Oracle , transformer and sequential file) My output file shud have Oracle Tansformer Seq Emp (varchar) Emp Emp Empi...