× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



This is the info (specifically looking at size) of a file that I duped and added a record to.
Source Creation Last Change Deleted
Member Size Type Date Date Time Records Records
CDRMISCP 12288 07/29/13 07/29/13 09:35:08 1 0

This is the info (again, look at size) of a file that had millions of records, where I deleted all but the first, then ran RGZPFM.
Source Creation Last Change Deleted
Member Size Type Date Date Time Records Records
CDRMISCP 2473984 07/21/13 07/29/13 09:31:56 1 0

The file was created with SQL.
File definition:
EditID INTEGER NOT NULL DEFAULT 0,
CDRSeq# INTEGER NOT NULL DEFAULT 0,
MiscCode Char (5) NOT NULL DEFAULT ' ',
MiscValue VarChar (100) ALLOCATE(30) NOT NULL DEFAULT ' ',
StmDte Date NOT NULL DEFAULT '0001-01-01'

Is there a reason why the given information for the 2nd file has the file size so much larger?

We're on IBM i 7.1.

Thanks,

Kurt Anderson
Sr. Programmer/Analyst at CustomCall Data Systems
phone: +1 608 274 3009
web: www.customcall.com<http://www.customcall.com/> | email: kanderson@xxxxxxxxxxxx<mailto:kanderson@xxxxxxxxxxxx>

A Division of Enghouse Systems Ltd.<http://www.enghouse.com/> (TSX:ESL)


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.