That sounds like it. However I am on V5R4 on this one lpar and this is
happening:
DSPFFD WALDEN
MYKEY BINARY 9 0 4 1 Both MYKEY
MYDATA CHAR 5 5 5 Both MYDATA
MYDATE DATE 10 10 10 Both MYDATE
I added the date field later.
D walden e ds extname(walden)
In debug eval mykey and mydata return values. However eval mydate returns
CPF7E12 Identifier does not exist. Which, since the field was added and
the program not recompiled makes sense.
C/EXEC SQL
C+ Declare C1 cursor for
C+ Select *
C+ from walden
C/END-EXEC
...
C/EXEC SQL
C+ Fetch C1 into :walden
C/END-EXEC
Right after the fetch SQLCOD and SQLSTT are both zeros. I even F10'd a
couple of extra lines and checked again.


Rob Berendt

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].