IC300 archive files

Does anyone else run IC300? Unlike all the other purge programs, it creates sequential archive files rather than CSV files. We're wondering how we'd access the archived data if we ever needed to.

Find more posts tagged with

Comments

dan-linzy

We do execute the IC300 in an after business hours - weekend usually.

Take a backup of your data bases
Execute IC300 process
Save off the pdf print file with the record purge counts
Save the output work files

You may reference the Lawson Enterprise Applications Purge Programs Reference Guide for more information

I would strongly recommending executing this in your test environment and have your business involved. Further, have the business approve to execute the process in production.

Legacy Contributor

Yes, but have you ever needed the data? Is there any way other than writing a 4GL COBOL program?

dan-linzy

Have worked at 2 companies with Infor S3 and neither company has needed to restore the Oracle Tables or SQL Tables to get back to the data.

The business departments always approve the purge results from the test environment before executing in production and therefore are accountable of the result set in production.

Why would you want to take the sequential data and create a program to add it back to the database tables when you have a back up of those affected database tables?

Legacy Contributor

I don't want to add it back to the Lawson tables, I just want to be able to tell the business departments that we can access the data in case we need to report on it for some reason. We can easily load the purged CSV files from the other purge programs into our datawarehouse but do not want to go through the effort to do the same with the IC300 sequential files that we likely will never need. Restore from backup is the entire database, not single table.

ION_API_Flow_CSF_and_AWSS3.zip

Legacy Contributor

We do not use IC module in our company, however based upon the workdef definition of the sequential file, it sounds like it is a flat file with fixed length records that do not have a carriage return. There are commands within Lawson that will convert either a sequential file to sequential file with carriage returns or remove returns on to make a sequential file. I believe you would use the cnvexp command with -f option and redirect the output to a new file. For example: If the file output was called IC300.txt and the record length is 80, then your command would be as follows (assumption here is that you are in the directory where the sequential file is located):

cnvexp -f IC300.txt 80 > newIC300.txt (this would have the carriage return or line feed depending on your system.

To add carriage returns:
cnvexp
Usage: To convert an export sequential file to have return characters
Syntax: cnvexp -f ExportFile RecordSize
f - Output fixed length records

To remove carriage returns:
cnvimp
Usage: To convert an import line sequential file to a sequential file
Syntax: cnvimp ImportFile RecordSize

Once you have the file in a carriage return or line feed, you should have an easier time importing the fixed length file (assuming you know the IC300 layout).

Copyright © 2025 Infor. All rights reserved.