The macros provided to access the Advertise Output metadata tables include:
What are available ADS tables/views/procedures and their properties and procedures?
TWMX_Get_All_ADS
What are the available Score tables/procedures and their properties and procedures?
TWMX_Get_All_Scores
What are Profile tables/views/procedures profiling tables in a particular database?
TWMX_Get_Profiles_By_Database(subjectDatabase VARCHAR(128) CHARACTER SET UNICODE)
What are the Profile tables/views/procedures profiling a particular table?
TWMX_Get_Profiles_By_Table(subjectDatabase VARCHAR(128) CHARACTER SET UNICODE, subjectTable VARCHAR(128) CHARACTER SET UNICODE)
What are columns profiled by tables/views/procedures profiling a particular table?
TWMX_Get_Profiled_Columns(subjectDatabase VARCHAR(128) CHARACTER SET UNICODE, subjectTable VARCHAR(128) CHARACTER SET UNICODE)
What are the Model Variables of a particular ADS or Score by name?
WMX_Get_Variables(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)
What columns contributed to the Model Variables for this ADS or Score table/procedure?
TWMX_Get_Variable_Columns(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)
What are the literal parameters of a particular ADS by name?
TWMX_Get_ADS_Parameters(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)
What are the output columns contained in this Score table/procedure?
TWMX_Get_Score_Columns(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)
What was the analysis or chain of analyses that built this table/view/procedure?
TWMX_Get_Analyses(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)
What are the properties of the analyses that built this table/view/procedure?
TWMX_Get_Analysis_Properties(objectDatabase VARCHAR(128) CHARACTER SET UNICODE,objectName VARCHAR(128) CHARACTER SET UNICODE)
What are the parameters of a particular procedure by name?
TWMX_Get_Procedure_Parameters(objectDatabase VARCHAR(128) CHARACTER SET UNICODE,objectName VARCHAR(128) CHARACTER SET UNICODE)
What are the tables/views created by a particular procedure by name?
TWMX_Get_Procedure_Tables(objectDatabase VARCHAR(128) CHARACTER SET UNICODE, objectName VARCHAR(128) CHARACTER SET UNICODE)
What are all the advertised tables/views/procedures?
TWMX_Get_Advertised_Objects
What are the projects that select from a particular table to build a profile, ADS or score table?
TWMX_Get_Projects_Table_Input(inputDatabase CHAR(30), inputTable CHAR(30))
What are the profile, score and ADS analyses that select from a particular table?
TWMX_Get_Analyses_Table_Input(inputDatabase CHAR(30), inputTable CHAR(30))
What are the profile, score and ADS analyses that select from a particular column?
TWMX_Get_Analyses_Column_Input (inputDatabase CHAR(30), inputTable CHAR(30), inputColumn CHAR(30))
What project and analysis created the given table/view/procedure?
TWMX_Get_Creating_Analysis(objectDatabase CHAR(30), objectName CHAR(30))
The macros are used by executing them and supplying parameters if any, with or without parameter names, such as in:
EXEC "twm".TWMX_Get_Profiles_By_Table('twm_source','twm_customer');
-or-
EXEC "twm".TWMX_Get_Profiles_By_Database(subjectDatabase='twm_source');