Re: [Re: substring in MAPFLD (OPNQRYF)?]

[Raja Rajendren <kgrajen@xxxxxxx>]

Thank you Carel.  My problem got solved.

Regards,
Rajendren K. G.

Carel Teijgeler <teygeler@bart.nl> wrote:
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
+---


____________________________________________________________________
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
+---