Transfmer without an input link?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 83
- Joined: Tue Dec 19, 2006 8:38 am
Transfmer without an input link?
Hi Everyone,
Will transfmor work with out an input link?
I know 1 way using stage variable and using constraint
Like @inrownum <1
Heard there are other ways can any one tell me?
Will transfmor work with out an input link?
I know 1 way using stage variable and using constraint
Like @inrownum <1
Heard there are other ways can any one tell me?
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Observation: @INROWNUM < 1 will "work" - inasmuch as the job will compile and run without error, evaluating its stage variable(s) - but will not generate any rows.
The "other way" is probably to have a before-stage or after-stage subroutine.
The "other way" is probably to have a before-stage or after-stage subroutine.
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.
Not generating any rows may be exactly what you want. I typically do that for either zero rows with an @FALSE constraint or for one row with @OUTROWNUM=1 constraint. The former might be used to clear a hashed file or truncate a table, for instance - the latter to trigger something 'special' in an OCI stage or for the STP stage.
Hadn't thought about the routine... a 'no op' routine perhaps? Its only purpose would be to appease the compiler, it would seem.
Hadn't thought about the routine... a 'no op' routine perhaps? Its only purpose would be to appease the compiler, it would seem.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Transfmer without an input link?
@inrownum wont work as there is no input link and it wont generate the row. your constraint should be @outrownum<2georgesebastian wrote:Hi Everyone,
Will transfmor work with out an input link?
I know 1 way using stage variable and using constraint
Like @inrownum <1
Heard there are other ways can any one tell me?
SMB