Read/Write Usage Limitations of the Adapter for RMS

In this section:

The adapter has certain limitations when used for write purposes. The following topics discuss these issues and possible alternatives that may be used.


Top of page

x
OCCURS Statements in a Master File

OCCURS statements in a Master File are not directly supported by the write portion of the adapter. If an OCCURS statement is for a specific number of instances, an alternate Master File may be coded by using specific naming (for example, AMTDUE OCCURS=12 would be coded as AMTDUE01, AMTDUE02, and so on). The write application must then reference the alternate Master File using the specific fields.

For example:

SEGNAME=MTH, SEGTYPE=S0, PARENT=YEAR, OCCURS=12,$
FIELD=PAYABLES, AP, I8 , I4 , $

would be coded as

SEGNAME=MTH, SEGTYPE=S0, PARENT=YEAR, $
FIELD=PAYABLES01, AP01, I8 , I4 , $
FIELD=PAYABLES02, AP02, I8 , I4 , $
FIELD=PAYABLES03, AP03, I8 , I4 , $
FIELD=PAYABLES04, AP04, I8 , I4 , $
FIELD=PAYABLES05, AP05, I8 , I4 , $
FIELD=PAYABLES06, AP06, I8 , I4 , $
FIELD=PAYABLES07, AP07, I8 , I4 , $
FIELD=PAYABLES08, AP08, I8 , I4 , $
FIELD=PAYABLES09, AP09, I8 , I4 , $
FIELD=PAYABLES10, AP10, I8 , I4 , $
FIELD=PAYABLES11, AP11, I8 , I4 , $
FIELD=PAYABLES12, AP12, I8 , I4 , $

Top of page

x
Commit Processing

The Adapter for RMS, in conjunction with RMS itself, treats a single SQL statement as a complete unit of work. This means that the server automatically commits after every SQL statement. If the front-end application sends an SQL COMMIT or SQL ROLLBACK statement(s), it will be ignored by the adapter.


Top of page

x
SQL Commands

The following are acceptable SQL commands:

Command

Function

SELECT

Retrieves data for the entire table (*) or for specified columns.

DELETE

Removes one or more records from an RMS keyed file.

INSERT INTO

Adds data to an RMS keyed file.

UPDATE

Updates values of one or more columns in a record of an RMS keyed file.



x
SQL, MODIFY and MAINTAIN Operations

Releases prior to 5.2 of the server did not support multi-record SQL INSERT, DELETE and UPDATE except when done as a PREPARE, plus MODIFY and MAINTAIN were not supported. This limitation is removed as of the 5.2 release. Recoding existing applications that used PREPARE is not required, all methods are supported.


iWay Software