|
- No, The phone number is break up into segments in physical file. - I'm trying to avoid using RPG io opcodes because that require condition logic on which file to read from when loading subfile. Using sql, I will only need to do condition logic when constructing the select statement. The loading of subfile procedure, simply do fetch by cursor and will not need to worrying about which logic file to read from. - ***Note statement below might not be true. I think where clause is what cause the sql engine to do re-index. The || column itself doesn't really cause it to re-index. As Birgitta has explained, when || each segment together to do the comparison, the sql engine is not able to use the existing logical due to column attribute is not matching. -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael_Schutte@xxxxxxxxxxxx Sent: Friday, June 02, 2006 9:10 AM To: RPG programming on the AS400 / iSeries Subject: RE: Constructing Sql to position phone number that breakup inareacode,prefix, suffix and extension Lim, I know that you stated that the file has a logical file that breaks down the phone number into segments. But I was wondering, is the number stored as a whole on the file. In order to get what you want, I believe that you are going to need that. The other option is to do a different process for each sorting option available. If equipment was entered, ... read a logical file by equipment. Else if telephone number, ... breakdown the number so that you can SETLL with the logical you mentioned EndIf Unless there's something I'm missing... because the || of columns will result in reindexing... excuse my idiocy but that's true for the WHERE clause too, right? Michael Schutte Michael_Schutte@b obevans.com Sent by: To rpg400-l-bounces@ RPG programming on the AS400 / midrange.com iSeries <rpg400-l@xxxxxxxxxxxx> cc 06/02/2006 09:57 Subject AM RE: Constructing Sql to position phone number that breakup inareacode,prefix, suffix and Please respond to extension RPG programming on the AS400 / iSeries <rpg400-l@midrang e.com> No that will not work because let's say that the number 614-555-5555 was entered. You will get ... 614-555-5555 614-555-9999 714-555-5555 714-555-9999 714-999-9999 etc but you will not get 714-111-5555 714-555-1111 etc Since 714 is greater than the 614, from what I understand, she does want those to be returned. Michael Schutte jmichael.smith@ce rtegy.com Sent by: To rpg400-l-bounces@ rpg400-l@xxxxxxxxxxxx midrange.com cc Subject 06/02/2006 09:43 RE: Constructing Sql to position AM phone number that breakup inareacode, prefix, suffix and extension Please respond to RPG programming on the AS400 / iSeries <rpg400-l@midrang e.com> Where AreaCode >= Substr(:InputNbr, 1, 3) And Prefix >= Substr(:InputNbr, 4, 3) And Suffix >= Substr(:InputNbr, 7, 4) And Extention >= Substr(:InputNbr, 10, 3) Maybe ------------------------------------------------------------------------ ------ This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@xxxxxxxxxxxx ======================================================================== ====== -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx 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@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx 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@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
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.