The following two examples show the generated SQL DDL and SQL DML that results if you set YSQLVNM to *SQL and YSQLLEN to 25. Note that the view name remains unchanged, but the table name becomes ORDERS (from ORDP) and columns are assigned the names for the corresponding fields in the CA 2E model.
Note: Do not use reserved SQL keywords when selecting names. The name ORDERS is used because ORDER is a reserved SQL keyword and cannot be used as a valid table name.
|
Copyright © 2014 CA.
All rights reserved.
|
|