Re: INDEX VS Logical File

Hi Mónica,

without seeing the images, the short answer is yes - a SQL index can be
set on substrings or other expressions of field. You can even select/omit
rows.

If you like, I can send some examples tomorrow.

HTH
Daniel

Von meinem iPad gesendet

Am 18.01.2023 um 17:48 schrieb Mónica Anastácio <

monicaanastacio@xxxxxxxxx>:

it's possible to do in index key-expression a substring of a column

name?

[image: image.png]
[image: image.png]
[image: image.png]

I have this in logical file
[image: image.png]
and after conversion creates this
[image: image.png]
--
Mónica Anastácio
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.