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