• Subject: Re: Question about VARYING fields in RPG IV
  • From: JFinney@xxxxxxxxxxx
  • Date: Thu, 1 Jul 1999 09:24:37 +0200

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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].