Subject Re: Fetch - Embedded sql using COBOL - gpre error
Author Kevin E
Found out that gpre isn't compiled after versions 1.5. Have a consultant recompiling firebird 2.5.2 to get the gpre back. Should be back to normal by tomorrow.

--- In firebird-support@yahoogroups.com, Frank Schlottmann-Gödde <frank@...> wrote:
>
> 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
>