Re: Question about VARYING fields in RPG IV

[JFinney@xxxxxxxxxxx]

Hi Ravi

By defining the variable as 25A with the keyword VARYING, you are
essentially defining it with a maximum length of 25 but the length of the
variable itself could be smaller than that. I don't know if this will solve
your problem but try changing the length of the varying variable item prior
to executing your SQL statement. By defining a field to hold the length of
a variable, that could then be used to set the length of ITEM.

LEN                     S              3 0

EVAL   LEN =  %LEN(%TRIM(Character_Field))
EVAL   %LEN(ITEM) = LEN
EVAL   ITEM  = Character_Field

By doing this, the length of ITEM will always be as long as the data it
will contain.
Perhaps there is a better way to do this but this is the way I'm accustomed
to.
Hope it helps.

Regards
John.


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *