Search found 592 matches

by JoshGeorge
Thu May 03, 2007 8:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Number
Replies: 9
Views: 3573

How about this:
Put an external filter stage and use UNIX command cat -n
(Propagate a column from the previous stage for this with blank probably - varchar of the size you want)
by JoshGeorge
Thu May 03, 2007 7:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of RTI and MQ stages
Replies: 15
Views: 8849

nick.bond wrote:
But after reading one msg it does not go back by it self and wait for the next msg.
You sure?
Try it out for yourselves :) you'll be sure
by JoshGeorge
Thu May 03, 2007 6:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of RTI and MQ stages
Replies: 15
Views: 8849

trobinson wrote:The MQStage is capability of keeping the job alive and listening for messages by itself 24X7 if required. No Sequence looping mechanism required.
No Dispute on that capability. But after reading one msg it does not go back by it self and wait for the next msg.
by JoshGeorge
Thu May 03, 2007 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Best approach for unknown varied source
Replies: 19
Views: 7549

Re: Use of Java Pack in Datastage?

Give XML a shot :) Ask all Java applications to send what ever they want in a common XML format. (You can accept data in junks as records and segrigate accordingly - use colum seperater stage,...).
by JoshGeorge
Thu May 03, 2007 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of RTI and MQ stages
Replies: 15
Views: 8849

Re: Use of RTI and MQ stages

Above said is possible. You will have to run a job which always listen to MQ for this. In a seq keep looping this job. When a msg hits MQ process it and loop back
by JoshGeorge
Thu May 03, 2007 6:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing non-alphanumeric characters using Convert function
Replies: 9
Views: 10523

Try this: Put an external filter and use unix command in your job to strip non alphanumeric characters
by JoshGeorge
Thu May 03, 2007 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instance Job
Replies: 4
Views: 1661

Re: Multiple Instance Job

Select Attributes Job: Select the Attribute names from the static table to a seq file and the total count to another file Main Seq: Read the count using UVactivity (Write a routine to read seq file) Start a loop (1 to count), read current loop num line from the seq file with attribute names and pass...