Search found 6 matches

by Dev_help
Mon Dec 17, 2007 2:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Alternative to @INROWNUM system variable
Replies: 3
Views: 2579

If you want to generate a series of unique sequence numbers, then you may use a surrogate generator stage.
by Dev_help
Fri Dec 14, 2007 8:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File Reject link
Replies: 12
Views: 7900

@vinita,

Also, what you can do is put a Copy stage after the Transformer, and on one output link of the copy stage put your second seq file, and on the other output link from the Copy stage carry on with your sort operation.

Doea this make any sense?
[/code]
by Dev_help
Fri Dec 14, 2007 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File Reject link
Replies: 12
Views: 7900

@vinita, The answer to your question is that it is the PROPERTY of seq file that if something is being written to it (your second seq file stage), then you cannot read from it at the same time. That is, for a seq file stage you cannot have a stream input link and a stream output link at the same tim...
by Dev_help
Fri Dec 14, 2007 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File Reject link
Replies: 12
Views: 7900

@Aakash,

I thought you were talking about the second seq file and not the first.
by Dev_help
Fri Dec 14, 2007 5:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File Reject link
Replies: 12
Views: 7900

All I can think of, is that by mistake you must have clicked 'Convert to reject'. Try converting your output link from seq file to a stream link. To do this: Right click on the link. In the menu popped up, click 'Convert to Stream'. Hope it helps. Cheers Aakash Aakash, I don't think you will get th...
by Dev_help
Fri Dec 14, 2007 4:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File Reject link
Replies: 12
Views: 7900

Sequential File Reject link

What Aakash has specified is absolutely correct. If you have an input link to a Seq File then the only output link can be a reject link. The significance of this reject link is that if due to some reason a particular records is not being written to the seq file, then it could be captured in this rej...