Library /sys$common/syshlp/SQL$HELP72.HLB  —  SHOW  Format
  (B)0SHOW   qqwq>  show-params-1 qqqqqqqqqqqqqqwqq>   
           tq>  show-params-2 qqqqqqqqqqqqqqu      
           mq>  show-session-information qqqj      

  (B)0show-params-1 =                         
                                          
  qqqqwq> show-aliases qqqqqqqqqqqqqqwqqq>
      tq> show-cache qqqqqqqqqqqqqqqqu    
      tq> show-catalogs qqqqqqqqqqqqqu    
      tq> CHARACTER SETS qqqqqqqqqqqqu    
      tq> show-collating-sequence qqqu    
      tq> show-connections qqqqqqqqqqu    
      tq> CURSORS qqqqqqqqqqqqqqqqqqqu    
      tq> show-databases qqqqqqqqqqqqu    
      tq> DISPLAY qqqqqqqqqqqqqqqqqqqu
      tq> show-domains qqqqqqqqqqqqqqu    
      tq> FLAGS qqqqqqqqqqqqqqqqqqqqqu    
      tq> show-functions qqqqqqqqqqqqu    
      tq> show-indexes qqqqqqqqqqqqqqu    
      tq> show-journals qqqqqqqqqqqqqu    
      tq> show-modules qqqqqqqqqqqqqqu    
      mq> show-outlines qqqqqqqqqqqqqj    

  (B)0show-params-2 =                     

  qqwq> show-profiles qqqqqqqqqqqqqwq>
    tq> show-privileges qqqqqqqqqqqu
    tq> show-procedures qqqqqqqqqqqu 
    tq> QUERY CONFIRM qqqqqqqqqqqqqu
    tq> QUERY LIMIT qqqqqqqqqqqqqqqu  
    tq> show-roles qqqqqqqqqqqqqqqqu
    tq> show-schemas qqqqqqqqqqqqqqu  
    tq> show-sequences qqqqqqqqqqqqu
    tq> show-storage-areas qqqqqqqqu  
    tq> show-storage-maps qqqqqqqqqu  
    tq> show-synonyms qqqqqqqqqqqqqu
    tq> show-tables qqqqqqqqqqqqqqqu  
    tq> show-triggers qqqqqqqqqqqqqu  
    tq> show-users qqqqqqqqqqqqqqqqu
    tq> show-users-granting qqqqqqqu  
    tq> show-users-with qqqqqqqqqqqu  
    tq> VARIABLES qqqqqqqqqqqqqqqqqu  
    mq> show-views qqqqqqqqqqqqqqqqj  

  (B)0show-aliases =                    
                                        
  qq> ALIASES  qqwqqqqqqqqqqqqqqqqwqq>  
                 tqwq> <alias> qwqu     
                 x mqqqqq , <qqqj x     
                 mqqq> * qqqqqqqqqj     
                                        

  (B)0show-cache =                            
                                          
  qqq> CACHE qwqqqqqqqqqqqqqqqqqqqqqwqq>  
              mqqq> <name-list> qqqqj     

  (B)0show-catalogs =                    
                                     
  qqq> CATALOGS qqwqqqqqqqqqqqqqqqqqwq>
                  mq> name-list qqqqj
                                     

  (B)0show-collating-sequence =                        
                                                   
  qqq> COLLATING SEQUENCE qqwqqqqqqqqqqqqqqqwqq>   
                            mq> name-list qqj      
                                                   

  (B)0show-connections =                              
                                                  
  qqq> CONNECTIONS qwqwqqqqqqqqqqqqqqqqqqqqqwqwq> 
                    x tq> DEFAULT qqqqqqqqqqu x   
                    x tq> CURRENT qqqqqqqqqqu x   
                    x mq> <connection-name> j x   
                    mqqqqqqqqqqqqq , <qqqqqqqqj   
                                                  

  (B)0show-databases =                       
                                         
  qq> DATABASES qqwqqqqqqqqqqqqqqqqwqq>  
                  tqwq> <alias> qwqu     
                  x mqqqqq , <qqqj x     
                  mqqq> * qqqqqqqqqj     
                                         

  (B)0show-domains =                                  
                                                  
  qwqqqqqqqqqqqwq> DOMAINS qwqqqqqqqqqqqqqqqwqq>  
   tq> SYSTEM qu            mq> name-list qqj
   mq> ALL qqqqj             
                          

  (B)0show-functions =                                                     
                                                                       
  qwqqqqqqqqqqqqwq> FUNCTIONS wqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqwq>
   tq> SYSTEM  qu             m> ( wwq> COMMENT qqqqqww> ) qj mq> name-list  qj
   mq> ALL qqqqqj                  xtq> ID qqqqqqqqqqux                 
                                   xtq> LANGUAGE qqqqux                
                                   xtq> MODULE qqqqqqux                
                                   xtq> OWNER qqqqqqqux                
                                   xtq> PARAMETER qqqux                
                                   xmq> SOURCE qqqqqqjx                
                                   mqqqqqqq , <qqqqqqqj                
                                                                       

  (B)0show-indexes =                                                     
                                                                     
  qwqqqqqqqqqqqwwq> INDEXES qwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
   tq> SYSTEM qumq> INDICES qj tq> ON qw> <table-name> qqqqqqqqqqqqqqqqu
   mq> ALL qqqqj               x       mqqqqq , <qqqqqqqqqqqqqqqqqqqqqqu
                               tq> name-list qqqqqqqqqqqqqqqqqqqqqqqqqqu
                               mq> ( qwq> CARDINALITY  w> name-list ) qj
                                      tqq PARTITIONS   x               
                                      mqqqqqqq , qqqqqqj           

  (B)0show-journals                         
                                        
  qqq> JOURNALS qwqqqqqqqqqqqqqqqqwqq>  
                 mqq> name-list qqj     
                                        

  (B)0show-modules =                                      
                                                                  
  qwqqqqqqqqqqqqwq> MODULES  qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqwq>
   tq> SYSTEM  qu             m> ( ww> COMMENT qqqqww> ) qqj mq> name-list  qj
   mq> ALL qqqqqj                  xt> FUNCTIONS qqux                 
                                   xt> ID qqqqqqqqqux                 
                                   xt> NAME qqqqqqqux               
                                   xx> OWNER qqqqqqux               
                                   xt> PROCEDURES qux               
                                   xm> VARIABLES qqjx               
                                   mqqqqqq , <qqqqqqj               
                                      
                             

  (B)0show-outlines                        
                                       
  qqq> OUTLINES qwqqqqqqqqqqqqqqqwqq>  
                 mq> name-list qqj     
                

  (B)0show-profiles =

  qq> PROFILES qwqqqqqqqqqqqqqqqwqq>  
                mq> name-list qqj     
                                      

  (B)0name-list =                           
                                        
  qwqwqqqqqqqqqqqqqqqwwq * qqqqqqqqqqqqqqwqwq> 
   x mq> <alias> . qqjmq> <object-name> qj x   
   x                                       x
   mqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqj
                                         

  (B)0show-privileges =                                                    
                                                                       
  qqwq> PROTECTION ON qwwq> TABLES qqqqwq> <table-name> wqqqqqqqqqqwq> 
    x                  xx              mqqqqqqq , <qqqqqj          x    
    mq> PRIVILEGES ON qjtq> VIEWS qqqqqwq> <view-name> qwqqqqqqqqqqu   
                        x              mqqqqqqq , <qqqqqj          x    
                        tq> COLUMNS qqqwq> <column-name> qwqqqqqqqqu   
                        x              mqqqqqqq , <qqqqqqqj        x    
                        tq> DATABASE qqwq> <alias> wqqqqqqqqqqqqqqqu    
                        x              mqqqq , <qqqj               x   
                        tq> FUNCTION qqwq> <function-name> qqqqwqqqu   
                        x              mqqqqqqqqqqq , <qqqqqqqqj   x   
                        tq> PROCEDURE qwq> <procedure-name> qqqqqwqu   
                        x              mqqqqqqqqqqq , <qqqqqqqqqqj x   
                        tq> MODULE qqqqwq> <module-name> wqqqqqqqqqu   
                        x              mqqqqqqq , <qqqqqqj         x   
                        mq> SEQUENCE qqwq> <sequence-name> qwqqqqqqj   
                                       mqqqqqqqqqqqq , <qqqqj

  (B)0show-procedures =                                               
                                                                                 
   qwqqqqqqqqqqqwqq> PROCEDURES wqqqqqqqqqqqqqqqqqqqqqqqqqqwwqqqqqqqqqqqqqqqwq>  
    tq> SYSTEM qu               m> ( ww> COMMENT qqqqww> ) jmq> name-list qqj    
    mq> ALL qqqqj                    xt> ID qqqqqqqqqux                          
                                     xt> LANGUAGE qqqux                          
                                     xt> MODULE qqqqqux                          
                                     xt> OWNER qqqqqqux                          
                                     xt> PARAMETER qqux                          
                                     xm> SOURCE qqqqqjx                          
                                     mqqqqqq , <qqqqqqj                          

                                                                                 

  (B)0show-roles =

  qqq> ROLES qwqqqqqqqqqqqqqqwq>  
              mq> name-list qj   
                                  

  (B)0show-schemas =                    
                                    
  qq> SCHEMAS qwqqqqqqqqqqqqqqqwq>
               mq> name-list qqj
              

  (B)0show-sequences=     

  qqq> SEQUENCES qwqqqqqqqqqqqqqqqwq>  
                  mq> name-list qqj    
                                       

  (B)0show-storage-areas =                                             
                                                                   
  qq> STORAGE AREAS qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>  
                      tq> name-list qqqqqqqqqqqqqqqqqqqqqqqqqqu    
                      mq> ( ww> USAGE qqqqqqqww> ) name-list qj    
                            xm> ATTRIBUTES qqjx                    
                            mqqqqq , <qqqqqqqqj                    

  (B)0show-storage-maps =                                            
                                                                 
  qwqqqqqqqqqqqwq> STORAGE MAPS qwqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqwq>
   tq> SYSTEM qu                 tq> name-list qqqj                    x
   mq> ALL qqqqj                 mq> ( PARTITIONS q> ) q> name-list  qqj
                                                                 

  (B)0show-synonyms =

  qqq> SYNONYMS qwqqqqqqqqqqqqqqqwqq>
                 mq> name-list qqj

  (B)0show-tables =                                                          
                                                                         
  qwqqqqqqqqqqqwq> TABLES qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
   tq> SYSTEM qu           tq> name-list qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
   mq> ALL qqqqj           mq> ( qwwq> COLUMNS qqqqqwwq> ) name-list qqj  
                                  xtq> COMMENT qqqqqux                    
                                  xtq> CONSTRAINTS qux                    
                                  xtq> INDEXES qqqqqux                   
                                  xtq> STORAGE MAPS ux                   
                                  xmq> TRIGGERS qqqqjx                   
                                  mqqqqqqqq , <qqqqqqj                   
                                                                          

  (B)0show-triggers =                                  
                                                         
  qwqqqqqqqqqqqwq> TRIGGERS qwqqqqqqqqqqqqqqqwqq>        
   tq> SYSTEM qu             mq> name-list qqj
   mq> ALL qqqqj           
                                                         
                                                         

  (B)0show-users =    

  qqq> USERS qqwqqqqqqqqqqqqqqqwqq>  
               mq> name-list qqj  
                                   

  (B)0show-users-granting =                                                     
                                                                            
  qq> USERS GRANTING qqqk                                                   
  lqqqqqqqqqqqqqqqqqqqqqj                                                   
  mw> db-privs-ansi  qqqqqq> ON DATABASE qwq> <alias> wqqqqqqqqqqqqqqqqqwk 
   x                                      mqqqq , <qqqj                 xx 
   t> table-privs-ansi qqqq> ON TABLE  qwq> <table-name> wqqqqqqqqqqqqqqux 
   x                                    mqqqqqqq , <qqqqqj              xx 
   t> column-privs-ansi qqq> ON COLUMN qwq> <column-name> qqwqqqqqqqqqqqux 
   x                                    mqqqqqqq , <qqqqqqqqj           xx 
   t> ext-routine-privs-ansi wq> ON FUNCTION w> <function-name qqqqqwqqqux 
   x                         x               mqqqqqqqqq , <qqqqqqqqqj   xx 
   x                         mqq> ON PROCEDURE w> <procedure-name qqqqqwux 
   x                                           mqqqqqqqqq , <qqqqqqqqqqjxx 
   t> module-privs-ansi qqq> ON MODULE qqwq> <module-name> qqwqqqqqqqqqqux 
   x                                     mqqqqq , <qqqqqqqqqqj          xx 
   m> sequence-privs-ansi qq> ON SEQUENCE qw> <sequence-name> qwqqqqqqqqjx
                                           mqqq , <qqqqqqqqqqqqj         x
     lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
     mqqq> TO qwq> identifier-ansi-style qqqwqqq>                           
               mq> PUBLIC qqqqqqqqqqqqqqqqqqj                              

  (B)0show-views =                                                
                                                              
  qqwqqqqqqqqqqqwq> VIEWS qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk 
    tq> SYSTEM qu          mq> ( qwqwq> COLUMNS qwqwq> ) qj x 
    mq> ALL qqqqj                 x tq> COMMENT qu x        x 
                                  x mq> SOURCE qqj x        x 
                                  mqqqqqq , <qqqqqqj        x 
   lqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
   mqwqqqqqqqqqqqqqqqwqqqqqqqqqqqqq>                          
     mq> name-list qqj                                        
                                                              

  (B)0db-privs-ansi =                     
                                      
  qqqqwqqqwqwq> SELECT qqqqqwqwqqqqwq>
      x   x tq> INSERT qqqqqu x    x  
      x   x tq> OPERATOR qqqu x    x  
      x   x tq> DELETE qqqqqu x    x  
      x   x tq> CREATE qqqqqu x    x  
      x   x tq> ALTER qqqqqqu x    x  
      x   x tq> DROP qqqqqqqu x    x  
      x   x tq> DBCTRL qqqqqu x    x  
      x   x tq> DBADM qqqqqqu x    x  
      x   x tq> SHOW qqqqqqqu x    x  
      x   x tq> REFERENCES qu x    x  
      x   x tq> UPDATE qqqqqu x    x  
      x   x tq> SECURITY qqqu x    x  
      x   x mq> DISTRIBTRAN j x    x  
      x   mqqqqqqq , <qqqqqqqqj    x  
      mqqqqqqq> ALL PRIVILEGES qqqqj  

  (B)0table-privs-ansi =                                     
                                                         
  qwqqwqwq> SELECT qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqwq>
   x  x tq> INSERT qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> OPERATOR qqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> DELETE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> CREATE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> ALTER qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> DROP qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> DBCTRL qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> SHOW qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x tq> REFERENCES wqqqqqqqqqqqqqqqqqqqqqqqqqqu x x  
   x  x x              m> ( w> <column-name> w> ) u x x  
   x  x x                   mqqqqq , <qqqqqqqj    x x x  
   x  x mq> UPDATE wqqqqqqqqqqqqqqqqqqqqqq  qqqqqqu x x  
   x  x            m> ( w> <column-name> qwqqq> ) j x x  
   x  x                 mqqqqq , <qqqqqqqqj         x x  
   x  mqqqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqqqj x  
   mqqqqqq> ALL PRIVILEGES qqqqqqqqqqqqqqqqqqqqqqqqqqqj  

  (B)0column-privs-ansi =             
                                  
  qqqwqwqwq> UPDATE qqqqqwqwqqwqq>
     x x mq> REFERENCES qj x  x   
     x mqqqqqqq , <qqqqqqqqj  x   
     mqqqqq> ALL PRIVILEGES qqj   

  (B)0ext-routine-privs-ansi =                               
                                                         
  qwqqwqwq> ALTER qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqqwqq>
   x  x tq> DBCTRL qqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x tq> DROP qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x tq> EXECUTE qqqqqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x tq> REFERENCES qqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x mq> SHOW qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x  x   
   x  mqqqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqj  x   
   mqqqqqq> ALL PRIVILEGES qqqqqqqqqqqqqqqqqqqqqqqqqqj 

  (B)0module-privs-ansi =                                    
                                                         
  qwqqwqwq> ALTER qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqqwqq>
   x  x tq> DBCTRL qqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x tq> DROP qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x tq> EXECUTE qqqqqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x tq> REFERENCES qqqqqqqqqqqqqqqqqqqqqqqqqu x  x   
   x  x mq> SHOW qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x  x   
   x  mqqqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqj  x   
   mqqqqqq> ALL PRIVILEGES qqqqqqqqqqqqqqqqqqqqqqqqqqj 

  (B)0identifier-ansi-style =            
                                     
  qqqqqq> user-identifier qqqqqqqq>  
                                     

  (B)0show-users-with =                                                         
                                                                            
  qq> USERS WITH qqqqqqqk                                                   
  lqqqqqqqqqqqqqqqqqqqqqj                                                   
  mw> db-privs-ansi  qqqqqqq> ON DATABASE qwq> <alias> wqqqqqqqqqqqqqqqqqwk  
   x                                       mqqqq , <qqqj                 xx 
   t> table-privs-ansi qqqqq> ON TABLE  qwq> <table-name> wqqqqqqqqqqqqqqux 
   x                                     mqqqqqqq , <qqqqqj              xx 
   t> column-privs-ansi qqqq> ON COLUMN qwq> <column-name> qwqqqqqqqqqqqqux 
   x                                     mqqqqqqq , <qqqqqqqj            xx 
   t> ext-routine-privs-ansi qw> ON FUNCTION qw> <function-name> qqqqwqqqux 
   x                          x               mqqqqqqqqq , <qqqqqqqqqj   xx 
   x                          mq> ON PROCEDURE qw> <procedure-name> qqqqwux 
   x                                            mqqqqqqqqq , <qqqqqqqqqqjxx 
   t> module-privs-ansi qqqq> ON MODULE qqwq> <module-name> wqqqqqqqqqqqqux 
   x                                      mqqqqq , <qqqqqqqqj            xx 
   m> sequence-privs-ansi qq> ON SEQUENCE qwq> <sequence-name> qwqqqqqqqqjx
                                           mqqqq , <qqqqqqqqqqqqj         x
     lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
     mqq> FROM wq> identifier-ansi-style qqqwqqq>                            
               mq> PUBLIC qqqqqqqqqqqqqqqqqqj                               

  (B)0sequence-privs-ansi =

  qwqwqwq> ALTER qqqqqwqwqwqq> 
   x x tq> DBCTRL qqqqu x x
   x x tq> DROP qqqqqqu x x
   x x mq> SELECT qqqqj x x
   x mqqqqqqq , <qqqqqqqj x
   mqq> ALL PRIVILEGES qqqj

  (B)0show-session-information =         
                                     
  qwq> ANSI DATE MODE qqqqqqqqqqqwq> 
   tq> ANSI IDENTIFIERS MODE qqqqu  
   tq> ANSI QUOTING MODE qqqqqqqqu  
   tq> AUTOMATIC TRANSLATION qqqqu
   tq> CONSTRAINT MODE qqqqqqqqqqu  
   tq> CONTINUATION CHARACTER qqqu
   tq> CURRENCY SIGN qqqqqqqqqqqqu  
   tq> DATE FORMAT qqqqqqqqqqqqqqu   
   tq> DICTIONARY qqqqqqqqqqqqqqqu   
   tq> DIGIT SEPARATOR qqqqqqqqqqu   
   tq> DISPLAY qqqqqqqqqqqqqqqqqqu
   tq> EXECUTION MODE qqqqqqqqqqqu   
   tq> FLAGGER MODE qqqqqqqqqqqqqu   
   tq> HOLD CURSORS MODE qqqqqqqqu
   tq> LANGUAGE qqqqqqqqqqqqqqqqqu   
   tq> RADIX POINT qqqqqqqqqqqqqqu   
   tq> SQLCA qqqqqqqqqqqqqqqqqqqqu   
   tq> TRANSACTION qqqqqqqqqqqqqqu   
   tq> VERSIONS qqqqqqqqqqqqqqqqqu   
   mq> WARNING MODE qqqqqqqqqqqqqj   
Close Help