Several vendors have archiving software already available for BPCS.
You can find info on many of them, by searching BPCS-L archives.
I use the one from UPI, called Locksmith.
We only have the part which deals with transactions.
There's more we have not got, which deals with master files.

You are probably aware that a lot of BPCS files have pointers to records in
other files: order #; sequence #; line #. When removing records from this
system, because they are ancient; while keeping other records still in the
system, you do not want to mess up how BPCS correctly accesses the records
you decide to keep. The vendors with their archiving systems have already
worked this out.

This past weekend I used Locksmith to archive a pile of completed customer
orders, after which I ran their program which recovers disk space, which was
consumed by the now gone records. You are probably aware that BPCS files
eat more disk space, as needed, but never return it. This is part of the
responsibility of archiving software.

The basis for our archiving includes orders which have been fulfilled, and
this happened over a year ago. UPI's Locksmith lets us choose which date(s)
to use to determine this, and correctly gets the right records. I am sure
the other vendors likewise have similar solutions.

Maybe you want the data extracted to archives by a methodology where you can
access them again for some future need.

I recently had a hard disk crash, wiping out approx 300 Meg of stuff on my
personal computer. I had been working on some Word documents, which I had
uploaded to Internet share sites in PDF format, before my unexpected crash.
I now have on my PC, software which copies from Word doc to PDF, and from
PDF to Word doc. However, what I have so far, does not recognize footnotes
as being incremented, and there are other problems. So while I am able to
recover my doc so Word can edit again, there are hassles, so I must look
into alternative PDF to Word software to find out which has the least

Likewise, in your reality, you want to have a process which is reversible,
without introducing hassles when you try to access your archived records.

UPI Locksmith copies the archived records to a separate library, where they
continue to be in BPCS format.

When moving iSeries data to Microsoft and other formats, there are add-ons
from Microsoft, or those other vendors, to facilitate this. Some of these
add-ons come free with Client-Access Operations-Navigator, or available for
customers of Microsoft Office, PDF vendors, as part of a paid package, some
of them cost extra. MIDRANGE-L may be a better place to ask about such

Al Mac (WOW) = Alister William Macintyre
2012 April I had a serious PC melt down, from which I am still recovering
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Margareth Sere
Sent: Tuesday, May 22, 2012 4:48 AM
To: BPCS ERP System
Subject: [BPCS-L] Multi-language BPCS data transferred as CSV in

Dear ALL,
We are on the process of data archiving BPCS data. As there are
volumes of data files to archive, we wanted to create a CLP program to
handle this.

Can anyone help share commands I need to use in order to create a
shared PC document file in QDLS in CSV format with field names as
column headings that can handle data coming from BPCS data with
language characters from Korea, Simplified Chinese, and Traditional
Chinese. We have different BPCS environment for each affiliate we
have. I have never tried this before as I usually work on 1-2 files
and just use iSeries Data Transfer, this time it will be used on 6

Thank you so much for your help and advise.


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