SQL/DDL Implementation › Extended SQL Naming › Example of Pre-Release 5.2 SQL Naming

Example of Pre-Release 5.2 SQL Naming

The following example shows generated SQL DDL prior to Release 5.2 to create a view and an index for an access path over a table called ORDP.

EXEC SQL
       CREATE VIEW RWCSQL.ORDL1 (       
               ABABCD                   
              ,ABADCD                   
              ,ABACTX                   
              ,ABABST                   
              ,ABABDT                   
                                  )     
       AS SELECT                        
               X1.ABABCD                
              ,X1.ABADCD                
              ,X2.ACACTX                
              ,X1.ABABST                
              ,X1.ABABDT                
       FROM       RWCSQL.ORDPX1         
                   ,RWCSQL.CUSPX2       
       WHERE    X1.ABADCD = X2.ACADCD   
END-EXEC                                
EXEC SQL                                
       COMMENT ON TABLE RWCSQL.ORDL1 IS 
‘Orders                 Retrieval index’
END-EXEC