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.
WebFOCUS |