RE: SQL grouping

["Chris Payne" <CPayne@xxxxxxxxxxxxxxx>]

There is no easy way to do that using SQL.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
Sent: Thursday, January 13, 2005 10:29 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL grouping

David, let me know if this should not post here.
 
I have a file that contains data looks something like this:
 
Phone#         Phone Ext#    Feature
1234567980      1234567       ABC   
1234567980      1234567       DEF   
1234567980      1234567       XXX   
1234569999      9994567       GXX   
1234569999      9994565       XXA   
6019991234                    ABC
 
 
Is there a easy way to transform it to look like this using interavice
SQL if I know that the most feauture an unquie phone+ext can have is 8?
 
Phone#      PhoneExt#     Feat1    Feat2    Feat3    Feat4    Feat5
Feat6    Feat7    Feat8            
1234567980   1234567       ABC      DEF      XXX
1234569999   9994567       GXX      XXA 
6019991234                 ABC 
   
 
-- 
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.