Parameters for Setting Up the Database Connection 

The system assumes that all environment variables needed for setting up the database connection are set correctly before tp is called. Only the user <sid>adm should use tp at the operating system level.

This is a new feature in Release 6.10. tp no longer modifies the environment variables.

 

To set individual environment variables to a specific value other than the default value of the user <sid>adm, you can use the parameter mod_env. You can also user this parameter if you want to use operating system users other than <sid>adm.

For information on the environment variables and their recommended values, see Environment Variables for Setting Up the Database Connection.

 

·        mod_env

The value of this parameter can have the following syntax:

·        <conditional statement>

·        {<conditional statement>}{<conditional statement>} [{...}]

 

<conditional statement> can have the following syntax:

·        <condition> ? <statement> : <statement>

·        <statement>

 

<condition> can have the following syntax:

·        <variable> <> <value>

·        <variable> == <value>

 

Two special variables can be used for the <condition>:

·        HOST

This variable is replaced by the name of the host where tp is running.

·        OSUSER

This variable is replaced by the name of the operating system user who called tp.

 

<statement> can have the following syntax:

·        set <variable> = <value>

·        unset <variable>

The syntax of <statement> is independent of the operating system (and also the UNIX shell).

tp converts <statement> automatically to suitable commands to change its environment (and the environment of any started programs, such as R3trans).

 

Examples of setting the environment variable MSSQL_USEINTEGRATEDSECURITY to a particular host:

...

                            a.      mod_env = { HOST == host0001 ? set MSSQL_USEINTEGRATEDSECURITY = 0 : set  MSSQL_USEINTEGRATEDSECURITY = 1}

                            b.      P11/mod_env = { HOST == host0001 ? set MSSQL_USEINTEGRATEDSECURITY = 0 : set  MSSQL_USEINTEGRATEDSECURITY = 1}

 

·        dummy

This parameter is usually set automatically when configuring the transport system. It is set to 1 for all systems that are not SAP Systems.

Default: 0

Value range: Boolean

You can use this parameter to make a dummy system known in the global parameter file. Imports are not performed for an SAP System with dummy=1.

D11/dummy = 1