CODEWITHSUNDEEP
importloaddb2odbcwizard
Manuel Arce
Manuel Arce

Reputation: 70

call db2 load statement from an odbc connection

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):

SQLEXEC(nMyConn,cStatement)

but it fails with error SQL0104N I've tried with "" and '' for the path parameters but the problem persists. Any Ideas?

Upvotes: 0

Views: 241

Answers (1)

Fred Sobotka
Fred Sobotka

Reputation: 5332

The DB2 CLP can run LOAD and other non-SQL commands that client applications cannot send over a driver-based connection. DB2 provides a system stored procedure called ADMIN_CMD, which client connections (ODBC, JDBC, etc.) can call to initiate any of several popular administrative commands, including LOAD.

Upvotes: 1

Related Questions