The C-ISAM VIEW text file import specification can be used to populate your CDD with predefined CONNX Views using the C-ISAM Text Import Option.  

The VIEW text file import specification layout is described below.

The first line of each view layout must contain CONNXVIEW and the view object name as follows:

 

CONNXVIEW, <VIEWOBJECTNAME>
 

The subsequent lines of each view layout must contain the SQL Select statement:

SELECT ...
 

The last or footer line in each view must contain:

ENDVIEW
 

One import text file may contain multiple views, each starting with the same header line shown above and followed by a SELECT statement and a footer line with the word ENDVIEW.

The following is an example of a C-ISAM VIEW import file:

CONNXVIEW, 
 NWORDERS
/*This view 
 was requested by Johnathon Jones on 3/1/2001.  He executes this view 
 daily to see orders for the Northwest Territory. */
 
SELECT
ORDERS_C-ISAM.orderid 
 as 'Order' /* Order Number
*/,
ORDERS_C-ISAM.customerid 
 as 'Cust Id' /* Customer Identification */,
CUSTOMERS_C-ISAM.customername 
 as 'Name' /* Name of Customer*/,
CUSTOMERS_C-ISAM.customerstate 
 as 'ST' /* State Ordered by */,
ORDERS_C-ISAM.orderdate 
 as 'Ord Date' /* Date Ordered */,
ORDERS_C-ISAM.productid 
 as 'Product' /* Product number */,
PRODUCTS_C-ISAM.productname 
 as 'Description' /* Product Description */,
ORDERS_C-ISAM.productquantity 
 as 'Qty' /* order quantity */,
PRODUCTS_C-ISAM.productprice 
 as 'Price' /* price per unit */,
(ORDERS_C-ISAM.productquantity 
 * PRODUCTS_C-ISAM.productprice) as 'Ext Price' /* Calculate extended price) 
 */
 FROM 
 ORDERS_C-ISAM, CUSTOMERS_C-ISAM, PRODUCTS_C-ISAM /* Tables included in 
 view */
WHERE ORDERS_C-ISAM.customerid=CUSTOMERS_C-ISAM.customerid
AND
ORDERS_C-ISAM.productid=PRODUCTS_C-ISAM.productid 
  AND
CUSTOMERS_C-ISAM.customerstate 
 in ('WA', 'OR', 'MT', 'ID', 'CA') /* Join tables together and select only 
 Northwest states */
ENDVIEW