RE: SQL Problem

["Mangavalli, Ramanujam" <RamM@xxxxxxxxxxx>]

I think I agree with you there. That sounds more logical even though I
haven't tested it myself.
For us, it hasn't been that much of a problem because we use SQLDA and
pointers using ILERPG. Or maybe we have not yet reached a point where we
need to know the structure at compile time.


-----Original Message-----
From: MWalter@hanoverwire.com [mailto:MWalter@hanoverwire.com]
Sent: Friday, September 14, 2001 1:46 PM
To: rpg400-l@midrange.com
Subject: RE: SQL Problem



Regardless of how you change the table, DDS or SQL, if you change the
structure of the table, and the corresponding host DS is not changed. You
run the risk of contaminating a field in the data structure. Maybe adding a
field to a table was a bad example. Changing the field length of a field
might be a better one. Here is a scenario.

You have a table, say: CharField1 10, CharField2, 10, ZoneField1 5,0
ZoneField2 5,0.
You write a program specifying your table as the EXTNAME in your hostds.

Now you change the length of CharField2 to 15. You don't compile the
program. Your host ds still says that CharField2 is 10. When the record is
fetched into HostDS, wouldn't ZoneField1 contain character data?

Maybe I'm wrong about this. I haven't tried to prove it. If I am, by all
means let me know.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040

<SNIP>

You can use ALTER TABLE in SQL to add a field. I THINK,  if  you add a
field
using ALTER TABLE and leave it null capable, your existing programs should
continue to run without any problems.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.