source program in external source stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
djoni
Participant
Posts: 98
Joined: Wed Oct 05, 2005 1:01 pm

source program in external source stage

Post by djoni »

What must the Source Program do in an External Source Stage?
djoni
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It must generate rows of data that can be received, interpreted as one or more columns, and put onto the stage's output link.

For example, I have created an External Source stage to get data out of a UniVerse table. It invoked a shell script that
  • made sure environment variables were correctly set

    changed to the project directory (just in case)

    executed the uv command

    tidied up the output of the uv command
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
djoni
Participant
Posts: 98
Joined: Wed Oct 05, 2005 1:01 pm

Post by djoni »

ray.wurlod wrote:It must generate rows of data that can be received, interpreted as one or more columns, and put onto the stage's output link.
A sequential file (UNIX file) ?

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

Post by ray.wurlod »

No. The stage picks up its source from stdout of whatever command is executed. There ought to be no file involved (unless, as I did, you employ a shell script).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply