ACPLOAD through Query in Websphere Commerce

If you want to run the acpload with query for my custom command. Run the following commands.

The below one is for the resourse group "AllSiteUserCmdResourceGroup".

INSERT INTO ACRESCGRY(ACRESCGRY_ID,RESCLASSNAME)

VALUES ((select coalesce(max(ACRESCGRY_ID),0)+1 from ACRESCGRY ),

'com.mycompany.commerce.context.commands.TestCmd');

INSERT INTO ACRESGPRES(ACRESGRP_ID,ACRESCGRY_ID)

VALUES ((select ACRESGRP_ID from ACRESGRP WHERE  GRPNAME = 'AllSiteUserCmdResourceGroup'),

(SELECT  ACRESCGRY_ID FROM ACRESCGRY WHERE

RESCLASSNAME = 'com.mycompany.commerce.context.commands.TestCmd'));