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