DB2 UDB Load stage
Moderators: chulett, rschirm, roy
DB2 UDB Load stage
Hi
I am trying to load some data from a sequential file to a DB2/UDB load stage after doing some transformations. After specifying the properties for the DB2 stage. It's giving an error "requires a minimum of '1' stream outputs"
Can anybody help me on this.
Thanks
Ashwin
I am trying to load some data from a sequential file to a DB2/UDB load stage after doing some transformations. After specifying the properties for the DB2 stage. It's giving an error "requires a minimum of '1' stream outputs"
Can anybody help me on this.
Thanks
Ashwin
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is the link between the Sequential File stage and the DB2 Enterprise stage a solid line or a dashed line? If it is a dashed line this means that it is a reference or reject link. You need to select the link, right click, and choose "Convert to Stream" from the menu.
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.
DB2 UDB Load stage
No it's a solid link. Not a reference or Reject link.
Thanks
Ashwin
Thanks
Ashwin
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DB2 UDB Load stage
Hi
No there is no reject link from the stage.
And it's not showing the convert to stream enabled.
It's just showing
Convert to reject and reference enabled.
Thanks
Ashwin
No there is no reject link from the stage.
And it's not showing the convert to stream enabled.
It's just showing
Convert to reject and reference enabled.
Thanks
Ashwin
Is this error occurring at compile time or is it a runtime error?
I have noticed that you can draw links in DataStage Designer that 'look' like they connected to the target stage, but may not and that could produce a similar error message at compile time.
Brad.
It's okay to admit stupid mistakes, right?![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
I have noticed that you can draw links in DataStage Designer that 'look' like they connected to the target stage, but may not and that could produce a similar error message at compile time.
Brad.
It's okay to admit stupid mistakes, right?
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China
The same problem puzzled me.
I also can't use DB2 Load Stage with same error in Parallel Job.But I can use it in server job.I think it is may be a bug.
DB2 UDB Load stage
Hii
Carlson it's not a stupid mistake. :D
It's not working. You can try it out.
May be it's a bug. I am not sure. That's why I am here.
Anyway thanks
Regards
Ashwin
Carlson it's not a stupid mistake. :D
It's not working. You can try it out.
![Smile :)](./images/smilies/icon_smile.gif)
May be it's a bug. I am not sure. That's why I am here.
Anyway thanks
![Smile :)](./images/smilies/icon_smile.gif)
Regards
Ashwin
I wouldn't make any such guess. You've resurrected a two year old thread with basically a post that just says 'Me too!'.
Suggestion: For times like this start a new thread and document exactly what problem you are having. Provide a link back to the old thread if you feel it would be helpful. Include your job design and error(s) encountered. You could also report this to your support provider, if there is indeed a problem with the stage then I would surely think that by now a patch would be available to correct it.
![Wink :wink:](./images/smilies/icon_wink.gif)
Suggestion: For times like this start a new thread and document exactly what problem you are having. Provide a link back to the old thread if you feel it would be helpful. Include your job design and error(s) encountered. You could also report this to your support provider, if there is indeed a problem with the stage then I would surely think that by now a patch would be available to correct it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers