Previous Topic: -274 - CANNOT CREATE AN INDEX ON A VIEWNext Topic: -276 - SQLDA SPECIFIES n FEWER HOST VARIABLES THAN IN STATEMENT


-275 - SQLDA SPECIFIES n MORE HOST VARIABLES THAN IN STATEMENT

Explanation

The number of input host variables and SQLDA entries is different.

The SQLSTATE that equates to this SQL return code is 53S34.

User Response

The system interfacing between your program and the Multi-User Facility (DQ, DDOL, IDEAL, SQL, SQL COBOL Preprocessor, and so on) is responsible for sending a SQLDA with the same number of host variables as declared at bind-time. However, you may have executed an old version of your program. Check to ensure the program is linked into the proper library and if it is executing from CICS, that the new version is being executed.