Sequential and Indexed Adapters

The File Listener component of DataMigrator can process Microsoft Excel workbooks that are delivered to a specified directory.

In addition to the synonym for the workbook as Excel (via direct read), this requires a synonym for a flat file with the normal file listener parameters specified. An additional segment contains a copy of the synonym for the Excel workbook.

Previously, when creating a synonym for a Delimited Flat File or Excel workbook using the direct read adapter, columns with timestamp or date-time values were created as alphanumeric fields.

Now such columns are recognized, and the synonym is created with appropriate USAGE and ACTUAL formats.

The OpenVMS Adapter for RMS now supports the direct read and write of native OpenVMS 64-Bit DEC TIMESTAMP data using H date-time formats for USAGE and ACTUAL formats when the following command is in effect.

SET VMSTIMESTAMP = VMS

This eliminates the need for the WRTSTIME() and CVTSTIME() subroutines in the writing and displaying of dates stored in this format in MODIFY and other applications.

Any H date is valid, but more commons ones follow.

The following displays as 2004/12/01 15:18:17.610.

...,USAGE=HYYMDs,ACTUAL=HYYMDs, ...

The following displays as 2004/12/01 15:18:17.

...,USAGE=HYYMDS,ACTUAL=HYYMDS, ...

The following displays as 01-Dec-2004 15:18:17.61.

...,USAGE=HDMtYY-2,ACTUAL=HDMtYY-2, ...

The format HDMtYY-2 most closely mimics the OpenVMS 64-Bit TIMESTAMP format (as displayed by commands such as DIRECTORY/DATE), except that the month is displayed in mixed case.

If your server application only uses RMS files, SET VMSTIMESTAMP = VMS command should be added to the server EDASPROF.PRF profile (which is in the EDACONF etc directory).

Some SQL examples follow.

SQL INTO MYTABLE
VALUES ('123456789','2015-07-08 12:08:07.12') ;
END

SQL UPDATE MYTABLE
SET SOLD_TIMESTAMP='2015-07-07 12:08:07.12'
WHERE ACCT='123456789' ;
END

Support for the command SQL SET INSERTSIZE=n for prepared SQL UPDATE, INSERT, and DELETE statements against non-SQL Data Adapters has been implemented to improve performance.

The feature is only active for prepared SQL logic, such as the following.

SQL PREPARE SQLIN FROM
INSERT INTO MYTABLE (FIELD_KEY,FIELD_A) VALUES (?,?)
END
SQL BIND SQLIN USING INTEGER, VARCHAR(10);
END
SQL
EXECUTE SQLIN USING 1, 'One';
END

Internally, records will be collected and then executed (under MODIFY) when the INSERTSIZE is reached, or sooner if a COMMIT, PURGE, or different SQL statement is encountered.

The feature is not active for non prepared SQL statements such as INSERT INTO INTO MYTABLE VALUES (1,'One').

SQL requests sent using JLINK applications must also set setAutoCommit(false) on the Java connection to override the java.sql.Connection behavior of sending commits after each transaction.

The OpenVMS Adapter for RMS now allows the locked record wait period for LOCKMODE=KEEP to be set and, in order to match the behavior when LOCKMODE is not declared for the RMS file, the setting LOCKMODE= REJECT can be invoked. If an explicit wait period is not set for KEEP, the default wait period is 10 seconds, as it was prior to the implementation of this feature.

The syntax is

ENGINE RMS SET WAIT_LOCKED n

where:

n

Is the number of seconds to wait.