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.
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 , $
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.
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. |
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 |