Walden,

Assume that the program is not recompiled. And, a field is added at the
end.

Starting with this:
CREATE TABLE ROB.WALDEN (
MYKEY INT NOT NULL AS IDENTITY,
MYDATA CHAR ( 5) NOT NULL,
PRIMARY KEY (MYKEY))

Then a little SQLRPGLE program with this:
D walden e ds extname(walden)
...
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
...
works fine. But, if you do this
ALTER TABLE ROB.WALDEN ADD COLUMN MYDATE DATE
and run the program again, (without recompiling)
Wait! The darn thing worked! I swear it used to work in early versions
of the os but then they came out with a release that busted that.

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].