Quote:
Originally posted by aegluke
Hi,
is there any way to use the load-statement via ado or odbc? every call was answered by a db2-cli error message.
the command "load from "C:\test.del" of DEL INSERT INTO TABLE Test" works with the command line processor but not with ado. any hints?
thanks
Erik
|
Hint: you can only run SQL commands using ADO/ODBC/JDBC/etc, and LOAD is not a SQL command, it's a CLP command. Therefore, to process it you need CLP.
To launch LOAD programmatically you could execute CLP from your program and pass the LOAD command to it.