When running a COBOL code through gpre:
EXEC SQL
SET DATABASE DB2 = "/Db/Iccb/a1.db";
USER '******' PASSWORD '********'
END-EXEC.
EXEC SQL
DECLARE C CURSOR FOR
SELECT DISTRICT, COLLEGE FROM DB2.CAMPUS
WHERE FICE = :FICE
END-EXEC.
EXEC SQL
OPEN C
END-EXEC.
EXEC SQL
# Error on the following line "column count and number of INTO list
host-variables unequal
# FETCH C INTO :CAMPUS-DIST, :CAMPUS-COLL
END-EXEC.
MOVE SQLCODE to D-SQLCODE.
EXEC SQL
CLOSE C
END-EXEC.
This should be pretty straight forward but am I missing something here. This
very code has been working for over 15yrs. Having to re-compile everything for
new system. Trying to get our first code through the pre-processor. Just
upgraded to Firebird 2.5 64bit.
Any ideas?
