Defining Database Properties (Magic xpa 3.x)
The Database Properties dialog box lets you specify additional parameters for IBM i library definition and data access.
To define the database properties:
-
From the database entry in the Database repository, select Edit/Properties or press Ctrl+P to access the Login tab of the Database Properties dialog box.
-
In the Database Server parameter, enter a Host name or IP address as shown in the figure below. The IBM i System Name should be declared in the Hosts file (under Windows). The IP address of the system can also be used. The default TCP/IP Port will be used (6077). However, if the deamon is using a different port, you should use that port, such as 10.1.1.10:3003. Note that this property is limited to 20 characters for DB2/400.
-
In the User Name and User Password parameters, you may specify the IBM i user ID and password to be used by the gateway. Note that the password field is not hidden, so you might prefer to leave it to the user to supply the password.
You can use Magic xpa Secret Names or Logical Names for the password. For more information, see the Magic xpa Help.
-
You can specify further database options on the Options tab of the Database Properties dialog box. For example:
-
Select the Change Tables in Studio option, it allows changes to the structure of the IBM i files on the host.
-
Use the Server Sort setting for the Library’s Sort operation to be implemented by the open Query file (OPNQRYF) command, which improves performance. If Server Sort is enabled, Magic xpa will not perform its own sort but will add a virtual index to the current table and use it as the current cursor.
-
You can specify additional parameters in the Database Information window on the SQL tab, using the format KEYWORD=VALUE. For more information, see the Database Information Keywords topic.
-
Click OK to exit the Database Properties dialog box, and then click OK again to exit the Database repository.
Defining the SQL Database Isolation Level
