I want to use my custom SQL in the DB2 Import statement.
IMPORT from c:\tmp\a.txt of DEL modified by coldel| method N(password, loginId) messages c:\tmp\b.txt insert_update into tableA set password = password where colA = (select colA from tableB where loginID = logid).
Here password and logid are the values which i read from the flat file a.txt and update tableA based on the above where condition. Can I achieve using DB2 Import command or similar DB2 utilies?
I have already written a java program which does this. But I would prefer a built in DB2 tool which will do this for me.