Execute a routine into a command stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Actually using .\NUL as source is a Bad Idea - it will deliver an infinite amount of empty lines. This is a useful technique in scripting, but outside the current discussion. You can use a Transformer stage with a stage variable and a constraint of @INROWNUM = 1 to generate a single row. The Transformer stage needs no input link in a server job, provided it has something to do, such as evaluate a stage variable. Naturally, the value generated must be put onto a column on the output link.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Alethesnake
Participant
Posts: 56
Joined: Mon Mar 26, 2007 8:48 am
Location: Blue Bay (La Spezia)

Post by Alethesnake »

Perfect, thanks a lot for your suggestion. :D

Regards,

Ale.
...
Post Reply