Question on buffer lengths vs SQL reported lengths -- MIDRANGE-L

Subject: Question on buffer lengths vs SQL reported lengths
From: Matt Olson <Matt.Olson@xxxxxxxx>
Date: Thu, 10 Oct 2019 17:18:11 +0000
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@lists.midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.lists.midrange.com>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

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

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Question on buffer lengths vs SQL reported lengths , Carel
Re: Question on buffer lengths vs SQL reported lengths , Jon Paris

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.