| December 2000
| More Information About Magic/400 DB2 SQL gateway 8.20-1.3
| Dear Developer, We are happy to introduce Magic/400 DB2 SQL gateway 8.20-1.3. We hope you will find working with the product enjoyable and fruitful.
| General Information: Please follow the information supplied in this document to complete the patch installation and your knowledge of the supplied modules and functionality. What is installed How to complete the installation Pre Requisites New Features Limitations Definition Keywords UDF Runtime
| What is installed: (Top) This patch places the following file in the patch installation directory:
MGDB400.DLL | This file replaces the older version of it in the directory of the Magic Engine.
EAC32TCP.DLL | This file replaces the older version of it in the directory of the Magic Engine.
EASY32MG.DLL | This file replaces the older version of it in the directory of the Magic Engine.
EASYCOM.SVF | This file contains one program: EASYCOM for your MAGIC/400 host library. Create save file EASYCOM in the MAGIC/400 library (CRTSAVF FILE (MAGIC400/EASYCOM) · Start ftp (sign-on to AS/400 where the server is installed) · Type bin (Binary transfer mode) · Type cd MAGIC400 (AS/400 library name for the Magic/400 host library) · Type lcd temp (PC directory temp is a location of the EASYCOM.SVF) · Type put easycom.svf easycom.savf Perform Following command on AS/400: · Save existing program EASYCOM: CRTDUPOBJ OBJ(EASYCOM) FROMLIB(MAGIC400) OBJTYPE(*PGM) TOLIB(MAGIC400) NEWOBJ(EASYCOM#) · Restore EASYCOM module from the save file : RSTOBJ OBJ(*ALL) SAVLIB(MG400CLI) DEV(*SAVF) SAVF(MAGIC400/EASYCOM) RSTLIB(MAGIC400)
How to complete the installation: (Top) To complete the installation of the patch please follow the following guidelines:
Magic Main Installation | In the Man Magic Installation directory replace the following file with the new one supplied by this package: MGDB400.DLL, EAC32TCP.DLL, EASY32MG.DLL.
Magic.INI | 1. Define the new SQL AS/400 Gateway: [MAGIC_GATEWAYS] MGDB06=MGDB400.DLL 2. Define the new DBMS [MAGIC_DBMS] DB2/400 = 7, OnePhaseCommit, NotAllowNull, NotTransLockExcl, 10.3, , + NotShowPlan, N, , NotLogSync, 0, 0, NotCheckExist,+ SUPPORT\ACS400.ENG 3. Define the new database: [MAGIC_DATABASES] DB2400SQL = 7, DB2CAt, , , MAGIC170, , , , NoMagicRecordLock, ChangeFile+InToolkit, CheckDefinition, CheckKey, NoFileLocks, , SQL_ISOLATIO+N_LEVEL=UR, , CheckExist, 0, , NoXATrans, NoAS400SrvrSort, SUPPORT\ACS400.ENG Note: MAGIC170 is an AS/400 host name; DB2CAT is your AS/400 SQL Collection.
| Pre Requisites: (Top) · OS/400 V4R4 and later · Magic/400 (ISAM) Client 8.2-9.1 and later · Update for Magic/400 Host Library (included in this installation) · Magic Engine Version 8.30 SP5 and later
| New Features: (Top) · Performance improvement The drastic performance improvement was achieved by implementing native SQL CLI functions and by utilizing the Array Size option of the database property for the caching mechanism. · Support for the BLOB data type The BLOB data type is fully supported by this gateway. · Support for the SQL naming format New Keyword allows you to use the SQL naming format. The keyword syntax is NAMING=*SQL. Specifying this keyword in the DBMS of DB2/400 will allow you to use SQL naming format: collection.table · Support for the APG function in the 'SQL Command' window The automatic program generator button (APG) is now functional in the SQL Command window.
| Limitations: (Top) · The DBCOPY function is not supported. · You cannot implement an Insert or Update command for an SQL Statement that has a single quotation mark in the value. · The DB2/400 database for Magic Control File (CTL) is not supported. Use BTRIEVE or the AS/400 (ISAM) database.
| Definition: (Top) · A new table only can be created in the AS/400 SQL collection. · You need to define the isolation level in the Database Information field of the Database Properties dialog as recommended below: -for an ONLINE TASK, SQL_ISOLATION_LEVEL=UR (Uncommitted Read) -for a BATCH TASK, SQL_ISOLATION_LEVEL=CS (Committed Read) · Tables created by the Get Definition function can be physically deleted only if you remove the SHRTNAME keyword from the Database Information field of the Table Properties dialog for an SQL Database. · An SQL table must have at least one unique index. · Use new DBMS keyword CONNECTDLL=MGEAC32.DLL in order to share one AS/400 connection with AS/400 ISAM gateway
| Keywords: (Top) · DBMS keyword: LANGUAGE, EAC_LOG, MAGICDBA, MAGICSRV, CONNECTDLL, NAMING
| UDF: (Top) · All UDF functions in the ISAM AS/400 Gateway are supported in the SQL AS/400 Gateway (for example: AS400PGMCALL, STARTSESSION)
| Runtime: (Top) · You can use ISAM AS/400 Gateway and the new SQL AS/400 Gateway together in the same task.
| Thank you, The Magic Version 8 Team