Here is a paste from the V7 Installation Guide section on migration
to V7 on incompatibilities.
Support for large objects: The following incompatibilities result
expansion of the SQLDA to support large objects:
o Because of the additional data types supported after Version 5,
language statements generated by the precompiler for each SQL
include a larger parameter list. As a result, the size of the
that results from compiling the output of the precompiler
increase varies according to the number of host variables that
specified in an SQL statement.
o INCLUDE SQLDA generates additional fields for applications
assembler, PL/I, C, and C++ (see Appendix C of DB2 SQL Reference
descriptions of these fields). If an SQL application program
written in one
of those languages defines a name that matches any symbol in the
fields, and the program also uses INCLUDE SQLDA, then that program
operate, assemble, or compile correctly.
Basically, the structures we have been using for 20 years can't
hold all of
the bits we need, and the SQLDA did not change for about ten
the big increase came in V6.
On Wed, 15 Jan 2003 13:57:46 -0000, Chris Bowen
<[login to unmask email]>
>We found that the way the DB2 precompiler handles COBOL host
>changed between V5 & V6.
>From V6 all host variables are passed backwards and forwards
via an SQLDA
>block which the precompiler builds into working-storage. This
>implications for program sizes both because of the effect on
>and because of the extra moves needed to populate the SQLDA for
>statement involving host variables. Programs with a lot of SQL
>program-logic code or that use very large numbers of host
>likely to grow significantly.
>I haven't been able to find any documentation that is specific
>change but I guess that the V6 requirement for all host
variables to be
>prefixed with ':' had the same driver.
>Macro 4 plc
>From: Peter Zillo Jensen [mailto:[login to unmask email]
>Sent: 15 January 2003 12:37
>To: [login to unmask email]
>Subject: Output from DB2 for Z/OS version 7 precompiler VS
>Do anyone have experience with the code generated by the V7
>versus V5 precompiler.
>We have a customer that sees an increase of generated code
lines by 240%.
>Making the resulting load module approx 25% larger.
>Is there some options that we have overseen?
>Regards, Peter Zillo
the DB2-L webpage at http://listserv.ylassoc.com.
owners of the list