call admin_cmd('load from (select * from T1 fetch first 400 rows only) of cursor insert into T2 nonrecoverable');

select ROWS_LOADED into v_num_rows from table( admin_get_msgs(operation_id) as msg);

 
db2 "call admin_cmd('load from (select * from t10) of cursor messages on server  insert into t1 nonrecoverable')"
 
 Result set 1
 --------------
 ROWS_READ            ROWS_SKIPPED         ROWS_LOADED          ROWS_REJECTED        ROWS_DELETED         ROWS_COMMITTED       ROWS_PARTITIONED     NUM_AGENTINFO_ENTRIES MSG_RETRIEVAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    MSG_REMOVAL                                                                                                                                                                                                                                                                                                                                                                                                                    
 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
               449596                    0               449596                    0                    0               449596                    -                     - SELECT SQLCODE, MSG FROM TABLE(SYSPROC.ADMIN_GET_MSGS('1389781381_DB2INST1')) AS MSG                                                                                                                                                                                                                                                                                                                                                                                                                                             CALL SYSPROC.ADMIN_REMOVE_MSGS('1389781381_DB2INST1')                                                                                                                                                                                                                                                                                                                                                                          
 1 record(s) selected.
 Return Status = 0

create procedure test_adm(
out p_rows_exp BIGINT,
out p_msg_retreive VARCHAR(512),
out p_msg_remove VARCHAR(512))
specific test_adm
language SQL

BEGIN
DECLARE cmdline VARCHAR(1024);
DECLARE v_msg_retreival VARCHAR(512);
DECLARE v_rows_exp bigint;
DECLARE v_msg_removal VARCHAR(512);
DECLARE v_admin_cmd_str VARCHAR(512);
DECLARE result1 RESULT_SET_LOCATOR VARYING;

CALL sysproc.admin_cmd('export to /home/bkogan/testadm of del messages on server select * from test');

ASSOCIATE RESULT SET LOCATORS(result1) WITH PROCEDURE sysproc.ADMIN_CMD;
ALLOCATE rsCur CURSOR FOR RESULT SET result1;
FETCH rsCur INTO v_rows_exp, v_msg_retreival, v_msg_removal;
SET p_rows_exp = v_rows_exp;
SET p_msg_retreive = v_msg_retreival;
SET p_msg_remove = v_msg_removal;

END
@