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
PeterPol
Premium Member
Posts: 73 Joined: Wed Mar 08, 2006 8:59 am
Post
by PeterPol » Tue Feb 20, 2007 8:28 am
Hi all,
My simple job has the following stages:
SYBASEOC --> Transformer --> Sequential File
Since writing to the sequential file is irrelevant, I wondered if I can skip this target stage? Or can I use a dummy (non-existent) filename?
Peter
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Feb 20, 2007 8:35 am
Yes, but it will just be created for you. If it is too much of a dummy it will cause the job to abort. It would help if you explained why it is 'irrelevant' in this case, I would think, so the suggestions can be more... targeted.
-craig
"You can never have too many knives" -- Logan Nine Fingers
PeterPol
Premium Member
Posts: 73 Joined: Wed Mar 08, 2006 8:59 am
Post
by PeterPol » Tue Feb 20, 2007 8:47 am
Hi,
Output is not relevant because the job only needs to set the userstatus in the transformer.
Peter
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Tue Feb 20, 2007 8:54 am
You can write it to NULL. In unix it would be /dev/null. I think its windows equivalent is NUL or \NULL.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Feb 20, 2007 8:55 am
If you were on a UNIX server, I'd suggest writing to '/dev/null'. From what I recall, there is an equivalent on Windows but not sure what it is off the top of my head. Anyone?
Ah... Chuck snuck in right before me.
-craig
"You can never have too many knives" -- Logan Nine Fingers
PeterPol
Premium Member
Posts: 73 Joined: Wed Mar 08, 2006 8:59 am
Post
by PeterPol » Tue Feb 20, 2007 9:11 am
hi all,
\NULL works !
Peter
Sanket_Saraph
Participant
Posts: 20 Joined: Tue Jun 13, 2006 5:16 am
Location: Pune
Post
by Sanket_Saraph » Tue Feb 20, 2007 11:30 am
If writing to file is not mandatory then you can put copy stage as trash.
SANKET SARAPH
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Feb 20, 2007 1:58 pm
Just curious - how are you setting the user status in a parallel job?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
PeterPol
Premium Member
Posts: 73 Joined: Wed Mar 08, 2006 8:59 am
Post
by PeterPol » Wed Feb 21, 2007 1:22 am
Example was for server job ...