LOAD DATA
CHARACTERSET UTF8
INFILE '$MSIAP_TOP/log/file_list_toload.dat'
INTO TABLE XSIAP_RUSSIA_PMT_ACK_DATA APPEND
(
REQUEST_ID constant \"$REQ_ID\",
FILENAME constant \"$fname\",
file_name filler char(200)
,xml_data LOBFILE (file_name) TERMINATED BY EOF
)
No comments:
Post a Comment