Midrange News for the IBM i Community


Posted by: raja sekhar
How to reduce storage space of a large file with 3000+ fields
has no ratings.
Published: 05 Mar 2015
Revised: 01 Apr 2015 - 1351 days ago
Last viewed on: 11 Dec 2018 (2413 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

How to reduce storage space of a large file with 3000+ fields Published by: raja sekhar on 05 Mar 2015 view comments(12)

We have a file with around 3300 fields with 3000 fields as packed. This file is eating up storage and reaching the limits of 1tb. Out of these fields, many fields remain un populated. I saw VARLEN is useful to reduce storage space but it is meant only for CHAR type. Please advise if there are any other approaches by which we can reduce storage space for this file.

Any help is greatly appreciated

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS