If it is a physical file or a SQL table, the maximum record length is 32,740
Byte. No restriction to something around 1200!
It cannot be a Db2 for i restriction.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg
Wilburn
Sent: Thursday, 13 July 2023 17:35
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: TrustedLink for i User File Definition limitation?
We've used Tli for 20+ years for EDI. I went to expand our PO Header file
today - adding two fields to the end. We received a message when trying to
update the associated User File Definitions (UFDs). The message indicated
that it exceeded the maximum record length of 1024. The file previously had
a record length of 1018.
TLi tech support is telling our EDI coordinator that this is an "IBM
limitation" related to "user spaces"... they cited this KB article:
https://www.ibm.com/support/pages/record-length-table-exceeds-page-size-limi
t
Funny thing is that we have another file for Warehouse Shipping Order from
2007 that has a record length of 1131 - we've used that extensively over the
years.
I had to remove the two new fields and recompile everything again.
So I'm not going to let this go... that's just my nature. Support is not
going to just blame this on IBM limitations - my guess is that it's a
limitation with how they implemented the corresponding user spaces - I just
know very little about it.
Wondering if anyone else with TrustedLink has ever encountered this issue?
TIA,
Greg
[Logo]<
https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<
http://www.totalbizfulfillment.com>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
midrange.com
