Page tree
Skip to end of metadata
Go to start of metadata
Purpose of Query

This query will help to retrieve the contents of the modules based on the module name.

Applicable CAST Version
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(?)
Microsoft SQL Server(?)
CSS2(tick)
CSS1(tick)
Query for CSS

Query gets the list of objects by module name.

Run the below query in KB:

SELECT ps.module_name, 
       ps.module_id, 
       pso.object_id 
FROM   <your_local>.pmc_subset_objects pso 
       JOIN (SELECT ps.subset_id   AS MODULE_ID, 
                    pm.object_name AS MODULE_NAME 
             FROM   (SELECT pm.object_id, 
                            pm.object_name 
                     FROM   <your_mngt>cms_portf_module pm 
                     WHERE  1 = 1 
                     and pm.Object_Name in ([list of module names]) -- comment out to scan all defined modules 
                    ) pm 
                    JOIN <your_local>.pmc_subsets ps 
                      ON ps.subset_name LIKE 'CMS_MOD__' 
                                             || pm.object_id 
                                             || '_Preparation2') ps 
         ON pso.subset_id = ps.module_id 
Query result example

 List of objects in a module

 

Notes/comments
 
Related Pages
 

 

 

  • No labels