Monday, 6 March 2017

IDQ MetaQueries


Select * from MODELREPO.PO_FOLDER where PSF_DISCRIMINATOR='MPROOTFOLDERMARKER' and PSF_EXTERNID='U:ViEFdKwEEeaI4dJFXcyuVg'
1637 MPROOTFOLDERMARKER 13 U:ViEFdKwEEeaI4dJFXcyuVg 0 419451
 
Select * from MODELREPO.PO_MPPROJECT where PSM_OPID=348 and rownum<=200

Select * from MODELREPO.PO_FOLDER where POF_NAME='Project_Folder' and  rownum<=500    "MODELREPO".PO_LOCKEDOBJECT    419457

Select * from "MODELREPO".PO_LOCKEDOBJECT where PSL_OPID=1030  419518

Select * from "MODELREPO".PO_PRINCIPAL  where PSP_OPID=1108

Select * from "MODELREPO".PO_CHANGELISTobJECT WHERE PSC_rsiD=110355 AND cast(poc_oldpath as varchar(200)) ='Profiling_Project/Project_Folder/0RelationalDataObject/DUPLICATE_CUST_TABLE'

Select * from "MODELREPO".PO_COLLECTIONENTRY_5  where PSC_OPID=24074 110355

Select * from "MODELREPO".PO_MAPPING  where PSM_OPID=1158

Select * from "MODELREPO".PO_EXECUTIONENVIRONMENT where PSE_RSID=419550 PSE_OPID=1504

Select * from "MODELREPO".PO_CHARACTERISTI2  where PSC_CONTAINER=419550

Select * from "MODELREPO".PO_PORT where PSP_CONTAINER=419550 PSP_OPID='41420'

Select * from "MODELREPO".PO_MAPPLETINTERFACECARDIN where PSM_CONTAINER=419550


Select * from "MODELREPO".PO_OUTLINELINK where PSO_CONTAINER=419550

Select * from "MODELREPO".PO_DATAHANDLER where PSD_CONTAINER=419550

Select * from "MODELREPO".PO_INSTANCE where PSI_CONTAINER=419550


Select * from "MODELREPO".PO_INSTANCE where POI_NAME='Mapplet_Input'


Select * from "MODELREPO".PO_DATAINTERFACE where PSD_CONTAINER=419550

Select * from "MODELREPO".PO_TYPEDELEMENT  where PST_CONTAINER=419550

No comments:

Post a Comment