RE: SQL Problem -- RPG400-L

Mark, are you using DDS to add a new field?

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.

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



Phil,

If a field is inserted into the table which changes relative positions of
your DS fields, without recompiling to get the new external definition, the
potential is there for a decimal field to receive invalid data.


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



                    "Phil"
                    <sublime78ska@yah        To:     <rpg400-l@midrange.com>
                    oo.com>                  cc:
                    Sent by:                 Subject:     RE: SQL Problem
                    rpg400-l-admin@mi
                    drange.com


                    09/14/01 11:35 AM
                    Please respond to
                    rpg400-l






Mark,

how does using * versus listing all the fields on the select affect whether
you're going to get a data decimal error on a fetch?

If I change the datatype of a field then I have to recompile.  Regardless
of
how I define the select.  Are you saying if I insert a field between
existing fields?  So drop table /create table as opposed to alter table?

Phil

>
>
>
> Can anyone smell Decimal Data Error?
>
>
> 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
>
>
>
>                     "R. Bruce
>                     Hoffman, Jr."            To:
> <rpg400-l@midrange.com>
>                     <rbruceh@attgloba        cc:
>                     l.net>                   Subject:     Re: SQL Problem
>                     Sent by:
>                     rpg400-l-admin@mi
>                     drange.com
>
>
>                     09/14/01 10:15 AM
>                     Please respond to
>                     rpg400-l
>
>
>
>
>
>
> -----Original Message-----
> From: Phil <sublime78ska@yahoo.com>
> To: rpg400-l@midrange.com <rpg400-l@midrange.com>
> Date: Thursday, September 13, 2001 5:59 PM
> Subject: RE: SQL Problem
>
>
> >Alright Dr. Smith!
> >I have two questions:
> >1. How is it different (as far as level checking) from Mark's code?
>
> I am not sure what you mean, but in SQL, you should select the fields
that
> you want/need and ignore the fields that you don't want/need.
>
> >2. How do you make the pgm fail with a level check error?
>
>
> In SQL, you don't. SQL and relation database technology is designed to
> isolate I/O from the physical structure of the data. The level check
> technology is based on native I/O where the I/O is related
> directly to, and
> reliant upon, the physical structure of the data. These are
> checked at open
> time. SQL does no such checking as the * is really a
> "convenience" item and
> not meant to be the programming construct for embedded applications.
>
> >Normally I use an external ds for my hostds.
>
>
> And you can still do this and maintain isolation, just so long as
> you don't
> then ask for all the fields (*) to be inserted into that structure. The
> field definitions are what you are after in that case and will apply, but
> the structure of the record as a whole is ignored.
>
> ===========================================================
> R. Bruce Hoffman, Jr.
>  -- IBM Certified Specialist - AS/400 Administrator
>  -- IBM Certified Specialist - RPG IV Developer
>
> "America is the land that fought for freedom and then
>   began passing laws to get rid of it."
>
>      - Alfred E. Neuman
>
>
>
> _______________________________________________
> 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.
>
>
>
>
>
> _______________________________________________
> 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.
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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





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