Library /sys$common/syshlp/SQL$HELP72.HLB  —  CREATE  DATABASE  Format
  (B)0 CREATE DATABASE qwqqqqqqqqqqqqqqqqqqwk                            
                    mq> ALIAS <alias> qjx                            
  lqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqj                            
  mwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk 
   mwwq> root-file-params-1 qqqwwjmwwq> storage-area-params-1 qwwj x 
    xtq> root-file-params-2 qqqux  xmq> storage-area-params-2 qjx  x 
    xtq> root-file-params-3 qqqux  mqqqqqqqqqqqqqq <qqqqqqqqqqqqj  x 
    xmq> root-file-params-4 qqqjx                                  x 
    mqqqqqqqqqqq <qqqqqqqqqqqqqqj                                  x 
  lqqqqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
  mwqqqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqq>       
   mq> character-sets qqj  mwq> database-element qwj                 
                            mqqqqqqqq <qqqqqqqqqqqj                  
                                                                     

  (B)0root-file-params-1 =                                        
                                                              
  qwq> FILENAME <db-attach-spec> qwwqqqqqqqqqqqqqqqqqqqqqqwwq>
   tq> PATHNAME <path-name>   qqqqjmq> literal-user-auth qjx  
   tq> attach-options qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
   tq> COLLATING SEQUENCE <collation-name> qqqqqk          x  
   x  lqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqj          x  
   x  mwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqk          x  
   x   mq> COMMENT IS qqqwq> '<string>' qqwj    x          x  
   x                     mqqqqqqq / <qqqqqj     x          x  
   x  lqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqj          x  
   x  mqq> <ncs-name> qwqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqu  
   x                   mq> FROM <library-name> j           x  
   tq> NUMBER OF USERS qqqqqqq> <number-users> qqqqqqqqqqqqu  
   tq> NUMBER OF BUFFERS qqqqq> <number-buffers> qqqqqqqqqqu  
   tq> NUMBER OF CLUSTER NODES qqqq> <number-nodes> qqk    x  
   x     lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    x
   x     mwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqu
   x      m> ( qwq> SINGLE qqqwq> INSTANCE qq> ) qqj       x
   x            mq> MULTIPLE qj                            x
   tq> NUMBER OF RECOVERY BUFFERS q> <number-buffers> qqqqqu  
   mq> BUFFER SIZE IS q> <buffer-blocks> qq> BLOCKS qqqqqqqj  

  (B)0 db-attach-spec =                   
                                          
  qqwqqqqqqqqqqqqqqqqwq> <file-spec> qqq> 
    mq> <node-spec> qj                    
                                          

  (B)0node-spec =                               
                                            
  qwq> <nodename> qwqqqqqqqqqqqqqqqqqqqwqwq>
   x               mq> <access-string> j x  
   mqqqqqqqqqqqqqqqqqq :: <qqqqqqqqqqqqqqj  

  (B)0access-string =                       
                                        
  qwq> " <user-name> <password> " qqwq> 
   mq> " <VMS-proxy-user-name> " qqqj   
                                        

  (B)0literal-user-auth =                                       
                                                            
  qqq> USER '<username>' qwqqqqqqqqqqqqqqqqqqqqqqqqwqq>     
                          mq> USING '<password>'  qj        
                                                            

  (B)0attach-options =                                                       
                                                                         
  qwq> DBKEY qwq> SCOPE IS qwq> ATTACH qqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqwq>
   tq> ROWID qj             mq> TRANSACTION qqj                       x  
   tq> MULTISCHEMA IS qwq> ON qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
   x                   mq> OFF qj                                     x  
   tq> PRESTARTED TRANSACTIONS ARE qwq> ON qqwqqqqqqqqqqqqqqqqqqqqqqqqu  
   x                                mq> OFF qj                        x  
   mqwqqqqqqqwq> RESTRICTED ACCESS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
     mq> NO qj                                                           

  (B)0root-file-params-2 =                                                  

  qwq> global-buffer-params qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
   tq> SNAPSHOT IS qqqqwqqqqq> ENABLED qwq>  IMMEDIATE wqwqqqqqqqqqqqu
   x                   x                mq>  DEFERRED qj x           x  
   x                   mqqqqq> DISABLED qqqqqqqqqqqqqqqqqj           x  
   tq> DICTIONARY IS qqqwqqq> REQUIRED qqqqqqqwqqqqqqqqqqqqqqqqqqqqqqu  
   x                    mqqq> NOT REQUIRED qqqj                      x  
   tq> ADJUSTABLE LOCK GRANULARITY IS qwq> ENABLED q> alg-options qwqu  
   x                                   mq> DISABLED qqqqqqqqqqqqqqqj x  
   tq> LOCK TIMEOUT INTERVAL IS <number-seconds> SECONDS qqqqqqqqqqqqu  
   tq> SEGMENTED STRING qwq> STORAGE AREA IS <area-name> qqqqqqqqqqqqu  
   tq> LIST qqqqqqqqqqqqqu                                           x  
   tq> DEFAULT qqqqqqqqqqj                                           x  
   tq> PROTECTION IS qqqwqqq> ANSI qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
   x                    mqqq> ACLS qqj                               x  
   tq> RESERVE <n> wq> CACHE SLOTS qqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
   x               tq> JOURNALS qqqqqqqu                             x  
   x               tq> STORAGE AREAS qqu                             x  
   x               mq> SEQUENCES qqqqqqj                             x
   mqwq> SET qqqwq> TRANSACTION MODES qq> ( qwq> txn-modes qwq> ) qqqj  
     mq> ALTER qj                            mqqqqq , <qqqqqj           

  (B)0global-buffer-params=                                       
                                                              
  qq> GLOBAL BUFFERS ARE qwq> ENABLED qqwqqqqqqqqqqqqqqk      
                          mq> DISABLED qj              x      
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj      
  tqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq>   
  m> ( qwwq> NUMBER IS <number-glo-buffers> qqqqww> ) j       
        xtq> USER LIMIT IS <max-glo-buffers> qqqux            
        xtq> PAGE TRANSFER VIA qqwq> DISK qqqwqqjx            
        xx                       mq> MEMORY qj   x            
        xmq> LARGE MEMORY IS qqwqq> ENABLED qqwqqu
        x                      mqq> DISABLED qj  x
        mqqqqqqqqqqqqqqqqqqq  , <qqqqqqqqqqqqqqqqj            
                                                              

  (B)0alg-options =                         
                                        
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> 
    mq> ( qq> COUNT IS <n> qq> ) qqj    
                                        

  (B)0txn-modes =                                      
                                                   
  qwqwqqqqqqqwqwq> READ ONLY qqqqqqqqqqqqqqqqqwqq> 
   x mq> NO qj tq> READ WRITE qqqqqqqqqqqqqqqqu    
   x           tq> BATCH UPDATE qqqqqqqqqqqqqqu    
   x           tq> SHARED qqqqwqqwqqqqqqqqqqwqu    
   x           tq> PROTECTED qu  tq> READ qqu x    
   x           mq> EXCLUSIVE qj  mq> WRITE qj x    
   tqqqqqqqqqqqqq> ALL qqqqqqqqqqqqqqqqqqqqqqqu    
   mqqqqqqqqqqqqq> NONE qqqqqqqqqqqqqqqqqqqqqqj    
                                                   

  (B)0root-file-params-3 =                                                
                                                                     
  qw> CARDINALITY COLLECTION IS qqqqqqqqqqqqqqqqqqqqqqqqqww> ENABLED qwqw
   t> CARRY OVER LOCKS ARE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqum> DISABLED j x
   t> GALAXY SUPPORT IS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu              x
   t> LOCK PARTITIONING IS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu              x
   t> LOGMINER SUPPORT IS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu              x
   t> METADATA CHANGES ARE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu              x
   t> STATISTICS COLLECTION IS qqqqqqqqqqqqqqqqqqqqqqqqqqu              x
   t> WORKLOAD COLLECTION IS qqqqqqqqqqqqqqqqqqqqqqqqqqqqj              x
   t> SYSTEM INDEX qwq> COMPRESSION IS qwq> ENABLED qqqwqqqqqwqqqqqqqqqqu
   x                x                   mq> DISABLED qqj     x          x
   x                mq> ( qwq> system-index-options qwq> ) qqj          x
   x                       mqqqqqqqqqq , <qqqqqqqqqqqj                  x
   t> prestarted-transaction-params qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
   t> SECURITY CHECKING IS qq> security-checking-options qqqqqqqqqqqqqqqu
   t> SYNONYMS ARE ENABLED qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
   m> NOTIFY IS qwq> ENABLED qq> notify-options  qwqqqqqqqqqqqqqqqqqqqqqj
                 mq> DISABLED qqqqqqqqqqqqqqqqqqqqj

  (B)0system-index-options =

  qwq> COMPRESSION IS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwwq ENABLED qwwq>
   tq> PREFIX CARDINALITY COLLECTION IS qqqqqqqqqqqqqqjm> DISABLED jx
   tq> PREFIX CARDINALITY COLLECTION IS ENABLED FULL qqqqqqqqqqqqqqqu
   mq> TYPE IS SORTED qqwqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
                        mq> RANKED qj

  (B)0prestarted-transaction-params =                                    

  q> PRESTARTED TRANSACTIONS ARE qwwqq> ENABLED qwwqqqqqqqqqqqqqqqqqqqqqqqqqqqqww>
                                  xmqq> ON  qqqqqjmq>(prestart-trans-options) qjx
                                  mqwq> DISABLED qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
                                    mq> OFF qqqqqqqj                          

  (B)0prestart-trans-options =

  qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
   tq> WAIT <n> SECONDS FOR TIMEOUT qu
   tq> WAIT <n> MINUTES FOR TIMEOUT qu
   mq> NO TIMEOUT qqqqqqqqqqqqqqqqqqqj

  (B)0security-checking-options =

  qwq> EXTERNAL qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwwq>
   x             mq> ( q> PERSONA SUPPORT IS qwq> ENABLED qqw> ) qjx
   x                                          mq> DISABLED qj      x
   mq> INTERNAL qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqj
                 mq> ( q> ACCOUNT CHECK IS qwqqq> ENABLED qqw> ) j
                                            mqqq> DISABLED qj

  (B)0notify-options =                                               
                                                                 
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>   
    mqq> ( ALERT OPERATOR qwqq>  operator-class  qwqq ) qqj      
                           mqqqqqqqqq + <qqqqqqqqqj              
                                                                 

  (B)0root-file-params-4 =                                            

  qwq> ASYNC BATCH WRITES ARE w> ENABLED q> async-bat-wr-options qwqqqwq>
   x                          m> DISABLED qqqqqqqqqqqqqqqqqqqqqqqqj   x
   twqqqqqqqqqqqqwq> ASYNC PREFETCH IS qqk                            x
   xm> DETECTED qj   lqqqqqqqqqqqqqqqqqqqj                            x
   x                 mqwq> ENABLED qqq> async-prefetch-options wqqqqqqu
   x                   mq> DISABLED qqqqqqqqqqqqqqqqqqqqqqqqqqqj      x
   tq> ROW CACHE IS qwq> ENABLED qqwqwqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqu
   x                 mq> DISABLED qj mq> row-cache-options qj         x
   tqwqqqqqqwq> INCREMENTAL BACKUP SCAN OPTIMIZATION qqqqqqqqqqqqqqqqqu  
   x m> NO qj                                                         x  
   tq> MULTITHREAD AREA ADDITIONS qqqq> multithread-options qqqqqqqqqqu  
   tq> RECOVERY JOURNAL q> ( q> ruj-options q> ) qqqqqqqqqqqqqqqqqqqqqu  
   tq> OPEN IS qw> MANUAL qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
   x            m> AUTOMATIC qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwu
   x                          mq>(WAIT <n> q> MINUTES q> FOR CLOSE) qjx
   mq> SHARED MEMORY IS qwq> SYSTEM qqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqj  
                         mq> PROCESS qwqqqqqqqqqqqqqwqqj             
                                      mq> RESIDENT qj

  (B)0asynch-bat-wr-options =                                            
                                                                     
  qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
   m ( wwq> CLEAN BUFFER COUNT IS <buffer-count> BUFFERS qqww> ) j   
       xmq> MAXIMUM BUFFER COUNT IS <buffer-count> BUFFERS jx        
       mqqqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqj        
                                                                     

  (B)0async-prefetch-options =                                        
                                                                  
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqw>
    mq> ( qwqwq> DEPTH IS <number-buffers> BUFFERS qqqqqwqqw> )qj 
           x mq> THRESHOLD IS <number-buffers> BUFFERS qj  x      
           mqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqqqqqqqj      
                                                                  

  (B)0row-cache-options =                                         
                                                              
  q> ( qwwq> CHECKPOINT qwq> ALL ROWS TO BACKING FILE qqqqqqqqqqqwqwwq> ) qq> 
        xx               tq> TIMED EVERY <n> SECONDS qqqqqqqqqqqqu xx
        xx               mq> UPDATED ROWS TO qwq> BACKING FILE qwj xx
        xx                                    mq> DATABASE qqqqqj  xx
        xtq> LOCATION IS qq> <directory-spec> qqqqqqqqqqqqqqqqqqqqqux
        xtq> NO qqwqq> LOCATION qqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqux
        xx        mqq> SWEEP INTERVAL qqj                          xx
        xtq> NUMBER OF SWEEP ROWS IS <n> qqqqqqqqqqqqqqqqqqqqqqqqqqux
        xmq> SWEEP INTERVAL IS <n> SECONDS qqqqqqqqqqqqqqqqqqqqqqqqjx
        mqqqqqqqqqqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqj

  (B)0multithread-options =                              
                                                     
  qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>  
     mq> ( qqwq> ALL AREAS qqqqqqqqqqqwqq> ) qqj     
             mq> LIMIT TO <n> AREAS qqj              
                                                     

  (B)0ruj-options =                               
                                              
  qwq> LOCATION IS qq> <directory-spec> qwqq> 
   tq> NO LOCATION qqqqqqqqqqqqqqqqqqqqqqu    
   mq> BUFFER MEMORY IS qwq> LOCAL qqqqqqu    
                         mq> GLOBAL qqqqqj

  (B)0storage-area-params-1 =                                   
                                                            
  qqwq> ALLOCATION IS qqq> <number-pages> qq> PAGES qqqqqwq>
    tq> CACHE USING <row-cache-name> qqqqqqqqqqqqqqqqqqqqu  
    tq> NO ROW CACHE qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
    tq> extent-params qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
    tq> INTERVAL IS qq> <number-data-pages> qqqqqqqqqqqqqu  
    tq> LOCKING IS qqwq> ROW qqwqq> LEVEL qqqqqqqqqqqqqqqu  
    x                mq> PAGE qj                         x  
    tq> PAGE FORMAT IS wq> UNIFORM qwqqqqqqqqqqqqqqqqqqqqu  
    x                  mq> MIXED qqqj                    x  
    mq> PAGE SIZE IS qqqq> <page-blocks> qq> BLOCKS qqqqqj  
                                                            

  (B)0extent-params =                                        
                                                         
  qqwq> EXTENT IS qwq> ENABLED qqqqqqqqqqqqqqqqqqqwwqq>  
    x              tq> DISABLED qqqqqqqqqqqqqqqqqqux     
    x              tq> <extent-pages> qq> PAGES qqux     
    x              mq> (extension-options) qqqqqqqjx     
    mqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqj     
                                                         

  (B)0extension-options =                      
                                           
  qqq> MINIMUM OF <min-pages> PAGES, qqk   
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
  mqq> MAXIMUM OF <max-pages> PAGES, qqk   
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
  mqq> PERCENT GROWTH IS <growth> qqqqqqq> 
                                           

  (B)0storage-area-params-2 =                                        
                                                                 
  qqwq> CHECKSUM CALCULATION IS qqqqqqqqqqqwqqwq> ENABLED qqwqwq>
    tq> SNAPSHOT CHECKSUM CALCULATION IS qqj  mq> DISABLED qj x  
    tq> SNAPSHOT ALLOCATION IS qq> <snp-pages> qqqq> PAGES qqqu  
    tq> SNAPSHOT EXTENT IS qwq> <extent-pages> qqqq> PAGES qqwu  
    x                       mq> (extension-options) qqqqqqqqqjx  
    tq> SNAPSHOT FILENAME qq> <file-spec> qqqqqqqqqqqqqqqqqqqqu  
    tq> THRESHOLDS ARE ( <val1> wqqqqqqqqqqqqqqqqqqqqqqqw> ) qu  
    x                           m> ,<val2> qwqqqqqqqqqqwj     x  
    x                                       m> ,<val3> j      x  
    mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqj  
                                                                 

  (B)0character-sets =                                       
                                                         
  qwqwqq> DEFAULT CHARACTER SET <support-char-set> qqwqwq>
   x tqq> NATIONAL CHARACTER SET <support-char-set> qu x 
   x tqq> IDENTIFIER CHARACTER SET <names-char-set> qj x 
   x mqq> DISPLAY CHARACTER SET <support-char-set> qqqqu
   mqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqj

  (B)0database-element =                             
                                                 
  qwq> create-cache-clause qqqqqqqqqqqqqqqqqwqq> 
   tq> create-catalog-statement qqqqqqqqqqqqu    
   tq> create-collating-sequence-statement qu    
   tq> create-domain-statement qqqqqqqqqqqqqu    
   tq> create-function-statement qqqqqqqqqqqu    
   tq> create-index-statement qqqqqqqqqqqqqqu    
   tq> create-module-statement qqqqqqqqqqqqqu    
   tq> create-procedure-statement qqqqqqqqqqu    
   tq> create-sequence-statement qqqqqqqqqqqu
   tq> create-schema-statement qqqqqqqqqqqqqu    
   tq> create-storage-area-clause qqqqqqqqqqu    
   tq> create-storage-map-statement qqqqqqqqu    
   tq> create-table-statement qqqqqqqqqqqqqqu    
   tq> create-trigger-statement qqqqqqqqqqqqu    
   tq> create-view-statement qqqqqqqqqqqqqqqu    
   mq> grant-statement qqqqqqqqqqqqqqqqqqqqqj    
Close Help