RE: Returning Record Sets from SQLRPGLE Web Services

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