On 30.07.2013 23:29, Kevin E wrote:

> 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?

Looks like it should work.

As gpre and COBOL aren't widely used anymore, this could be a bug in gpre.

What version did you use before?


fsg

--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets." -
J.K. Rowling