RE: Constructing Sql to position phone number that breakup inareacode, prefix, suffix and extension.

Also, the subfile program list from number starting from what user
entered on the screen. 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
Sent: Thursday, June 01, 2006 3:46 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Constructing Sql to position phone number that breakup
inareacode,prefix, suffix and extension.

That would cause a sql engine to reindex the file.  The response time
would not be acceptable.  It is a pretty big file, 22M+.  

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Michael_Schutte@xxxxxxxxxxxx
Sent: Thursday, June 01, 2006 2:44 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Constructing Sql to position phone number that breakup
inareacode, prefix, suffix and extension.

Are you looking for something like this???

Select areacode || prefix || suffix || extension from telephonefile
where areacode || prefix || suffix || extension = :phonenumber

Michael Schutte

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