SQL$HELP72.HLB  —  CREATE  VIEW  Format
  (B)0CREATE VIEW qq> <view-name> qqqqqqqqqqqqqqqqqqqqqqqqqk
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
    mwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqk
     mq> STORED NAME IS <stored-name> qqqj             x
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mwqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqqqqwqk
   mq> ( qwq> <column-name> qwqqqqqqqqqqqqqqwqwq> ) qj x
          x lqqqqqqqqqqqqqqqqj              x x        x
          x mwqwqqqqqqqqqqqqqqqqqqqqqqqqwqwqj x        x
          x  x mq> sql-and-dtr-clause qqj x   x        x
          x  mqqqqqqqqqqqqq<qqqqqqqqqqqqqqj   x        x
          mqqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqj        x
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mq> AS select-expr qqqwqqqqqqqqqqqqqqqqqqqqqqqqwqq>   
                        mq> check-option-clause qj      
                                                        

  (B)0select-expr =                                                     
                                                                    
  qwqwq>  select-clause  qqqqqqqqqqqqwqwqqqqqqk                     
   x tq> ( select-expr )  qqqqqqqqqqqu x      x                     
   x mq>   TABLE table-ref qqqqqqqqqqj x      x                     
   mqqqqqq select-merge-clause <qqqqqqqj      x
     lqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqj                     
     mqwqqqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqqqwq>
       mq> order-by-clause qj  mq> offset-clause qj  mq> limit-to-clause qj

  (B)0sql-and-dtr-clause =                                             
                                                                   
  qwq> QUERY HEADER IS qw> <quoted-string> wqqqqqqqqqqqqqqqqqqqwq> 
   x                    mqqqqqq / <qqqqqqqqj                   x   
   tq> EDIT STRING IS <quoted-string> qqqqqqqqqqqqqqqqqqqqqqqqqu   
   x                                                           x   
   tq> QUERY NAME FOR qwq> DTR qqqqqqqqwq> IS <quoted-string> qu   
   x                   mq> DATATRIEVE qj                       x   
   mq> DEFAULT VALUE FOR qwq> DTR qqqqqqqqwq> IS literal   qqqqj  
                          mq> DATATRIEVE qj                        
                                                                   

  (B)0check-option-clause =                                      
                                                             
  WITH CHECK OPTION qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>
                      mq> CONSTRAINT <check-option-name> j   
                                                             
Close Help