RE: Question on buffer lengths vs SQL reported lengths

Is there a SQL view that shows the DSPFFD field lengths and buffer lengths? When I pull the actual binary data using DISPLAY_JOURNAL it is infact 10 bytes.


-----Original Message-----
From: Carel <coteijgeler@xxxxxxxxx>
Sent: Thursday, October 10, 2019 12:22 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Question on buffer lengths vs SQL reported lengths

The 4 with SQL is storage size in bytes.

The 10 in DSPFFD is display size in bytes.

Kind regards,

Carel Teijgeler


Op 10-10-2019 om 19:18 schreef Matt Olson via MIDRANGE-L:

Anyone have any ideas why if I do a "select * from qsys2.syscolumns where table_schema='yourschema' and table_name='tablename'" and you look at the STORAGE or LENGTH columns for a DATE field it says "4"

But when you do a DSPFFD against the same file you will see the field length is 10.

I've noticed a discprency on TIME fields as well. Where the
qsys2.syscolumns STORAGE and LENGTH columns say "3", but DSPFFD shows
8

--
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@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com