PQ88582: ODBC SUPPORT FOR 2MB SQL STATEMENT

Currently, the maximum size in bytes of an SQL statement string
(including white spaces) allowed on the SQLPrepare,
SQLExecDirect and SQLNativeSql APIs is 32765.  DB2 V8 running in
NFM supports a maximum statement size of 2MB (2097152).
V8 DB2 ODBC will now support SQL statements up to 2MB in size
when connected to z/OS DB2 V8 servers running in NFM.

****************************************************************
* USERS AFFECTED: All users of DB2 UDB for z/OS Version 8      *
*                 ODBC/CLI.                                    *
****************************************************************
* PROBLEM DESCRIPTION: 1. Currently, the maximum statement     *
*                         size that DB2 ODBC supports is       *
*                         32765 bytes, while DB2 V8 in New     *
*                         Function Mode accepts SQL            *
*                         statements up to 2MB.                *
*                      2. The ODBC DBRMs are coded in          *
*                         CCSID 1047.  However the DBRMs       *
*                         are precompiled with the default     *
*                         CCSID value which could be           *
*                         different from 1047.  SQLCODE        *
*                         -104 could occur as a result.        *
*                         Furthermore, a DBRM precompiled      *
*                         with NEWFUN(YES) can be bound only   *
*                         with DB2 z/OS V8 and later           *
*                         releases.  For the downward          *
*                         compatible ODBC driver, users        *
*                         need to be able to bind to DB2 for   *
*                         z/OS V7 and below.                   *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
1. DB2 ODBC will support a maximum statement size of
   2097152 bytes (2MB) when connected to DB2 V8 for z/OS in
   New Function Mode,  during which time the new maximum SQL
   statement size will take effect for SQLPrepare(),
   SQLExecDirect(), SQLNativeSql() and SQLGetInfo()'s
   InfoType SQL_MAX_STATEMENT_LEN.

   If a SQL statement on a SQLPrepare() or SQLExecDirect()
   call has a length greater than 32765 bytes and the server
   that the application is connected to does not support a
   maximum statement size greater than 32KB, SQLPrepare() or
   SQLExecDirect will fail with SQLCODE -30005 and
   SQLSTATE 56072.

2. The CCSID precompiler option specifies the CCSID in which
   the source program is written.  Since all ODBC DBRMs are
   coded in CCSID 1047, they will be precompiled with the
   CCSID(1047) option.

   The NEWFUN precompiler option indicates whether to accept
   the syntax for DB2 Version 8 functions. A DBRM precompiled
   with NEWFUN(YES) can be bound only with Version 8 and later
   releases, even if the DBRM does not use any Version 8
   syntax.  ODBC users need to be able to find ODBC DBRMs to
   DB2 for z/OS Version 7 and below, therefore all ODBC DBRMs
   will be precompiled with NEWFUN(NO).  A DBRM precompiled
   with NEWFUN(NO) can be bound with any release of DB2 for
   z/OS, including DB2 Version 8.