Writing to sequential file

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
PeterPol
Premium Member
Premium Member
Posts: 73
Joined: Wed Mar 08, 2006 8:59 am

Writing to sequential file

Post by PeterPol »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
Premium Member
Posts: 73
Joined: Wed Mar 08, 2006 8:59 am

Post by PeterPol »

Hi,

Output is not relevant because the job only needs to set the userstatus in the transformer.

Peter
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
PeterPol
Premium Member
Premium Member
Posts: 73
Joined: Wed Mar 08, 2006 8:59 am

Post by PeterPol »

hi all,

\NULL works !

Peter
Sanket_Saraph
Participant
Posts: 20
Joined: Tue Jun 13, 2006 5:16 am
Location: Pune

Post by Sanket_Saraph »

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 »

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
Premium Member
Posts: 73
Joined: Wed Mar 08, 2006 8:59 am

Post by PeterPol »

Example was for server job ...
:oops:
Post Reply