Re: JDBC columns blank

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