Import Specification for RMS View Text Files
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 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. 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.
Here 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
Follow the steps in Importing from Different Sources to import your text file.