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.
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