One of the potential areas are using of embedded SQL's. ...Error
description "Number of host variables less than result values."

Versions prior to V5R3 don't return any errors while using declare
cursors and fetch statements when x number (suppose variables a, b, c,
d) of variables are declared in declare cursor statement, but less
number of variables used in fetch statements (lets say a, b). This is
obviously bad coding, but many people used to code this way.

Solution for this problem is to identify the potential areas where
Declare and fetch statements have been used and verify if there are some
sort of discrepancy in # of variables used between the declare and fetch

For fast fixes, you can contact IBM site to apply PTF for this.


-----Original Message-----
[] On Behalf Of
Daniel Wilkins
Sent: Saturday, December 03, 2005 12:11 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Upgrading to V5R3

We are on BPCS 6.1.01 and are going to upgrade to V5R3 next year. Where
do we need to look for potential problems? We do not have support with
SSA. Has anyone upgraded to V5R3 on the same version as we are on and if
so what type of problems did you have?


Daniel Wilkins
IT Department
Suzuki Mfg of America
706.378.2100 ext 3552


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.