Documentum : Execution of DQL script via IDQL32, API script via IAPI32

Hello,

Just a post concerning the execution of DQL script via IDQL32, and API script via IAPI32.

 
DQL script via IDQL32
Here an example on exportation of unused ACLs in CSV file:

• Creation of DQL script : script_dql_export_acl_not_used.dql in order to export the unused ACLs in a CSV file named script_dql_export_acl_not_used_result.csv:
  view source

  print?

  01	SELECT object_name from dm_acl WHERE object_name like 'dm_45%' and owner_name not like 'dm%' and r_object_id not in

  02

  (

  03	Select r_object_id  from dm_acl a, dm_sysobject(ALL) s

  04	where a.object_name = s.acl_name  and a.object_name like 'dm_45%'

  05	group by a.object_name, a.r_object_id

  06	HAVING count(s.object_name)>0

  07

  )

  08	and object_name not in (select u.acl_name from dm_user u)

  09	ENABLE (RETURN_TOP 1000000)

  10

  go

  11

  exit

• Execution of script on content server via idql32 Tools. This script requires several parameters.
  view source

  print?

  1	C:\Documentum\product\6.5\bin> idql32 mydocbase -Umy_super_user   -Pxxxxx  -RQ:\HUO\script_dql_export_acl_not_used.dql  > Q:\HUO\script_dql_export_acl_not_used_result.csv

  Note: Put the password clause in double quote if it contains special characters (& | …) -> “-Pxxxxx”.

 
 
API script via IAPI32
Here an example deletion of unused ACLs:

• Creation of API script : script_delete_acl_123.api in order to delete the unused ACLs:
  view source

  print?

  01	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000050c'

  02	destroy,c,l

  03	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000053c'

  04	destroy,c,l

  05	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000050f'

  06	destroy,c,l

  07	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx0000535'

  08	destroy,c,l

  09	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx0000536'

  10	destroy,c,l

  11	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx0000537'

  12	destroy,c,l

  13	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx0000538'

  14	destroy,c,l

  15	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000053d'

  16	destroy,c,l

  17	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000053e'

  18	destroy,c,l

  19	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000053f'

  20	destroy,c,l

  21	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx0000540'

  22	destroy,c,l

  23	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx0000539'

  24	destroy,c,l

  25	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000050e'

  26	destroy,c,l

  27	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000053a'

  28	destroy,c,l

  29	retrieve,c,dm_acl where object_name = 'dm_450xxxxxx000053b'

  30	destroy,c,l

• Execution of script on content server via iapi32 Tools.

  This script requires several parameters.

  view source

  print?

  1	C:\Documentum\product\6.5\bin>iapi32 mydocbase -Umy_super_user -Pxxxxxx -RQ:\HUO\script_delete_acl_123.api -lQ:\HUO\script_delete_acl_123.log

  Note: Put the password clause in double quote if it contains special characters (& | …) -> “-Pxxxxx”.

That’s all!!!

Huseyin OZVEREN