parameter extract

Do you have features you'd like to see in future releases of DataStage, MetaStage, Parameter Manager, Version Control or one of the other tools represented on this forum? Post your ideas here!

Moderators: chulett, rschirm

Post Reply
eldonp
Participant
Posts: 47
Joined: Thu Jun 19, 2003 3:49 am

parameter extract

Post by eldonp »

sequencers should have a stage that reads a single row from a file, or from a database so taht parameters can be passed to jobs easily.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

From a file is easily doable; use cat or head in an Execute Command stage (or type if it's Windows). Strip the field marks from the $CommandOutput activity variable.

Reading a row from a table is probably easily done with a server job. Use the user status area in the server job (the $UserStatus activity variable).
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