DB2 Bulk Load

[sridharvg]

I have a job which has a DB2 API stage as source and DB2 bulk load as Target. While I am compiling the job I am getting the error "minimum 1 output stream(s) required" in DB2 Bulk Load stage. Can any one of you help me in fixing this error.

Thanks in advance.

[ArndW]

I just tried a job as you described and it compiled just fine at 7.5.1.2

Are you certain that your link actually connects to the stage (i.e. move the bulk load stage around and see if the link follows it in the designer)

[sud]

I have a job which has a DB2 API stage as source and DB2 bulk load as Target. While I am compiling the job I am getting the error "minimum 1 output stream(s) required" in DB2 Bulk Load stage. Can any one of you help me in fixing this error.

Thanks in advance.

I have faced this problem before. Isn't the bulk load stage a server only stage?

[bcarlson]

Is there a reason you are using the API stage vs. the DB2 Enterprise stage? From our experience, the performance is much faster with the Enterprise stage - it can also do loads.

Brad.

[ray.wurlod]

Please post the complete and exact error text (double click in Director to retrieve it).

I am surprised to learn that any bulk load stage requires any output. In my experience they simply consume their input.

[SAMEENA]

Hi Ray,
Even I am facing similar problem.When I compile the job I get following error :

"Stage 'DB2_UDB_Load_1' requires minimum of '1' stream output(s)".

My job is
Sequential File --> DB2/UDB Bulk Load

Thanks in advance.

[ray.wurlod]

Read the on-line help or the manual chapter for this stage, in particular its requirement for connected links.