četrtek, 09. februar 2017

DB2 LOAD from CURSOR

You can do a LOAD from CURSOR in command line. Example is taken from Fast and easy data movement using DB2's LOAD FROM CURSOR feature:

db2 "DECLARE C1 CURSOR FOR SELECT * FROM FECHNER.SALES"
db2 "LOAD FROM C1 OF CURSOR MESSAGES C:\load_sales_tmp.msg INSERT INTO FECHNER.SALES_TMP NONRECOVERABLE"
Objavite komentar