expsysdb

Overview

Export system data

Syntax: expsysdb -dops ProductLine DumpFile [SystemCode...]

d - Use System Delivery Files
o - Use Owned By Files
p - Use Program Files (Default)
s - Use System Files

Here is a typical usage for an export by system code:

expsysdb -s productline filename hr
expsysdb -s productline filename pr

The flipsip of expsysdb is impexp

To get a single table

The first 10 bytes of the expsysdb file contain the table name, which is filled with blanks to use the entire 10 characters. Here is how I would recommend selecting a single table from the expsysdb file, while ensuring that you get ONLY that file:

grep -i '^tablename ' expsysdbfile > tablename.expsysdb

The caret (^ means only select records that tablename in the first column. Putting a blank at the end ensures that you won't select records where the first part of the table name matches your pattern (such as the ACACCTCAT and ACACCTCATX pair that John mentioned).

2GB Limit

Lawson has a 2GB limitation on file creation. Call Lawson's Global Support Center for more information on how to use named pipes to bypass this limitation.