Hello,
I am using the udb 8.1 task scheduler to schedule a load. Is there
any way to also schedule an OS command (win32) to delete the file
after the load? I have a python script that will do what I need, I
just need to call it after the load. One more question: is there
anyway to use the import (rather than the load) to import fixed width
data. It is scheduled every 10 minutes. I would rather insert and
update rather than load. Right now, I have an ugly hack written in
Python that concat's text files(IMS data) and drops them into a load
directory as one file. The DB2 scheduler runs and they are imported.
I just need to delete the file after load so I will not get duplicated
entries in my table. (I do have a primary key but the load seems to
ignore it). any suggestions would be appreciated.
Thank You,
Keith