transform as source

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

Post Reply
femil
Participant
Posts: 27
Joined: Mon Nov 02, 2009 10:54 am
Location: chennai

transform as source

Post by femil »

hi friends can someone tell me how can i use a transform as source stage..

i need to assign some constant values in transform stage without using a source(passive) stage and insert those values into the database using a oracle target stage


my purpose is implement this without using any source passive stage
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Create a stage variable. Doesn't need to be used but it does need to exist. Then use an appropriate constraint like @OUTROWNUM=1 to control the number of rows it generates.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply