Re: Variable length fields

["James H H Lampert" <jamesl@xxxxxxxxxxx>]

> I have primarily worked with PF's and DDS on the iSeries and done a
> little bit of SQL (create collection, create table, alter table, etc).
> What data type would work best here?  Looks like  varchar would work.
> Would that recommendation change if you were using RPG to access the
> data?

"Varchar" is certainly easy enough to deal with, and it's supported in DDS
as well as SQL. Off the top of my head, I don't remember whether ILE RPG
supports it directly or not, but if not, you should be able to get it as a
character field with a length equal to the maximum length + 2 (for a
2-byte length prefix). At least, that's what such fields look like in OPM
MI.

--
JHHL