Re: 2. Re: How to compress data in RPGLE and save it in a file and

> Mohammad wrote:
> Sorry for not explaining what I wanted.
>
> We are expecting around one million orders a day, now some how on daily
> basis we need to archive this data and be able to use it as needed.
>
> Our thinking is that we will store the lookup data in regular file layout
> (index file), which will be used to search records but rest of the data
will
> be in compress format or files.  User can search the records using Index
> file and then we can uncompress the required data and use it.
>
> I can easily do it on PC platform but wondering if there is any utility or
> functionality within OS/400 which can help us to do what we are trying to
> do.  Meaning save the disk space by compressing it and also be able to
> recover data from compress mode within seconds.
>
> Any idea how to solve this issue?  It's all regular data
(numbers/strings).
> For one order we have 100s of files and there are 100s of fields in each
one
> of them.  Don't ask why we have so many files and fields.  (FYI: It's all
> custom development of many years). We would like to compress this data by
> order number so that we can easily retrieve it.


Mohammad,

You can get a ZIP utility for the iSeries, requires V5R1 or higher:
http://www.pkware.com/news_events/press_releases/2003/100603-iz5-6.html

Why not store the archived order data as ZIP'ed XML document(s) in a folder
in the IFS?

This would require that you engineer a DTD(s) or Schema(s) that takes into
account all of the fields currently stored in your hundreds of fields and
files, and write code that would be able to create/extract the data from the
XML document(s).

It would be a challenge, but doable.  I would love to work on a project like
this...

By the way...
next time you post a reply to messages that you received in digest mode, you
should cut and paste only the pertinent parts of the messages from the
digest and put them in your reply, rather than reply with the whole digest
thread.

Steve Landess
Austin, Texas
(512) 423-0935