RE: Variable length fields

["Pete Helgren" <pete@xxxxxxxxxx>]

Don, Scott, James,

Cool! I was hoping it would be simple, and your answers fulfilled that hope.
The pointer on performance was appreciated, Scott (despite the attempt at
humor).

Thanks, compiling as I write.   YES!!!

Peter Helgren
Value Added Software, Inc
801.581.1154 x202

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James H H Lampert
Sent: Thursday, January 27, 2005 12:19 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Variable length fields

> 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


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.