SELECT "SOWNER","SOWNERID","VNAME","MASTER_OWNER","MASTER","TABNUM","REFRESH_TIME","MASTER_FLAG","MASTER_OBJNUM","LOADERTIME","INSTSITE","LASTSUCCESS","FCMASKVEC","EJMASKVEC","REFSCN","SUB_HANDLE","CHANGE_VIEW"
FROM sys.exu81srt
WHERE sownerid = userenv('SCHEMAID')
SELECT "SOWNER"
, "SOWNERID"
, "VNAME"
, "MASTER_OWNER"
, "MASTER"
, "TABNUM"
, "REFRESH_TIME"
, "MASTER_FLAG"
, "MASTER_OBJNUM"
, "LOADERTIME"
, "INSTSITE"
, "LASTSUCCESS"
, "FCMASKVEC"
, "EJMASKVEC"
, "REFSCN"
, "SUB_HANDLE"
, "CHANGE_VIEW"
FROM SYS.EXU81SRT
WHERE SOWNERID = USERENV('SCHEMAID')
|
|
|