Data Express - How to create the Unload Output name for every DB2 table after running Import Method from Referential Integrity job

Problem: 

 After running Import Method from Referential  Integrity job BTEDDUR:

1. Steps from 001 till 300 are created although only one or two steps contain DB2 tables, the others are empty.  Is it possible to delete the empty steps?  Is it correct all these steps to be generated ?
2. The Unload Input and Output Data Store Properties are without Data Store Name.  It this correct?  If yes, should you fill in all Data Store Names?

Resolution:

 1)  This behaviour is  correct.  The Import Method from Referential  Integrity (BTEDDUR) creates automatically  300 steps and moves the tables into steps  10, 20 , 30 etc.  So that, the empty steps can be deleted.

 2)   When the DB2 data stores are accessed directly  the input unload name is empty.  You can leave it empty, no need  to fill in the input unload name.  For the output unload data stores’ names you can fill in them manually or running  a query over the Data Express KB tables.  In order to create the Unload output name for each involved DB2 table in the method you can execute this query:

UPDATE &&&&&&&&.HSDCHFIL A

SET A.UNLOUTNAM =  'PREFIX1.PREFIX2.PREFIX3.' CONCAT UNLINPNAM

WHERE EXISTS

(SELECT * FROM

&&&&&&&&.HSURDCOM B, &&&&&&&&.HSURDFIL C 

WHERE A.MCRECID = B.MCRECID

AND C.MCRECID = B.MCRECID

AND A.FILRECID = C.FILRECID

AND A.METHOD = '$$$$$$$$ '

AND B.MACHINEID = ' %%%%%%%%'

AND B.CDSOC = '!!!!!!!!'

AND A.UNLINPNAM <> ' ');

COMMIT;

Where:

-   &&&&&&&&                                   is the name of the OWNER of the Data Express KB tables;

-   PREFIX1.PREFIX2.PREFIX3.         is the name of the Output Unload SEQUENTIAL file (please leave the final “.”);

-   $$$$$$$$                                     is the METHOD name;

-   %%%%%%%%                        is the MACHINE ID name;

-   !!!!!!!!                                            is the COMPANY name;