RE: Index on a partial field

I should have mentioned that the field is a DBCS and you can't do a SST
in a logical file. 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Holden Tommy
Sent: Thursday, September 21, 2006 11:47 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Index on a partial field

DDS Logical can do it...  ;-} 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wes Reinhold
Sent: Thursday, September 21, 2006 10:35 AM
To: RPG programming on the AS400 / iSeries
Subject: Index on a partial field

 

Is it possible to create an index on part of a field?

Ex:  CREATE INDEX STATICF82/ESPIX ON STATICF82/ESP substr(PRKEY,36,8)

That doesn't work, but is there some methond that would?

I520, v5r3

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