RE: OPNQRYF

["Bob Cozzi \(RPGIV\)" <cozzi@xxxxxxxxx>]

I suppose &SONO is a numeric variable. You cannot concatenate a numeric
variable. Only character variables can be concatenated. If we had the CL
equivalent of the RPG IV %CHAR() built-in function, you could do it
in-line. But since we don't you have to first most the field's value to
a character field, then do the concatenation.

Bob Cozzi
cozzi@rpgiv.com
Visit the new on-line iSeries Forums at: http://www.rpgiv.com/forum

> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]
On
> Behalf Of Hilda Shing
> Sent: Friday, August 24, 2001 1:56 AM
> To: RPG400-L@midrange.com
> Subject: OPNQRYF
>
> Hi,
>
> Could someone help me to understand the reason and
> means of solving this problem. I have look thro the
> mails in the forum to have it changed as per my
> understadning but somehow, the error message is saying
> on the invalid type . &SONO is a numeric variable and
> SORD is a numeric field from a file.
>
> 524-
> 551- /*
>     553- CHGVAR     VAR(&QRYSLT) VALUE('SORD *EQ "'
> *CAT &SONO +
> 554  *CAT '"')
> * CPD0712 30  Operand  does not have valid type for
> operator.
> * CPD0711 30  Operands in expression not same type.
>
> 559-
> 564-  OPNQRYF    FILE((FSO)) QRYSLT(&QRYSLT)
> KEYFLD((SORD))
>
> Any help is appreciated.
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Y! Pages - Search or browse for business listings.
> http://yp.yahoo.com.sg/
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com