HCL Commerce ACP policy

MERGE

INTO

  ACRESCGRY acresgry

USING

  (

    SELECT ACRESCGRY_ID, RESCLASSNAME FROM (

  SELECT (SELECT MAX(ACRESCGRY_ID)+1 FROM acrescgry) ACRESCGRY_ID, 'com.XYX.commerce.usermanagement.commands.XYZProfileTypeCmd' RESCLASSNAME FROM SYSIBM.SYSDUMMY1 

  )

  ) t

ON

  (

    acresgry.RESCLASSNAME = t.RESCLASSNAME

  )

WHEN MATCHED THEN

  UPDATE SET

  acresgry.RESCLASSNAME = t.RESCLASSNAME

WHEN NOT MATCHED THEN

  INSERT (acresgry.ACRESCGRY_ID, acresgry.RESCLASSNAME)

  VALUES (t.ACRESCGRY_ID, t.RESCLASSNAME)

;

MERGE

INTO

  ACRESACT acresact

USING

  (

    SELECT ACRESCGRY_ID, ACACTION_ID FROM (

  SELECT (SELECT ACRESCGRY_ID FROM acrescgry where RESCLASSNAME like 'com.XYX.commerce.usermanagement.commands.XYZProfileTypeCmd') ACRESCGRY_ID, (SELECT ACACTION_ID FROM acaction where action = 'Execute') ACACTION_ID FROM SYSIBM.SYSDUMMY1 

  )

  ) t

ON

  (

    acresact.ACRESCGRY_ID = t.ACRESCGRY_ID and acresact.ACACTION_ID = t.ACACTION_ID 

  )

WHEN NOT MATCHED THEN

  INSERT (acresact.ACRESCGRY_ID, acresact.ACACTION_ID)

  VALUES (t.ACRESCGRY_ID, t.ACACTION_ID)

;

MERGE

INTO

  ACRESGPRES acresgpres

USING

  (

    SELECT ACRESGRP_ID, ACRESCGRY_ID FROM (

  SELECT (SELECT ACRESGRP_ID FROM ACRESGRP where GRPNAME = 'RegisteredUserCmdResourceGroup') ACRESGRP_ID , (SELECT ACRESCGRY_ID FROM acrescgry where RESCLASSNAME like 'com.XYX.commerce.usermanagement.commands.XYZProfileTypeCmd') ACRESCGRY_ID  FROM SYSIBM.SYSDUMMY1 

  )

  ) t

ON

  (

    acresgpres.ACRESGRP_ID = t.ACRESGRP_ID and acresgpres.ACRESCGRY_ID = t.ACRESCGRY_ID 

  )

WHEN NOT MATCHED THEN

  INSERT (acresgpres.ACRESGRP_ID , acresgpres.ACRESCGRY_ID)

  VALUES (t.ACRESGRP_ID,  t.ACRESCGRY_ID )

;