lessardj
Well Known Member
Has anyone had problems with R92TAM since upgrading to V5R4? We did all the usual deletion of SQL packages after the upgrade, and have tried updating the client access version on the build PC. But, when building global tables, the iSeries is reporting a SQ0030 error on what looks like every record. Everything seems to build OK, but the end result is the visual assist flashlight is missing in several places in our applications, indicating a bad DDICT file perhaps. There is no pattern to where the VA shows and where not - seems random. The iSeries error follows:
SQL0030 Information 00 03/12/08 14:33:25.280584 QSQRUN2 QSYS *STMT QSQRUN2 QSYS *STMT
From user . . . . . . . . . : MPBDEV
From module . . . . . . . . : QSQFETCH
From procedure . . . . . . : CK_DEBUG
Statement . . . . . . . . . : 15431
To module . . . . . . . . . : QSQFETCH
To procedure . . . . . . . : CK_DEBUG
Statement . . . . . . . . . : 15431
Message . . . . : Number of host variables less than result values.
Cause . . . . . : The number of host variables specified in the INTO clause
is less than the number of result values. If the program is run, only the
variables specified will have values assigned to them. Recovery . . . :
If all values should be received, specify the proper number of host
variables. Precompile the program again.
SQL0030 Information 00 03/12/08 14:33:25.280584 QSQRUN2 QSYS *STMT QSQRUN2 QSYS *STMT
From user . . . . . . . . . : MPBDEV
From module . . . . . . . . : QSQFETCH
From procedure . . . . . . : CK_DEBUG
Statement . . . . . . . . . : 15431
To module . . . . . . . . . : QSQFETCH
To procedure . . . . . . . : CK_DEBUG
Statement . . . . . . . . . : 15431
Message . . . . : Number of host variables less than result values.
Cause . . . . . : The number of host variables specified in the INTO clause
is less than the number of result values. If the program is run, only the
variables specified will have values assigned to them. Recovery . . . :
If all values should be received, specify the proper number of host
variables. Precompile the program again.