18 %macro mm_getpublictypes(
19 outds=work.mm_getpublictypes
23 create table &outds (publictype
char(64));
24 insert into &outds values (
'ACT');
25 insert into &outds values (
'Action');
26 insert into &outds values (
'Application');
27 insert into &outds values (
'ApplicationServer');
28 insert into &outds values (
'BurstDefinition');
29 insert into &outds values (
'Channel');
30 insert into &outds values (
'Condition');
31 insert into &outds values (
'ConditionActionSet');
32 insert into &outds values (
'ContentSubscriber');
33 insert into &outds values (
'Cube');
34 insert into &outds values (
'DataExploration');
35 insert into &outds values (
'DeployedFlow');
36 insert into &outds values (
'DeployedJob');
37 insert into &outds values (
'Document');
38 insert into &outds values (
'EventSubscriber');
39 insert into &outds values (
'ExternalFile');
40 insert into &outds values (
'FavoritesFolder');
41 insert into &outds values (
'Folder');
42 insert into &outds values (
'Folder.SecuredData');
43 insert into &outds values (
'GeneratedTransform');
44 insert into &outds values (
'InformationMap');
45 insert into &outds values (
'InformationMap.OLAP');
46 insert into &outds values (
'InformationMap.Relational');
47 insert into &outds values (
'JMSDestination (Java Messaging System message queue)');
48 insert into &outds values (
'Job');
49 insert into &outds values (
'Job.Cube');
50 insert into &outds values (
'Library');
51 insert into &outds values (
'MessageQueue');
52 insert into &outds values (
'MiningResults');
53 insert into &outds values (
'MQM.JMS (queue manager for Java Messaging Service)');
54 insert into &outds values (
'MQM.MSMQ (queue manager for MSMQ)');
55 insert into &outds values (
'MQM.Websphere (queue manager for WebSphere MQ)');
56 insert into &outds values (
'Note');
57 insert into &outds values (
'OLAPSchema');
58 insert into &outds values (
'Project');
59 insert into &outds values (
'Project.EG');
60 insert into &outds values (
'Project.AMOExcel');
61 insert into &outds values (
'Project.AMOPowerPoint');
62 insert into &outds values (
'Project.AMOWord');
63 insert into &outds values (
'Prompt');
64 insert into &outds values (
'PromptGroup');
65 insert into &outds values (
'Report');
66 insert into &outds values (
'Report.Component');
67 insert into &outds values (
'Report.Image');
68 insert into &outds values (
'Report.StoredProcess');
69 insert into &outds values (
'Role');
70 insert into &outds values (
'SearchFolder');
71 insert into &outds values (
'SecuredLibrary');
72 insert into &outds values (
'Server');
73 insert into &outds values (
'Service.SoapGenerated');
74 insert into &outds values (
'SharedDimension');
75 insert into &outds values (
'Spawner.Connect');
76 insert into &outds values (
'Spawner.IOM (object spawner)');
77 insert into &outds values (
'StoredProcess');
78 insert into &outds values (
'SubscriberGroup.Content');
79 insert into &outds values (
'SubscriberGroup.Event');
80 insert into &outds values (
'Table');
81 insert into &outds values (
'User');
82 insert into &outds values (
'UserGroup');