OnDemand User Group
Support Forums => Other => Topic started by: GoTribe on January 07, 2020, 09:06:54 AM
-
Is there a way to identify the CMOD data tables when pulling all CMOD tables from SYSIBM.SYSTABLES ?
Here is the generic query I have to pull all the tables ....
SELECT *
--SELECT SUBSTR(DBNAME,1,8) AS DBNAME
-- , RTRIM(SUBSTR(CREATOR,1,5)) CONCAT '.' CONCAT
-- SUBSTR(NAME,1,20) AS TABLE
FROM SYSIBM.SYSTABLES
WHERE DBNAME LIKE 'ARS%' AND TYPE='T'
ORDER BY 1,2
-
Hey Mark.
You're going to love this article on IBM CMOD Tables in the CMOD wiki:
https://cmod.wiki/index.php?title=Content_Manager_OnDemand_Database_Tables#arsseg_-_IBM_CMOD_Segment_Table
-JD.