Re: Question about variable length fields

[Buck <kc2hiz@xxxxxxxxx>]

James H. H. Lampert wrote:
> Brian Johnson wrote:
> > Care to try a little SQL?
> >
> > update file-name set field-name = trim( field-name )
> >
> > If you have SQL developer kit installed, you can run that statement in
> > STRSQL.  Otherwise put it in a source member and run with RUNSQLSTM.
>
> And if you have no front-end for SQL at all, the equivalent RPG Cycle
> program isn't going to be much longer.

No disagreement there but I think it profitable to note that writing a
command line utility to execute SQL statements like this one have been
in the public domain for quite a while.  There's one in the FAQ, for
example.
  --buck