Re: SQL010 - length of a table's record

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Darryl,

The row size limit (V5R4) is 32740 if a VARCHAR column is specified. Could
you split your data into two or more tables? What about using LOB colunms?

Regards,

Luis


On Wed, Aug 10, 2016 at 11:39 AM Darryl Freinkel <dhfreinkel@xxxxxxxxx>
wrote:

> Something I have not had to deal with before.
>
> I have to create a table that has about 400 fields which are mostly VARCHAR
> and of length 100 to 2000 each. So I get SQL0101.
>
> I have always heard that the table sizes can go into the yoda byte sizes
> but never a record length maximum.
>
> For now I have reduced the field sizes to 50 chars to get passed the issue.
>
> This is a V5R4 system.
>
> Is there a work around or different way to use these huge record sizes?
>
> TIA
> --
> Darryl Freinkel
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.