VMS Help  —  SQLMOD72  Format
  (B)0MODULE  qqqqwqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqwqk   
              m> <module-name> qj m> DIALECT environment qqqj x   
   lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
   mqqwqqqqqqqqqqqqqqqqqqqqqqqwqqqq>qqqqqqqqqqqqqqqqqqqqqqqqqqk   
      mq> char-set-options qqqj                               x   
   lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
   mqq> LANGUAGE language-name qqwqqqqqqqqqqqqqqqqqqqqqqqqqwqk    
                                 m> CATALOG <catalog-name> j x    
    lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
    mqwqqqqqqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqwqqk  
      m> SCHEMA <schema-name> qj m> AUTHORIZATION <auth-id> j  x  
    lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
    mqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk   
      mqq> PRAGMA (module-pragma-list) qj mqq> module-language-options qqj x
    lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
    mqwqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqwq> procedure-clause qqwqqqqqq>
      mwq> declare-statement qqwqj     mqqqqqqqqqqq<qqqqqqqqqqj                
       mqqqqqqqqqqq<qqqqqqqqqqqj

  (B)0environment =         

  qqwqq> SQL99 qqqqqwq> 
    tqq> SQL92 qqqqqu   
    tqq> SQL89 qqqqqu   
    tqq> SQLV40 qqqqu   
    mqq> MIA qqqqqqqj   
                        

  (B)0char-set-options =                                       
                                                           
  qqwqqqqqqqqqqqqqqqq> qqqqqqqqqqqqqwqqqqqk                
    mqq> NAMES ARE names-char-set qqj     x                
  lqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqj                
  mwqwqqqqqqqqqqqqqqq> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwq> 
   x tqq> LITERAL CHARACTER SET support-char-set qqqqu x   
   x tqq> NATIONAL CHARACTER SET support-char-set qqqu x   
   x tqq> DEFAULT CHARACTER SET support-char-set qqqqu x   
   x tqq> IDENTIFIER CHARACTER SET names-char-set qqqu x   
   x mqq> DISPLAY CHARACTER SET names-char-set qqqqqqj x   
   mqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqj   
                                                        

  (B)0declare-statement =                         
                                              
  qwq> declare-alias-statement qqqqqqqwqqqq>  
   tq> declare-cursor-statement qqqqqqu       
   tq> declare-statement qqqqqqqqqqqqqu       
   tq> declare-table-statement qqqqqqqu       
   mq> declare-transaction-statement qj       
                                              

  (B)0module-pragma-list =          
                         
     qqqqqqqqqqqqwqqwq>  DEC_ADA  qqqqqqqqqqqqqqqwqqwqqqq>
                 x  tq>  GNAT_ADA  qqqqqqqqqqqqqqu  x
                 x  mq>  IDENT string-literal qqqj  x
                 mqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqj

  (B)0module-language-options =                                 
                                                            
  qwqwqqq> ALIAS <alias-name> qqqqqqqqqqqqqqqqqqqqqqqqwqwqq>
   x tqqq> CHARACTER LENGTH qwq> CHARACTERS qwqqqqqqqqu x   
   x x                       mq> OCTETS qqqqqj        x x   
   x tqqq> DEFAULT DATE FORMAT qqwqq> SQL99 qwqqqqqqqqu x   
   x x                           tqq> SQL92 qu        x x   
   x x                           mqq> VMS qqqj        x x
   x tqqq> KEYWORD RULES environment qqqqqqqqqqqqqqqqqu x   
   x tqqq> PARAMETER COLONS qqqqqqqqqqqqqqqqqqqqqqqqqqu x   
   x tqqq> QUOTING RULES environment qqqqqqqqqqqqqqqqqu x   
   x tqqq> RIGHTS qqwqq> INVOKER qqqwqqqqqqqqqqqqqqqqqu x   
   x x              mqq> RESTRICT qqj                 x x   
   x tqqq> VIEW UPDATE RULES environment qqqqqqqqqqqqqu x   
   x tqqq> QUIET COMMIT qwq> ON qqqwqqqqqqqqqqqqqqqqqqu x   
   x x                   mq> OFF qqj                  x x
   x mqqq> COMPOUND TRANSACTIONS  qwq> INTERNAL qwqqqqj x
   x                               mq> EXTERNAL qj      x
   mqqqqqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqj

  (B)0procedure-clause =                      
                                          
  qqwq> PROCEDURE <procedure-name> qqqqqqk
    x lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqj
    x mqwq> param-decl-list qqqqqwq> ; qqk
    x   mq> ( param-decl-list ) qj       x
    x lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqj
    x mqwq> simple-statement qqqwq> ; qwq>
    x   mq> compound-statement qj      x  
    mqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqj  

  (B)0param-decl-list =      
                         
  qwqq> param-decl qqqwq>
   mqqwqqqqq <qqqqqwqqj  
      mqqqq , <qqqqj     

  (B)0param-decl =                                                  
                                                                
  qwq> <parameter-name> qqk                                     
   x  lqqqqqqqqqqqqqqqqqqqj                                     
   x  mwq> data-type qqqqqwwqqqqqqqqqqqqqqq>qqqqqqqqqqqqqwqqwq> 
   x   tq> <domain-name> qumq> BY DESCRIPTOR wqqqqq>qqqqwj  x   
   x   mq> record-type qqqj                  mq> CHECK qj   x   
   tq> SQLCA qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
   tq> SQLCODE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
   tq> SQLSTATE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
   mqwqqqqqqqqqqqqqqqqqqqqqwqqwq> SQLDA qqqqqqqqqqqqqqqqqqqqu   
     mq> <parameter-name> qj  mq> SQLDA2 qqqqqqqqqqqqqqqqqqqj   
                                                                

  (B)0record-type =                                        
                                                       
  q> RECORD qqqk                                       
  lqqqqqqqqqqqqj                                       
  mww> <item-name> w> data-type qqwwqqw> END RECORD q> 
   xx              m> record-type jx  x                
   xmqqqqqqqqqwqqqqqqqwqqq<qqqqqqqqj  x                
   x          mqq , <qj               x                
   tq> FROM <path-name> qqqk          x                
   xlqqqqqqqqqqqqqqqqqqqqqqj          x                
   xmwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqu                
   x tq> FIXED qqqqqqqqqqqqqqqqqqqqqu x                
   x tq> NULL TERMINATED BYTES qqqqqu x                
   x mq> NULL TERMINATED CHARACTERS j x                
   mq> INDICATOR ARRAY OF qqqqqk      x                
     lqqqqqqqqqqqqqqqqqqqqqqqqqj      x                
     mqq> <array-length> qqqqqqk      x                
     lqqqqqqqqqqqqqqqqqqqqqqqqqj      x                
     mqq> exact-numeric-type qqqqqqqqqj                
                                                       

  (B)0exact-numeric-type =                                             
                                                                   
  qqqqqqwqq> SMALLINT qqqwqqqqwqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqwq>
        tqq> BIGINT qqqqqu    mq> ( <n> ) qj                       x 
        tqq> TINYINT qqqqj                                         x  
        tqq> INTEGER qqwqqqqqqqq qqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqwqu
        x              mq> ( <n> ) qj mq> IS qqwq> 4 qwq> BYTES qj x
        x                                      mq> 8 qj            x
        tqq> DECIMAL qqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqj
        mqq> NUMERIC qqj mq> ( qq> <n> qwqqqqqqqqqqwq> ) qj        
                                        mq> , <n> qj               

  (B)0language-name =    
                     
   qwq> ADA qqqqqwqq>
    tq> BASIC qqqu   
    tq> C qqqqqqqu   
    tq> COBOL qqqu   
    tq> FORTRAN qu   
    tq> PASCAL qqu   
    tq> PLI qqqqqu   
    mq> GENERAL qj   

  (B)0data-type =                                                   
                                                                
  qqwq> char-data-types qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> 
    tq> TINYINT qqqqqqqqqqqqqqwqqqqqwqqqqqqqqqqwqqqqqqqqqqqu    
    tq> SMALLINT qqqqqqqqqqqqqu     mq> (<n>) qj           x    
    tq> BIGINT qqqqqqqqqqqqqqqu                            x    
    tq> LIST OF BYTE VARYING qj                            x    
    tq> INTEGER qwqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqwqu    
    x            mq> (<n>) qj mq> IS qqwq> 4 qwq> BYTES qj x    
    x                                  mq> 8 qj            x    
    tq> DECIMAL qwwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqu    
    tq> NUMERIC qjmq> ( qq> <n> wqqqqqqqqqqwq> ) j         x    
    x                           mq> , <n> qj               x    
    tq> FLOAT qwqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu    
    x          mq> (<n>) qj                                x    
    tq> NUMBER qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqu
    x           mq> ( qwqq <p> qwqwqqqqqqqqqwq> ) qj       x
    x                  mq> * qqqj mq> <d> qqj              x
    tq> REAL qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu    
    tq> DOUBLE PRECISION qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu    
    mq> date-time-data-types qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    

  (B)0char-data-types =                                                      
                                                                         
  qwq> CHAR qqqqqqqqqqqqqwwqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwq>
   tq> CHARACTER qqqqqqqqumq> ( <n> ) qjmq> CHARACTER SET char-set-name qj x  
   tq> CHAR VARYING qqqqqu                                                 x  
   tq> CHARACTER VARYING j                                                 x  
   tq> VARCHAR qqw> ( <n> ) qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqu  
   tq> VARCHAR2 qj             mq> CHARACTER SET char-set-name qj          x
   tq> LONG VARCHAR  qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
   tq> NCHAR qqqqqqqqqqqqqqwqwqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu 
   tq> NATIONAL CHAR qqqqqqu mq> ( <n> ) qj                                x  
   tq> NATIONAL CHARACTER qj                                               x  
   tq> NCHAR VARYING qqqqqqqqqqqqqqwqwqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqu
   tq> NATIONAL CHAR VARYING qqqqqqu mq> ( <n> ) qj                        x  
   tq> NATIONAL CHARACTER VARYING qj                                       x  
   tq> RAW q> ( <n> ) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
   mq> LONG qwqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
             mq> RAW qj

  (B)0date-time-data-types =                        
                                                
  qqwq> DATE qwqqqqqqqqqqwqqqqqqqqqqqqqqqqqwqq> 
    x         tq> ANSI  qu                 x    
    x         mq> VMS qqqj                 x    
    tq> TIME qqq> frac qqqqqqqqqqqqqqqqqqqqu    
    tq> TIMESTAMP qq> frac qqqqqqqqqqqqqqqqu    
    mq> INTERVAL qqq> interval-qualifier qqj    
                                                

  (B)0frac =                            
                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
    mqq> ( <numeric-literal> ) qj   
                                    

  (B)0interval-qualifier =                                       
                                                             
  qqwq> YEAR qqq> prec qqwqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqwq> 
    x                    mq> TO MONTH qj                 x   
    tq> MONTH qq> prec qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    tq> DAY qqqq> prec qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    x                    mq> TO qwq> HOUR qqqqqqqqqqqqqqqu   
    x                            tq> MINUTE qqqqqqqqqqqqqu   
    x                            mq> SECOND q> frac qqqqqu   
    tq> HOUR qqq> prec qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    x                    mq> TO qwq> MINUTE qqqqqqqqqqqqqu   
    x                            mq> SECOND q> frac qqqqqu   
    tq> MINUTE q> prec qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    x                    mq> TO SECOND qqqqqq> frac qqqqqu   
    mq> SECOND q> seconds-prec qqqqqqqqqqqqqqqqqqqqqqqqqqj   
                                                             

  (B)0prec =                            
                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
    mqq> ( <numeric-literal> ) qj   
                                    

  (B)0seconds-prec =                                
                                                
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> 
    mq> ( <numeric-literal-1> qqqk         x    
       lqqqqqqqqqqqqqqqqqqqqqqqqqj         x    
       mwqqqqqqqqqqqqqqqqqqqqqqqqqqwq> ) qqj    
        m> , <numeric-literal-2> qqj            
                                                
Close Help