Re: substring in MAPFLD (OPNQRYF)?

[Carel Teijgeler <teygeler@xxxxxxx>]

Raja Rajendren wrote:

> Dear All,
>
> I need to extract a substring of keyfield in OPNQRYF Command (CL) using MAPFLD
> property and also arrange the records in MAPFLD order.
>
> Can u help me in this regards.
>
> Regards,
> Rajendren K. G.
> TMSI. India.
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

Rajendren,

You can do that, but you have to do a few things first:
1) Create a dummy file in which you have the mapfields named and use that on the
FORMAT parameter
2) you can BIF %substring on a MAPFLD parameter on character fields, for numeric
fields use it in conjunction with BIF %digits
3) Define on the parameter KEYFLD the value *MAPFLD

Like
OPNQRYF file FORMAT(dummy) KEYFLD(map1 *MAPFLD) MAPFLD(map1 '%substring(field 4
6)')

Hope this will help.

Carel



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---