Loading table with parameter values

mydsworld · Post by **mydsworld** » Mon May 12, 2008 10:27 am

I need to run a DS job that just loads some passed parameters into a table (for error logging).However I find :

Transformer -> DB2 API

gives error, as I require to specify some input stage.

Please let me know which stage is to be used (and how) as dummy.

Thanks

Madhavan VM · Post by **Madhavan VM** » Mon May 12, 2008 10:47 am

Hello,

I believe the job that you have designed consists of only a transformer and then a DB2 API stage. This would not work. Provide a row generator to generate a dummy row with dummy value and then a transformer and then the DB2API.

mydsworld · Post by **mydsworld** » Mon May 12, 2008 12:02 pm

Then shall I not be constrained by the number of row generator records in the input. Say if the row generator is set to generate 10 rows then the loaded count in DB2 API will also be 10. Also, the dummy rows may not be relevant to the DB2 API stage.