C-ISAM, DISAM, or Micro Focus VIEW Text File Import Specification
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. The last or footer line in each view must contain ENDVIEW.
One import text file can contain multiple views. Each view must start with the header line that is shown above, continue with a SELECT statement and end with a footer line with ENDVIEW.
Here 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