Search found 42189 matches

by chulett
Mon Jan 18, 2016 9:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to output source non-xml columns from xml input stage
Replies: 5
Views: 1858

Things usually are buried somewhere, you just need to learn where to dig. From the XML Pack Guide in Chapter 3: Using XML Input, find the section called Passing Data From Input to Output link: Each output link supports a passthrough mechanism by which data is copied without modification from the inp...
by chulett
Mon Jan 18, 2016 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD stage keep adding unchanged records into table
Replies: 6
Views: 2530

:!: Naveen, please stop quoting everything you are replying to all of the time. Do it selectively when it serves a purpose, sure, but all the time? Instead please make use of the perfectly lovely Reply to topic link at the top and bottom of every discussion page. Your far too overworked DS Janitoria...
by chulett
Mon Jan 18, 2016 8:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Connector Issues
Replies: 3
Views: 1034

:!: Rather than jump on the end of a very old message for a different version on a different platform, let's get you off into your own post... done.

Please post your error message.
by chulett
Sat Jan 16, 2016 2:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dynamically select the column at runtime
Replies: 10
Views: 3571

:!: Not sure why this question was posted four times, including once well after I'd answered in this one. I nuked the other three.
by chulett
Fri Jan 15, 2016 3:15 pm
Forum: General
Topic: How can I delete a sequential file after running the job?
Replies: 7
Views: 1632

Sorry, should have started you at the parent topic so you get the full scope. You only need to supply all of that fancy expression editor syntax for a custom trigger and in my experience, most of the time you won't need a custom trigger.
by chulett
Fri Jan 15, 2016 1:17 pm
Forum: General
Topic: How can I delete a sequential file after running the job?
Replies: 7
Views: 1632

Need to add a condition? Not necessarily as it would depend on what behavior you wanted. An unconditional trigger fires all the time, so use that if that is what you need. If you only want the file deleted at Step 2 if the job at Step 1 finished OK, make sure your trigger expression supports that. ...
by chulett
Fri Jan 15, 2016 11:15 am
Forum: General
Topic: How can I delete a sequential file after running the job?
Replies: 7
Views: 1632

Sure and you've got options here. One place would be an "After Job" process, specifically an ExecSH to issue the delete command to the O/S in whatever job needs it last. Heck, even Before Job as long as it is no longer needed at that point. Or as noted you could add an Execute Command stag...
by chulett
Wed Jan 13, 2016 2:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rnd function returning the same value
Replies: 7
Views: 8014

Questions for your official support provider, I would think.
by chulett
Wed Jan 13, 2016 10:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer. Would like to hear some ideas.
Replies: 5
Views: 1848

Stage variables and a mod() function comes to mind, that and the @INROWNUM system variable. And a single node.
by chulett
Tue Jan 12, 2016 11:45 pm
Forum: General
Topic: Invoking Datastage job from Oracle DAC
Replies: 1
Views: 1214

The so called Data warehouse Administration Console? Ick, what a work of art that is. :roll: Unless things have changed, the only thing it supports are Informatica jobs natively or an "External Program", i.e. something invoked at the command line. So I'm assuming that if you have a wrapper...
by chulett
Tue Jan 12, 2016 10:35 am
Forum: General
Topic: re-run the activities in sequence
Replies: 7
Views: 2967

Oh, I understood your problem just not what "re-run" has to do with anything. :wink: Again, one Email stage = one email sent and there's no way around that. And a Sequencer set to Any fires when the first link arrives, not over and over as all of them arrive. So... if you really need (up t...
by chulett
Tue Jan 12, 2016 8:13 am
Forum: General
Topic: re-run the activities in sequence
Replies: 7
Views: 2967

One Email Activity stage = one email. What's different about the three emails you need to send?

Also curious what your question has to do with the subject you chose for your post. They seem... unrelated. :?
by chulett
Mon Jan 11, 2016 2:15 pm
Forum: General
Topic: designer not show jobs
Replies: 4
Views: 1881

Re: designer not show jobs

factorit wrote:all jobs and proyect was migrated form engine 1 to engine2
Migrated how exactly?
by chulett
Fri Jan 08, 2016 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XMLTYPE write issue using Oracle connector stage
Replies: 2
Views: 6818

Seems to me you'd have to craft custom insert SQL for this, perhaps something here would help. It also mentions a version of your work around.