|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.