DB2 Bulk load filename creation
Posted: Thu Sep 09, 2004 3:24 am
Example..
In the DB2BULK stage, the .sh, .clp and .dat files created are:
uload.sh
cmd.clp
inpdata.dat
In the DB2BULK stage, the .sh, .clp and .dat files created are:
uload.sh
cmd.clp
inpdata.dat
the problem guys is that should I run these in paralell, Job1 or Job2 will complain about the filenames being created are locked or will overwrite the existing filenames hsould I run them in series.
Is there a way I can parametise these names? With other bulk load stages the .dat etc are called TABLENAME.dat, which I believe is a good way of doing things.
Code: Select all
JobName: Job1
Table to be loaded: CUSTOMER
SOURCE ------- TFM -------- DB2BULK
uload.sh
cmd.clp
inpdata.dat
Code: Select all
JobName: Job2
Table to be loaded: PARTNER
SOURCE ------- TFM -------- DB2BULK
uload.sh
cmd.clp
inpdata.dat
the problem guys is that should I run these in paralell, Job1 or Job2 will complain about the filenames being created are locked or will overwrite the existing filenames hsould I run them in series.
Is there a way I can parametise these names? With other bulk load stages the .dat etc are called TABLENAME.dat, which I believe is a good way of doing things.