DSXchange

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

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.

No it's a solid link. Not a reference or Reject link.


Thanks
Ashwin

I suspect that you might have specified a "reject link" in the stage, which does require an output stream.

But the error is "requires a minimum of '1' stream outputs". Does the menu show a "Convert to Stream" option?

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

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?

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.

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

Have you tried using the DB2/UDB Enterprise stage instead of the DB2 Load stage? I have always used the Enterprise stage and have not had any issues. You can choose a write method of load, delete, write or upsert. The load option uses DB2's load utililty.

Brad.

Hi,

I am facing the same problem. Iguess Db2/UDB load stage does not work properly in 7.5.1

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.