RE: Upgrading to V5R3

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
statement.

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

Thanks/regards
Neeraj




-----Original Message-----
From: bpcs-l-bounces+neeraj.sarougi=cgi.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+neeraj.sarougi=cgi.com@xxxxxxxxxxxx] 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