The RMS View text file import specification can be used to populate your CDD with predefined CONNX Views using the RMS 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>

 

Subsequent lines 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, followed by a SELECT statement and a footer line with the word ENDVIEW.

 

The following is an example of an RMS 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_RMS.orderid as 'Order' /* Order Number */,

ORDERS_RMS.customerid as 'Cust Id' /* Customer Identification */,

CUSTOMERS_RMS.customername as 'Name' /* Name of Customer*/,

CUSTOMERS_RMS.customerstate as 'ST' /* State Ordered by */,

ORDERS_RMS.orderdate as 'Ord Date' /* Date Ordered */,

ORDERS_RMS.productid as 'Product' /* Product number */,

PRODUCTS_RMS.productname as 'Description' /* Product Description */,

ORDERS_RMS.productquantity as 'Qty' /* order quantity */,

PRODUCTS_RMS.productprice as 'Price' /* price per unit */,

(ORDERS_RMS.productquantity * PRODUCTS_RMS.productprice) as 'Ext Price' /* Calculate extended price) */

FROM ORDERS_RMS, CUSTOMERS_RMS, PRODUCTS_RMS /* Tables included in view */ 

WHERE ORDERS_RMS.customerid=CUSTOMERS_RMS.customerid AND

ORDERS_RMS.productid=PRODUCTS_RMS.productid and CUSTOMERS_RMS.customerstate in ('WA', 'OR', 'MT', 'ID', 'CA') /* Join tables together and select only Northwest states */

ENDVIEW