TECHNICAL PREVIEW 2 SQL Procedures support for IBM DB2 Stored Procedure Builder (C) Copyright International Business Machines Corporation 1999. All rights reserved. Note to U.S. Government users -- documentation related to restricted rights. Use, duplication, or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp. ----------------------------------------------------------------------- This technical preview for IBM DB2 Stored Procedure Builder supports building SQL procedures on DB2 for OS/390 Version 5 and Version 6 databases. This technical preview is provided in English only, on an AS IS basis, and without warranty of any kind. Send any queries or comments to sqlproc@us.ibm.com. For more general information on SQL procedures, see the following URL: http://www.ibm.com/software/db2os390/sqlproc/ TABLE OF CONTENTS ================= Prerequisites for building SQL procedures on a DB2 for OS/390 Version 5 database Prerequisites for building SQL procedures on a DB2 for OS/390 Version 6 database Prerequisites for installing IBM DB2 Stored Procedure Builder Installing IBM DB2 Stored Procedure Builder Unsupported items in this technical preview Prerequisites for building SQL procedures on a DB2 for OS/390 Version 5 database ------------------------------------------------------------- To build an SQL procedure on a DB2 for OS/390 Version 5 database by using Stored Procedure Builder, you must have the following components: * SQL procedures support If you download SQL procedure support only, you can create SQL procedures by using JCL (job control language). For information on downloading and installing SQL procedure support, see the following URL and follow the links to the prerequisites for installing SQL procedure support: http://www.ibm.com/software/db2os390/sqlproc/ * REXX stored procedure support For information on downloading and installing REXX stored procedure support, see the following URL and follow the links to the prerequisites for installing REXX stored procedure support: http://www.ibm.com/software/db2os390/sqlproc/ * IBM DB2 Stored Procedure Builder (technical preview) To create SQL procedures with Stored Procedure Builder, you must have SQL procedure support and REXX stored procedure support. Prerequisites for building SQL procedures on a DB2 for OS/390 Version 6 database ------------------------------------------------------------- To build an SQL procedure on a DB2 for OS/390 Version 6 database by using Stored Procedure Builder, you must have the following components: * SQL procedures support The following set of APARs are required for the base SQL Procedure Support. If you apply these APARs you can create SQL procedures by using JCL (job control language): PQ29782, PQ30467, PQ33026, PQ33560 The following APARs are required for building SQL procedures using the Stored Procedure Builder. These APARs are required in addition to the ones listed above: REXX Stored Procedure Support: PQ30219, PQ33132, PQ33133 Dynamic Invocation of Bind: PQ24199 SQL Procedure Processor and Samples: PQ30492 Other suggested APARs include the support for Identity Columns, Temporary Tables and Save Points. These are: Identity Columns: PQ30684, PQ30652 Temporary Tables: PQ32670 Save Points: PQ30439 * REXX Language Support for DB2 for OS/390 Version 6 For information on downloading and installing REXX language support, see the following URL and follow the links to the prerequisites for installing REXX stored procedure support: http://www.ibm.com/software/db2os390 * IBM DB2 Stored Procedure Builder (technical preview) To create SQL procedures with Stored Procedure Builder, you must have SQL procedure support and REXX stored procedure support. Prerequisites for installing IBM DB2 Stored Procedure Builder ------------------------------------------------------------- Before you install this technical preview of Stored Procedure Builder, you must have the following components installed on your computer: * DB2 Universal Database SDK Version 6.1 * DB2 Connect Personal Edition Version 6.1 You can obtain these components by installing any one of the following DB2 products: * DB2 UDB Enterprise Edition * DB2 UDB Extended-Enterprise Edition * DB2 Universal Developer's Edition * DB2 Connect Personal Edition * DB2 UDB Personal Developer's Edition Note: When installing these DB2 products, you must install the SDK. You can also obtain the SDK and DB2 Connect when you install the Management Tools Package for DB2 for OS/390. In addition, the SDK and DB2 Connect might be unpriced features of DB2 for OS/390 components that you have installed on your system. For more information about downloading any of these DB2 products, see the following URL: http://www.software.ibm.com/data/db2/udb/ Installing the IBM DB2 Stored Procedure Builder technical preview ----------------------------------------------------------------- Note: Before you install Stored Procedure Builder, you must have met the above prerequisites. To install Stored Procedure Builder, run the SETUP.EXE file for Stored Procedure Builder contained in the self-extracting zip file. The files for Stored Procedure Builder are installed in the directory and subdirectories where you have installed the SDK. The technical preview functionality for Stored Procedure Builder is installed as separate files from the files for Stored Procedure Builder Version 6.1; therefore, you can run separately Stored Procedure Builder Version 6.1 and the technical preview of Stored Procedure Builder. To uninstall the technical preview of IBM DB2 Stored Procedure Builder: 1. From the Start menu, select Settings --> Control Panel. 2. Double click the Add/Remove Programs icon. 3. From the Install/Uninstall tab, select "OS390 SQL Stored Procedure Builder Support (Preview 2)." 4. Click "Add/Remove." Unsupported items in this technical preview ------------------------------------------- The following features are not supported: * You cannot use customized delimiter characters for stored procedure names and schema names. By default, Stored Procedure uses double-quotation marks ("") to delimit stored procedure names and schema names containing special characters or spaces. * If you are using DB2 for OS/390 Version 5 and plan to migrate to DB2 Version 6 for OS/390, IBM recommends that you do not use AUTHID or LUNAME when defining a stored procedure. * When you change a parameter and rebuild the stored procedure, you must perform one of these actions: o If the STAY RESIDENT option is equal to YES, you must refresh your stored procedures address space. o If the STAY RESIDENT option is equal to NO, you must refresh the definition of your stored procedure in the catalog table SYSPROCEDURES. See the "IBM DB2 Universal Database for OS/390 Version 5 or Version 6 Application Programming and SQL Guide," for more information about the STAY RESIDENT option. * You cannot create SQL procedures that have names where the first eight characters of each name are the same. For example, you cannot have two SQL procedures with the following names: procedur1 procedur2 The first eight characters of each SQL procedure name must be unique because Stored Procedure Builder uses the first eight characters of the SQL procedure name as the load module name. * You cannot have an underscore (_) character in the stored procedure name.