asked on

ADMIN_CMd

HI Experts,

>>-ADMIN_GET_MSGS--(--operation_id--)--------------------------><

operation_id
An input argument of type VARCHAR(139) that specifies the operation ID of the message file(s) produced by a data movement utility that was executed through the ADMIN_CMD procedure. The operation ID is generated by the ADMIN_CMD procedure.

My ADMIN_CMD is :
CALL SYSPROC.ADMIN_CMD('import from C:\testfield.csv of del MESSAGES ON SERVER insert into administrator.test_title');

But I dont have any idea where the messages go and also most importantly i need to know the operation_id to pass to ADMIN_GET_MSGS.

How the operation_id of utility can be determined?

CREATE PROCEDURE data_load()
LANGUAGE SQL
P1:BEGIN
CALL SYSPROC.ADMIN_CMD('import from C:\testfield.csv of del MESSAGES ON SERVER insert into administrator.test_title');
END P1
@

Open in new window

momi_sabag

you get that value back from the admin_cmd invocation

momi_sabag

look here http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.sample.doc/doc/java_jdbc/s-AdmCmdExport-java.htm

jsaravana

ASKER

Hi Experts,

Could yo please show me how to change the code for call call.
Currently I call using another SQL which has the below code:

call administrator.data_load();
@

The code for administrator.data_load() is in the first post.
Thanks in advance

momi_sabag

didn't my link help you?

jsaravana

ASKER

I was not able to effectively use the link.
I am new to Db2.. just 3 months.. :(
ADMIN_CMD accepts only one in parameter and no output parameter. So I was confused how to get the operation id.

Could you please help me solve this issue.

ASKER CERTIFIED SOLUTION

momi_sabag

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial