Hi
I have made a job that runs a stored procedure with the Stored Procedure Stage
The return value from this stored procedure is being put in the UserStatusArea of the job, for later reference in a sequence.
This is done in a transformer where i am calling a little routine writen in basic, that uses the DSSetUserStatus function to pass the return value to the UserStatusArea.
This is working fine
Problem is, a transformer needs an output link, so i gave it a text file to write something in.
i don't need that file for anything, so i am thinking if anybody has any good ideas of how to avoid this.
In a paralllel job i could just output to a peek stage but not in a server job.
Can i output to NULL from the transformer ?
any other ideas to avoid this extra file
Regards
Peter
can i output to NULL from transformer ?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 17
- Joined: Mon Dec 13, 2004 5:01 am
- Location: Denmark
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not directly, but you can use a Sequential File stage to append to the file .\NUL (which exists in every folder).
Tip: don't try to overwrite .\NUL - you have to append to it.
Tip: don't try to overwrite .\NUL - you have to append to it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 17
- Joined: Mon Dec 13, 2004 5:01 am
- Location: Denmark
- Contact:
[quote="ray.wurlod"]Not directly, but you can use a Sequential File stage to append to the file .\NUL (which exists in every folder).
Tip: don't try to overwrite .\NUL - you have to append to it.[/quote]
a little mistake (but i bet significant) in my starting post. This is in aLinux environment, does this have a similar concept ?
regards
PEter
Tip: don't try to overwrite .\NUL - you have to append to it.[/quote]
a little mistake (but i bet significant) in my starting post. This is in aLinux environment, does this have a similar concept ?
regards
PEter
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 17
- Joined: Mon Dec 13, 2004 5:01 am
- Location: Denmark
- Contact: