|  | March 2002
| More Information About The Magic Gateway for DB2 Version 8.20-8.19 |
| Dear Developer, We are happy to introduce The Magic Gateway for DB2 Version 8.20-8.19. This version is a bug-fix release for Magic Versions 8.20 and above. We hope you will find working with our product enjoyable and fruitful. Note: This gateway version supports working with DB2 version 6 and 7 servers. In order to do so, a DB2 version 6 or 7 client must be installed. |
| Changes in the current release: 8-19 The shared lock table on the MCF table was removed. Support for Identity columns was added. Isolation level control - In order to change the isolation level, the developer should use in the database information the following flag: SQL_ISOLATION_LEVEL = UR/CS/RS/RR (stands for 0/1/2/3 correspondingly) The numbers stands for: 0 - Read uncommitted (UR=uncommitted read) 1 - Read committed (CS=Cursor stability) 2 - Repeatable read (RS=Read stability) 3 - Serializable (RR=Repeatable read) 8-18 774621: When a Logical name is used for the schema, Ctrl+G does not create the table. 986279 - Magic terminates on executing a batch update program with Onlock/Retry transaction and Locking Strategy=Immediate. 8-17 759267: In some cases a record is shown twice when browsing through a table using the down arrow. This can happen when there are two index segments - One segment is a large alpha field and the second is a numeric field. 755605 : Incremental Locate does not work properly. When typing two letters ('AP') the gateway issues an incorrect select statement and tries to locate only accrediting to the second letter ('P'). 8-16 The syntax for SELECT FOR UPDATE statements was changed in order to work with DB2 installed on OS\390. Instead of sending: select crt_sht_nm from dbadchv.crt where crt_itl_nu = 'SDC' for update the gateway will send: select crt_sht_nm from dbadchv.crt where crt_itl_nu = 'SDC' for update of crt_sht_nm 8-15 QCR 519563 - Magic terminates on executing a program with Link outer join without selecting a key field from the main table and with locate on more than one linked field. This happens only if not selecting the Alpha index and if the locate expression for the link in the Alpha field is a constant. QCR 753225 - Running a Task with two Link Left Outer joins and with no selected main table fields causes Magic to terminate. It happens only when the first Link is on a constant and the second link is on the key field of the first linked table. QCR 743953 - Magic terminates on running a program which has a select only for the position identifier fields and uses Link Outer join with a select only to the index field. This happens only when the locate expression for the link is a constant. QCR 980746 - Magic terminates on running a program with its fields select order different from the order they were defined in the table, when using range From = 0. QCR 484836 - Magic terminates on executing a runtime locate/range operation on a task having Link Outer Join with constant locate expression. QCR 4800 - Magic terminates on executing a runtime locate on a record of a table containing blob as its second field. This happens only when the blob field is selected as first field in the task in which you are locating. QCR 982076 - Magic terminates on executing a task with Link Left Outer Join. This happens only when the link has two constants in its locate expressions. 8.14 QCR 754462 - A magic program with Link Create that inserts records crashes due to memory leak. QCR 996247 - Magic locks a linked record during hook , when file is accessed for Read in C/S mode only. |
| Thank you, The Magic Version 8 Team |