DB2 UDB Load stage

ashwin141 · Post by **ashwin141** » Wed Sep 14, 2005 1:09 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Sep 14, 2005 1:16 am

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.

ashwin141 · Post by **ashwin141** » Wed Sep 14, 2005 1:40 am

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

Thanks
Ashwin

ArndW · Post by **ArndW** » Wed Sep 14, 2005 1:44 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Sep 14, 2005 2:53 am

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

ashwin141 · Post by **ashwin141** » Wed Sep 14, 2005 5:29 am

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

bcarlson · Post by **bcarlson** » Wed Sep 14, 2005 1:25 pm

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?

daniel0623 · Post by **daniel0623** » Wed Sep 14, 2005 8:56 pm

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.

ashwin141 · Post by **ashwin141** » Wed Sep 14, 2005 10:10 pm

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

bcarlson · Post by **bcarlson** » Thu Sep 15, 2005 10:35 am

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.

bikan · Post by **bikan** » Thu Nov 08, 2007 5:00 am

Hi,

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

chulett · Post by **chulett** » Thu Nov 08, 2007 7:12 am

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.

DSXchange