Re: JDBC columns blank

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

If you think about it, it makes perfect sense.  "Blank" does not mean 
that the string is empty, it means that it is filled with blanks (space 
characters).

I suppose if you've spent many years working with fixed-length strings 
(that cannot be empty, because they have a fixed length) you might start 
thinking of blanks as being the same as nothing -- but its definitely 
time to 'unlearn' that if you're working in other languages!!  (Heck, 
its even time to 'unlearn' that if you're working in only RPG -- past 
time, in fact.)

IMHO, the way you did it (myVar = '') is the best way, everyone will 
understand it no matter what environment they're used to.




On 11/22/2016 11:35 AM, Justin Taylor wrote:
> That's what I did here.
>
>
> -----Original Message-----
> From: Charles Wilt [mailto:charles.wilt@xxxxxxxxx]
> Sent: Tuesday, November 22, 2016 10:26 AM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: Re: JDBC columns blank
>
> The other way to "clear" a variable length field is
>
> %len(myVar) = 0;
>
> I think that's really all the myVar = '' does anyway.
>
>
>
> Charles