A
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
      ---------------------------------------------------------------
      |  README file for SESAM/SQL-Server V3.2A                     |
      |                                                             |
      ---------------------------------------------------------------
  
      February 2005
  
  
      This README file for SESAM/SQL-Server V3.2A contains changes
      and extensions relating to the following manuals:
  
      [1] SESAM/SQL-Server V3.0A (BS2000/OSD)
          CALL DML Appliacations
          Order number U1054-J-Z125-11-76
          Edition January 2000
  
      [2] SESAM/SQL-Server V3.2A (BS2000/OSD)
          SQL-Reference Manual Part 1
          Order number U22420-J-Z125-6-76
          Edition November 2003
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
A
  
  
      Contents
  
      1      Overview of the changes and extensions  . . . .       1
      1.1    Enhancement in manual "CALL-DML Applications" .       1
      1.2    Enhancement  in manual "  SQL-Reference  Manual       1
             Part 1"
      1.2.1  User-Close  . . . . . . . . . . . . . . . . . .       1
      1.2.2  Enhanced Pragma ISOLATION LEVEL . . . . . . . .       1
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
                                 -  2  -
A
  
  
      1 Overview of the changes and extensions
  
      Additionally,  due to version SESAM/SQL V3.2A30 there are some
      small changes  in  the manuals "CALL DML Applications" [1] and
      "SQL-Reference Manual Part 1" [2].
  
      In manual "CALL-DML-Applications" [1]  there is an enhancement
      in section 3.19 Administrator Open.
  
      In manual "SQL-Reference Manual Part 1" [2] there is an enhan-
      cement in section 2.6.2 und 3.3.3.
  
  
      1.1 Enhancement in manual "CALL-DML Applications"
  
      The following section is an  enhancement to the section "Admi-
      nistrator Open" on page 169 in  manual "CALL-DML Applications"
      [1]:
  
      in stead of "This statement may only  be  issued  in  programs
      that  have  not  opened any logical files and in which admini-
      stration in the DBH is permitted (see the "Database Operation"
      manual)."
  
      it must be:
  
      "This statement may only  be  issued  in programs that neither
      have opened any logical files nor any sql session and in which
      administration in the DBH is permitted (see the "Database Ope-
      ration" manual)."
  
  
      1.2 Enhancement in manual " SQL-Reference Manual Part 1"
  
      1.2.1 User-Close
  
      The following capital "Using User-Close" on page  39 in manual
      "SQL-Reference  Manual  Part  1" [2] is changed into  "Release
      Session Resources".
  
  
      1.2.2 Enhanced Pragma ISOLATION LEVEL
  
      Manual SQL-Reference Manual Part 1:
  
      Section 3.3.3 Pragma ISOLATION LEVEL
  
       - the syntax was enhanced:  READ NOWAIT in front of
                                   READ UNCOMMITTED
  
       - after this syntax and before the paragraph
         "The isolation levels are ...":
  
       "Caution":
        The ISOLATION LEVEL READ NOWAIT can only be set by Pragma
        but not within the SET TRANSACTION Statement.
        If you have  specified the  ISOLATION LEVEL pragma, any
        database access performed in connection with this statement
        takes place under CONSISTENCY LEVEL 1.
        (s. page 378).
  
                                 -  1  -