DM_SQLIO_SCOPEID Keyword

     DM_SQLIO_SCOPEID={ON|OFF}

This keyword forces the Data Manager to use the SQL Server 'SCOPE_IDENTITY' function to get the last IDENTITY value inserted into an IDENTITY column in the same scope.

It has been reported that the PL/B SQLIO FPOSIT operation could return an invalid IDENTITY value when using the Microsoft Server with multiple PL/B user and non-PL/B user applications are changing the same SQL table.

When the 'DM_SQLIO_SCOPEID' keyword is not being used or set the OFF, the Data Manager uses the SQL Server 'IDENT_CURRENT' identity value which may rarely return the unexpected value.

When the 'DM_SQLIO_SCOPEID' is set to ON, the Data Manager uses the SQL Server 'SCOPE_IDENTITY' function to fetch the last identity value that is only applicable for the current user scope and session.

Example:

     DM_SQLIO_SCOPEID=ON

See Also: SUNDM Keywords, SUNADMIN, MAKEMFD