Preparing to Use the Batch Export Tool or the Batch Import Tool :: SAS(R) 9.3 Intelligence Platform: System Administration Guide, Second Edition

Perform Standard Steps to Prepare for Promotion

The batch export tool and import tool require the same preparation steps as the Export SAS Package and Import SAS Package wizards. See Preparing to Use the Promotion Tools. Make sure that the user who is specified in the options has the appropriate credentials. See Ensure Appropriate User Credentials.

Set the DISPLAY Variable (UNIX Only)

If you are using the batch import or export tool on a UNIX machine, make sure that the DISPLAY variable has been set on the machine. To set the variable, enter a command such as the following:

export
                     DISPLAY=

machine-name

Set Global Options for the Batch Export and Import Tools

Editing the .ini Files to Set Global Options

In the .ini files for the batch export and import tools, you can set global options to override the default handling of certain object types. To set these options:

Go to the directory SAS-installation-directory/SASPlatformObjectFramework/9.3 and locate the files ExportPackage.ini and ImportPackage.ini.
Make a backup copy of the .ini file that you want to modify.
Open the .ini file in a text editor, and add a new Java argument for each option that you want to specify. For example:
```
JavaArgs_10=-Dsas.promotion.stp.includesourcecode=false
JavaArgs_11=-Dsas.promotion.columns.excludenewcolumns=true
JavaArgs_12=-Dsas.promotion.columns.deletetargetcolumns=true
```
Save the file.

The available options are described in the following topics.

Global Option to Include or Exclude Source Code Files for Stored Processes

The following global option applies to exporting or importing stored processes using the batch tools. You can set this option in both ExportPackage.ini and ImportPackage.ini.

-Dsas.promotion.stp.includesourcecode

specifies whether source code files are to be included when a stored process is exported or imported.

Specify -Dsas.promotion.stp.includesourcecode=false if you want source code files to be excluded when stored processes are imported or exported.
Specify —Dsas.promotion.stp.includesourcecode=true (the default setting) if you want source code files to be included when stored processes are imported or exported.

Global Options to Resolve Column Differences in Tables and External Files

The following global options apply to importing tables and external files using the batch import tool. These options specify how column differences are to be handled if you import metadata for a table or external file and a table or external file of the same name already exists in the target folder. You can set these options in ImportPackage.ini.

—Dsas.promotion.columns.deletetargetcolumns

specifies the action that is to be taken if the target table includes columns that are not present in the imported table.

Specify –Dsas.promotion.columns.deletetargetcolumns=true if you want columns to be deleted from the target table if the columns are not also present in the imported table.
Specify —Dsas.promotion.columns.deletetargetcolumns=false (the default setting) if you want columns in the target table to be retained if the columns are not also present in the imported table.

—Dsas.promotion.columns.excludenewcolumns

specifies the action that is to be taken if the imported table includes columns that are not present in the target table.

Specify —Dsas.promotion.columns.excludenewcolumns=true if you do not want to add any new columns to the target table.
Specify —Dsas.promotion.columns.excludenewcolumns=false (the default setting) if you want columns from the imported table to be added if the columns are not present in the target table.