home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC Treasures, Inc.
/
pctreasures.mdf
/
WINDOWS
/
adabas
/
f_0001
/
env
/
showqcm.ins
< prev
next >
Wrap
Text File
|
1999-11-01
|
31KB
|
760 lines
/* @(#)SHWQCM.ins 10.01.00 1998-01-30
/**
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWCHECK'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWCHECKDOM'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWCOLUMN'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWCONNECTPARAM'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWCONSTRAINT'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWDBPROCEDURE'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWDOMAIN'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWDOMAINDEF'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWFOREIGNKEY'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWINDEX'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMAPCHARSET'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWPARAMDBPROC'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWPARAMTRIGGER'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWPRIMARYKEY'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWPRIVGRANTEDTO'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWPRIVON'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSERVERDB'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSYNONYM'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSYSDBA'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSYSDBAOF'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWTABLE'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWTABLEDEF'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWTERMCHARSET'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWTRIGGER'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWTRIGGERDEF'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWTRIGGEROF'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWUSER'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWUSERCONNECTED'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWUSERCURRENT'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWVERSION'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWVIEW'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORALL'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORCACHES'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORDBPROC'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORLOAD'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORLOCK'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORLOG'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORLONG'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORPAGES'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORROW'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORSERVERD'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORTRANS'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWMONITORVTRACE'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWOPTIMIZERSTAT'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATCONFIG'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATDEVSPACE'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATINDEX'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATINDEXOF'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATLOCK'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKCONFIG'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKTABLE'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKUSER'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATLOG'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATMAPCHARSET'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATSERVERDB'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATTABLE'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATTERMCHAR'
/*
DELETE sysdba.SYSQUERYLIB
WHERE author = 'DOMAIN' AND command_name = 'SHOWSTATUSER'
/**
COMMIT WORK
/**
DATALOAD TABLE sysdba.SYSQUERYLIB
AUTHOR 1-18 CHAR
COMMAND_NAME 22-39 CHAR
STRLENGTH 43-61 CHAR
CODETYPE 65-70 CHAR
INFILE *
/*
DOMAIN | SHOWCHECK | 288 | ASCII
DOMAIN | SHOWCHECKDOM | 165 | ASCII
DOMAIN | SHOWCOLUMN | 256 | ASCII
DOMAIN | SHOWCONNECTPARAM | 58 | ASCII
DOMAIN | SHOWCONSTRAINT | 201 | ASCII
DOMAIN | SHOWDBPROCEDURE | 321 | ASCII
DOMAIN | SHOWDOMAIN | 147 | ASCII
DOMAIN | SHOWDOMAINDEF | 159 | ASCII
DOMAIN | SHOWFOREIGNKEY | 407 | ASCII
DOMAIN | SHOWINDEX | 416 | ASCII
DOMAIN | SHOWMAPCHARSET | 169 | ASCII
DOMAIN | SHOWMONITORALL | 48 | ASCII
DOMAIN | SHOWMONITORCACHES | 55 | ASCII
DOMAIN | SHOWMONITORDBPROC | 55 | ASCII
DOMAIN | SHOWMONITORLOAD | 53 | ASCII
DOMAIN | SHOWMONITORLOCK | 53 | ASCII
DOMAIN | SHOWMONITORLOG | 52 | ASCII
DOMAIN | SHOWMONITORLONG | 53 | ASCII
DOMAIN | SHOWMONITORPAGES | 54 | ASCII
DOMAIN | SHOWMONITORROW | 52 | ASCII
DOMAIN | SHOWMONITORSERVERD | 57 | ASCII
DOMAIN | SHOWMONITORTRANS | 54 | ASCII
DOMAIN | SHOWMONITORVTRACE | 55 | ASCII
DOMAIN | SHOWOPTIMIZERSTAT | 265 | ASCII
DOMAIN | SHOWPARAMDBPROC | 274 | ASCII
DOMAIN | SHOWPARAMTRIGGER | 274 | ASCII
DOMAIN | SHOWPRIMARYKEY | 239 | ASCII
DOMAIN | SHOWPRIVGRANTEDTO | 375 | ASCII
DOMAIN | SHOWPRIVON | 334 | ASCII
DOMAIN | SHOWSERVERDB | 149 | ASCII
DOMAIN | SHOWSTATCONFIG | 200 | ASCII
DOMAIN | SHOWSTATDEVSPACE | 967 | ASCII
DOMAIN | SHOWSTATINDEX | 405 | ASCII
DOMAIN | SHOWSTATINDEXOF | 403 | ASCII
DOMAIN | SHOWSTATLOCK | 275 | ASCII
DOMAIN | SHOWSTATLOCKCONFIG | 50 | ASCII
DOMAIN | SHOWSTATLOCKTABLE | 417 | ASCII
DOMAIN | SHOWSTATLOCKUSER | 223 | ASCII
DOMAIN | SHOWSTATLOG | 1426 | ASCII
DOMAIN | SHOWSTATMAPCHARSET | 190 | ASCII
DOMAIN | SHOWSTATSERVERDB | 798 | ASCII
DOMAIN | SHOWSTATTABLE | 345 | ASCII
DOMAIN | SHOWSTATTERMCHAR | 162 | ASCII
DOMAIN | SHOWSTATUSER | 151 | ASCII
DOMAIN | SHOWSYNONYM | 226 | ASCII
DOMAIN | SHOWSYSDBA | 64 | ASCII
DOMAIN | SHOWSYSDBAOF | 124 | ASCII
DOMAIN | SHOWTABLE | 191 | ASCII
DOMAIN | SHOWTABLEDEF | 209 | ASCII
DOMAIN | SHOWTERMCHARSET | 174 | ASCII
DOMAIN | SHOWTRIGGER | 263 | ASCII
DOMAIN | SHOWTRIGGERDEF | 275 | ASCII
DOMAIN | SHOWTRIGGEROF | 263 | ASCII
DOMAIN | SHOWUSER | 161 | ASCII
DOMAIN | SHOWUSERCONNECTED | 55 | ASCII
DOMAIN | SHOWUSERCURRENT | 125 | ASCII
DOMAIN | SHOWVERSION | 49 | ASCII
DOMAIN | SHOWVIEW | 197 | ASCII
/*
IF $RC <> 0
THEN
/*
STOP 8
/*
COMMIT WORK
/**
LOAD LONG COLUMN SYSDBA.SYSQUERYLIB.COMMAND
INFILE '%DBROOT%\env\SHOWQCM.ino'
/*
IF $RC <> 0
THEN
/*
STOP 8
/*
COMMIT WORK
/**
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWCHECK'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWCHECKDOM'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWCOLUMN'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWCONNECTPARAM'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWCONSTRAINT'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWDBPROCEDURE'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWDOMAIN'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWDOMAINDEF'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWFOREIGNKEY'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWINDEX'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMAPCHARSET'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWPARAMDBPROC'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWPARAMTRIGGER'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWPRIMARYKEY'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWPRIVGRANTEDTO'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWPRIVON'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSERVERDB'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSYNONYM'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSYSDBA'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSYSDBAOF'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWTABLE'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWTABLEDEF'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWTERMCHARSET'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWTRIGGER'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWTRIGGERDEF'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWTRIGGEROF'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWUSER'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWUSERCONNECTED'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWUSERCURRENT'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWVERSION'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWVIEW'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORALL'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORCACHES'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORDBPROC'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLOAD'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLOCK'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLOG'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLONG'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORPAGES'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORROW'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORSERVERD'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORTRANS'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORVTRACE'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWOPTIMIZERSTAT'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATCONFIG'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATDEVSPACE'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATINDEX'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATINDEXOF'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCK'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKCONFIG'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKTABLE'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKUSER'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOG'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATMAPCHARSET'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATSERVERDB'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATTABLE'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATTERMCHAR'
/*
DELETE sysdba.SYSQUERY_GRANT
WHERE grantee = 'PUBLIC' AND author = 'DOMAIN' AND command_name = 'SHOWSTATUSER'
/**
COMMIT WORK
/**
DATALOAD TABLE sysdba.SYSQUERY_GRANT
GRANTEE 1-18 CHAR
AUTHOR 22-39 CHAR
COMMAND_NAME 43-60 CHAR
INFILE *
/*
PUBLIC | DOMAIN | SHOWCHECK
PUBLIC | DOMAIN | SHOWCHECKDOM
PUBLIC | DOMAIN | SHOWCOLUMN
PUBLIC | DOMAIN | SHOWCONNECTPARAM
PUBLIC | DOMAIN | SHOWCONSTRAINT
PUBLIC | DOMAIN | SHOWDBPROCEDURE
PUBLIC | DOMAIN | SHOWDOMAIN
PUBLIC | DOMAIN | SHOWDOMAINDEF
PUBLIC | DOMAIN | SHOWFOREIGNKEY
PUBLIC | DOMAIN | SHOWINDEX
PUBLIC | DOMAIN | SHOWMAPCHARSET
PUBLIC | DOMAIN | SHOWMONITORALL
PUBLIC | DOMAIN | SHOWMONITORCACHES
PUBLIC | DOMAIN | SHOWMONITORDBPROC
PUBLIC | DOMAIN | SHOWMONITORLOAD
PUBLIC | DOMAIN | SHOWMONITORLOCK
PUBLIC | DOMAIN | SHOWMONITORLOG
PUBLIC | DOMAIN | SHOWMONITORLONG
PUBLIC | DOMAIN | SHOWMONITORPAGES
PUBLIC | DOMAIN | SHOWMONITORROW
PUBLIC | DOMAIN | SHOWMONITORSERVERD
PUBLIC | DOMAIN | SHOWMONITORTRANS
PUBLIC | DOMAIN | SHOWMONITORVTRACE
PUBLIC | DOMAIN | SHOWOPTIMIZERSTAT
PUBLIC | DOMAIN | SHOWPARAMDBPROC
PUBLIC | DOMAIN | SHOWPARAMTRIGGER
PUBLIC | DOMAIN | SHOWPRIMARYKEY
PUBLIC | DOMAIN | SHOWPRIVGRANTEDTO
PUBLIC | DOMAIN | SHOWPRIVON
PUBLIC | DOMAIN | SHOWSERVERDB
PUBLIC | DOMAIN | SHOWSTATCONFIG
PUBLIC | DOMAIN | SHOWSTATDEVSPACE
PUBLIC | DOMAIN | SHOWSTATINDEX
PUBLIC | DOMAIN | SHOWSTATINDEXOF
PUBLIC | DOMAIN | SHOWSTATLOCK
PUBLIC | DOMAIN | SHOWSTATLOCKCONFIG
PUBLIC | DOMAIN | SHOWSTATLOCKTABLE
PUBLIC | DOMAIN | SHOWSTATLOCKUSER
PUBLIC | DOMAIN | SHOWSTATLOG
PUBLIC | DOMAIN | SHOWSTATMAPCHARSET
PUBLIC | DOMAIN | SHOWSTATSERVERDB
PUBLIC | DOMAIN | SHOWSTATTABLE
PUBLIC | DOMAIN | SHOWSTATTERMCHAR
PUBLIC | DOMAIN | SHOWSTATUSER
PUBLIC | DOMAIN | SHOWSYNONYM
PUBLIC | DOMAIN | SHOWSYSDBA
PUBLIC | DOMAIN | SHOWSYSDBAOF
PUBLIC | DOMAIN | SHOWTABLE
PUBLIC | DOMAIN | SHOWTABLEDEF
PUBLIC | DOMAIN | SHOWTERMCHARSET
PUBLIC | DOMAIN | SHOWTRIGGER
PUBLIC | DOMAIN | SHOWTRIGGERDEF
PUBLIC | DOMAIN | SHOWTRIGGEROF
PUBLIC | DOMAIN | SHOWUSER
PUBLIC | DOMAIN | SHOWUSERCONNECTED
PUBLIC | DOMAIN | SHOWUSERCURRENT
PUBLIC | DOMAIN | SHOWVERSION
PUBLIC | DOMAIN | SHOWVIEW
/*
IF $RC <> 0
THEN
/*
STOP 8
/*
COMMIT WORK
/**
/**
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWCHECK'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWCHECKDOM'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWCOLUMN'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWCONNECTPARAM'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWCONSTRAINT'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWDBPROCEDURE'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWDOMAIN'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWDOMAINDEF'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWFOREIGNKEY'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWINDEX'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMAPCHARSET'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWPARAMDBPROC'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWPARAMTRIGGER'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWPRIMARYKEY'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWPRIVGRANTEDTO'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWPRIVON'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSERVERDB'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSYNONYM'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSYSDBA'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSYSDBAOF'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWTABLE'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWTABLEDEF'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWTERMCHARSET'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWTRIGGER'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWTRIGGERDEF'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWTRIGGEROF'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWUSER'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWUSERCONNECTED'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWUSERCURRENT'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWVERSION'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWVIEW'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORALL'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORCACHES'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORDBPROC'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLOAD'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLOCK'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLOG'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORLONG'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORPAGES'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORROW'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORSERVERD'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORTRANS'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWMONITORVTRACE'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWOPTIMIZERSTAT'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATCONFIG'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATDEVSPACE'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATINDEX'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATINDEXOF'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCK'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKCONFIG'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKTABLE'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOCKUSER'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATLOG'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATMAPCHARSET'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATSERVERDB'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATTABLE'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATTERMCHAR'
/*
DELETE sysdba.SYSQUERY_OWN
WHERE grantee = 'DOMAIN' AND author = 'DOMAIN' AND command_name = 'SHOWSTATUSER'
/**
COMMIT WORK
/**
DATALOAD TABLE sysdba.SYSQUERY_OWN
GRANTEE 1-18 CHAR
AUTHOR 22-39 CHAR
COMMAND_NAME 43-60 CHAR
INFILE *
/*
DOMAIN | DOMAIN | SHOWCHECK
DOMAIN | DOMAIN | SHOWCHECKDOM
DOMAIN | DOMAIN | SHOWCOLUMN
DOMAIN | DOMAIN | SHOWCONNECTPARAM
DOMAIN | DOMAIN | SHOWCONSTRAINT
DOMAIN | DOMAIN | SHOWDBPROCEDURE
DOMAIN | DOMAIN | SHOWDOMAIN
DOMAIN | DOMAIN | SHOWDOMAINDEF
DOMAIN | DOMAIN | SHOWFOREIGNKEY
DOMAIN | DOMAIN | SHOWINDEX
DOMAIN | DOMAIN | SHOWMAPCHARSET
DOMAIN | DOMAIN | SHOWMONITORALL
DOMAIN | DOMAIN | SHOWMONITORCACHES
DOMAIN | DOMAIN | SHOWMONITORDBPROC
DOMAIN | DOMAIN | SHOWMONITORLOAD
DOMAIN | DOMAIN | SHOWMONITORLOCK
DOMAIN | DOMAIN | SHOWMONITORLOG
DOMAIN | DOMAIN | SHOWMONITORLONG
DOMAIN | DOMAIN | SHOWMONITORPAGES
DOMAIN | DOMAIN | SHOWMONITORROW
DOMAIN | DOMAIN | SHOWMONITORSERVERD
DOMAIN | DOMAIN | SHOWMONITORTRANS
DOMAIN | DOMAIN | SHOWMONITORVTRACE
DOMAIN | DOMAIN | SHOWOPTIMIZERSTAT
DOMAIN | DOMAIN | SHOWPARAMDBPROC
DOMAIN | DOMAIN | SHOWPARAMTRIGGER
DOMAIN | DOMAIN | SHOWPRIMARYKEY
DOMAIN | DOMAIN | SHOWPRIVGRANTEDTO
DOMAIN | DOMAIN | SHOWPRIVON
DOMAIN | DOMAIN | SHOWSERVERDB
DOMAIN | DOMAIN | SHOWSTATCONFIG
DOMAIN | DOMAIN | SHOWSTATDEVSPACE
DOMAIN | DOMAIN | SHOWSTATINDEX
DOMAIN | DOMAIN | SHOWSTATINDEXOF
DOMAIN | DOMAIN | SHOWSTATLOCK
DOMAIN | DOMAIN | SHOWSTATLOCKCONFIG
DOMAIN | DOMAIN | SHOWSTATLOCKTABLE
DOMAIN | DOMAIN | SHOWSTATLOCKUSER
DOMAIN | DOMAIN | SHOWSTATLOG
DOMAIN | DOMAIN | SHOWSTATMAPCHARSET
DOMAIN | DOMAIN | SHOWSTATSERVERDB
DOMAIN | DOMAIN | SHOWSTATTABLE
DOMAIN | DOMAIN | SHOWSTATTERMCHAR
DOMAIN | DOMAIN | SHOWSTATUSER
DOMAIN | DOMAIN | SHOWSYNONYM
DOMAIN | DOMAIN | SHOWSYSDBA
DOMAIN | DOMAIN | SHOWSYSDBAOF
DOMAIN | DOMAIN | SHOWTABLE
DOMAIN | DOMAIN | SHOWTABLEDEF
DOMAIN | DOMAIN | SHOWTERMCHARSET
DOMAIN | DOMAIN | SHOWTRIGGER
DOMAIN | DOMAIN | SHOWTRIGGERDEF
DOMAIN | DOMAIN | SHOWTRIGGEROF
DOMAIN | DOMAIN | SHOWUSER
DOMAIN | DOMAIN | SHOWUSERCONNECTED
DOMAIN | DOMAIN | SHOWUSERCURRENT
DOMAIN | DOMAIN | SHOWVERSION
DOMAIN | DOMAIN | SHOWVIEW
/*
IF $RC <> 0
THEN
/*
STOP 8
/**
COMMIT WORK
/**
RETURNCODE 0