Sure, something like:
Code:
LOAD DATA
INFILE 'vendors.dat'
BADFILE 'vendors.bad'
DISCARDFILE 'vendors.dsc'
REPLACE
INTO TABLE vendors
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
( vendor_type_lookup_code "RTRIM(:vendor_type_lookup_code)",
vendor_name "RTRIM(:vendor_name)",
num_1099 "RTRIM(:num_1099)",
process_status CONSTANT 'PENDING'
)
INTO TABLE vendor_contacts
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( vendor_site_code "SUBSTR(:vendor_site_code, 1, 15)",
first_name CHAR(15) "RTRIM(:first_name)",
middle_name CHAR(15) "RTRIM(:middle_name)",
last_name CHAR(20) "RTRIM(:last_name)",
org_id CONSTANT 3,
process_status CONSTANT 'PENDING'
)