PLB_SQLIO_SCOPEID Keyword

9.7A

PLB_SQLIO_SCOPEID={ON | OFF}

This keyword forces the PL/B runtimes 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 'PLB_SQLIO_SCOPEID' keyword is not being used or set the OFF, the PL/B runtimes use the SQL Server 'IDENT_CURRENT' identity value which may rarely return the unexpected value. When the 'PLB_SQLIO_SCOPEID' is set to ON, the PL/B runtimes use the SQL Server 'SCOPE_IDENTITY' function to fetch the last identity value that is only applicable for the current user scope and session.