DSXchange

Done...its been solved... As pjsimon wrote, The logic works only for the first record.......cos the second while loop in the code executes only once.......Is there a way to make the second loop run for each and every input record??????........ In DS job,in BuildOp stage,change execution mode to &quo...

I have similar code from buildop: struct gui_rec { int win_id; string app_name; string exe; string win_title; string rule1; string rule2; int type; } gui_array[5000]; int rcnt=0; readRecord(1); while (!inputDone(1)) { gui_array[rcnt].win_id=InLkp.WINDW_ID; gui_array[rcnt].app_name=InLkp.APP_NAME; gu...

Its not the actual lookup stage used.
In the BuildOp code itself,both the inputs are managed.
DB2 Table records are taken in a structure array and for every row of the Input file(9 million rows),the array is called.(written code in Per-Record).

I have a DS job that uses custom stage BuildOp. It has 2 inputs-a dataset with about 9 million rows/day and a DB Table(as in ternal lookup) with about 1500 rows.Job takes about 40 minutes to finish every day. Now,DB Table size has grown to 11000 rows and the performance has gone down drastically. :c...

Its Done :D

I am using BuildOp stage and have two inputs for the same. One is Input file of about 9 million rows/day and other is a DB2 Table of about 2000 rows. BuildOp runs fine everyday. Now,I added about 10,000 rows more to DB Table and when tried to run BuildOp,I am getting following Warnings: ETEWatchWebB...