I have this txt file, formatted with the '|' character between columns, and this script generated by the db2 LOAD wizard:
LOAD FROM "<path_and_name_of_the_txt_file>" OF DEL MODIFIED BY ANYORDER COLDEL| METHOD P (1, 2, 3) MESSAGES "<path_and_name_of_a_new_log_file>" REPLACE INTO DB2ADMIN.WEB_NOHAB_CONSOLI (RUC, RAZSOC, FECHA) NONRECOVERABLE INDEXING MODE AUTOSELECT LOCK WITH FORCE;
The script just works ok. Now I have to call it from my VFP form (cStatement contains all the LOAD from above):
but it fails with error SQL0104N I've tried with "" and '' for the path parameters but the problem persists. Any Ideas?