Procedure documentation Call with the Perl Interface of the SAP DB Loader Locate the document in its SAP Library structure

You can call the SAP DB Loader through the processing of a Perl script.

Prerequisites

Perl is installed on the host.

The following Perl modules are delivered with the SAP DB Loader program to allow you to create Perl scripts that can be processed by the Structure linkLoader.

Note

Open the instperl.pl file. When you do this, the files are copied to the relevant directories.

Call

perl <perl_script_file> [<argument> ...]

You can optionally specify arguments <argument>.

Frequently used arguments:

<user_name>
<password>

User name
Password

<database_name>

Name of database instance

<data_path>

Directory in which the data file is stored

<server_node>

Name of the server on which the Loader is located

Example

perl sample samplename secret TST C:\data\sapdb

The Perl script sample is called. The logon to the Loader is performed for the user samplename on the database instance TST. The data file is in the directory C:\data\sapdb.

Template for Background Files

The following section contains examples of background files in Perl. Their equivalents in the Python script language are also provided for comparison.

Example 1
Build a Perl module with reference to the SAP DB Perl Libraries,
parse the call arguments


Perl


Python

Example 2
Create a database session with the Loader
Log on to the database instance
Log off



Perl



Python

Example 3
Create a database session
Log on to the database instance
Query whether a table exists by querying the error code
Create a table without querying the error code
Log off



Perl



Python

Example 4
Create a database session
Log on to the database instance
Create a table and query the error code
Use command(s) to load data into the table and query the error code
Log off




Perl




Python

Example 5
Create a database session
Log on to the database instance
Use command(s) to load data into table and intercept exceptions
Log off



Perl



Python

Perl Classes