Feedback Print

Windows

The automatic installation already comes with the IBM DB2 preconfigured, only needing to install the client to make the connection.

If you’re using your own environment preconfigured, you’ll need to enable the IBM DB2 extension in PHP.

DB2

Setting up DB2 on Windows

Pre-Requirements

  • Have the database installed and setup on a server or locally.
  • Have at least one table created.
  • Have the Instant Client installed on the same machine as ScriptCase.

If all the requirements are met, the DB2 extension will be enabled, in this case you can proceed to Creating a Connection with Scriptcase.

In case it is not enabled, follow the steps below to enable the DB2 extension:

Enabling the Extension

  • Download the instant client compatible with the architecture of your operating system, x64 or x86 bits:
  • After downloading, follow the wizard of the installation and click to advance to maintain the default values of the installer.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Accept the terms and advance with the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Advance, to maintain the default values of the installer

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Install, to start the installation procedure

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Finish, to Finish the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

DB2 Native ODBC

Setting up DB2 Native ODBC on Windows

Pre-Requirements

  • Have the database installed and setup on a server or locally.
  • Have at least one table created.
  • Have the Instant Client installed on the same machine as ScriptCase.

If all the requirements are met, the DB2 extension will be enabled, in this case you can proceed to Creating a Connection with Scriptcase.

In case it is not enabled, follow the steps below to enable the DB2 extension:

Enabling the Extension

  • Download the instant client compatible with the architecture of your operating system, x64 or x86 bits:
  • After downloading, follow the wizard of the installation and click to advance to maintain the default values of the installer.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Accept the terms and advance with the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Advance, to maintain the default values of the installer

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Install, to start the installation procedure

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Finish, to Finish the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

DB2 Generic ODBC

Setting up DB2 Generic ODBC on Windows

Pre-Requirements

  • Have the database installed and setup on a server or locally.
  • Have at least one table created.
  • Have the Instant Client installed on the same machine as ScriptCase.

If all the requirements are met, the DB2 extension will be enabled, in this case you can proceed to Creating a Connection with Scriptcase.

In case it is not enabled, follow the steps below to enable the DB2 extension:

Enabling the Extension

  • Download the instant client compatible with the architecture of your operating system, x64 or x86 bits:
  • After downloading, follow the wizard of the installation and click to advance to maintain the default values of the installer.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Accept the terms and advance with the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Advance, to maintain the default values of the installer

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Install, to start the installation procedure

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Finish, to Finish the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

DB2 Generic ODBC 6 or Lower

Setting up DB2 Generic ODBC 6 or Lower on Windows

Pre-Requirements

  • Have the database installed and setup on a server or locally.
  • Have at least one table created.
  • Have the Instant Client installed on the same machine as ScriptCase.

If all the requirements are met, the DB2 extension will be enabled, in this case you can proceed to Creating a Connection with Scriptcase.

In case it is not enabled, follow the steps below to enable the DB2 extension:

Enabling the Extension

  • Download the instant client compatible with the architecture of your operating system, x64 or x86 bits:
  • After downloading, follow the wizard of the installation and click to advance to maintain the default values of the installer.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Accept the terms and advance with the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Advance, to maintain the default values of the installer

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Install, to start the installation procedure

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Finish, to Finish the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

DB2 PDO

Setting up DB2 PDO on Windows

Pre-Requirements

  • Have the database installed and setup on a server or locally.
  • Have at least one table created.
  • Have the Instant Client installed on the same machine as ScriptCase.

If all the requirements are met, the DB2 extension will be enabled, in this case you can proceed to Creating a Connection with Scriptcase.

In case it is not enabled, follow the steps below to enable the DB2 extension:

Enabling the Extension

  • Download the instant client compatible with the architecture of your operating system, x64 or x86 bits:
  • After downloading, follow the wizard of the installation and click to advance to maintain the default values of the installer.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Accept the terms and advance with the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Advance, to maintain the default values of the installer

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Install, to start the installation procedure

Setting up DB2 DsDriver Setting up DB2 DsDriver.

  • Click on Finish, to Finish the installation.

Setting up DB2 DsDriver Setting up DB2 DsDriver.

Creating a Connection with ScriptCase

  • Access ScriptCase using the URL http://127.0.0.1:8090/scriptcase
  • After accessing ScriptCase, access or create a new project, click on the new connection icon or access “Database > New Connection”

Creating a new connection Creating a new connection

  • After that, you will see a page with all the database connections that you can create. Select a “DB2” connection

 Selecting a Windows database connection Selecting a Windows database connection

  • New connection : You will place the information of the connection to your database here:

 Connecting with Windows database Connecting with Windows database

  • Connection Name : Defines the name of your new connection.
  • DBMS Driver : Allows you to select the drivers: DB2 Generic ODBC, DB2 Generic ODBC 6 or lower, DB2, DB2 Native ODBC.
  • Server/Host (Name or IP) : Insert the name or IP of the server where the Windows database is located.
  • Database Name : Inform the database name.
  • Schema : You can inform the Schema (It is optional), in case you want to use the tables that are part of a Schema.
  • Username : Inform the user to access the Windows database.
  • Password : Inform the password to access the Windows database.
  • Test Connection : Displays a message of the status of the connection if successful or not.

  • For more options on connecting, click on the Advanced tab:

 Advanced setup for the Windows database Advanced setup for the Windows database

  • autocommit - Enables or disables the auto commit functionality.
  • i5_lib - A value of characters that indicates the default library that will be used to solve unqualified file references. This is not valid if the the connection is using the system nomination mode.
  • i5_naming - Enables or disables the system nomination mode of the DB2 UDB CLI iSeries. The files are qualified when using dash (/) delimiter. Unqualified files are solved using the list of libraries to work.
  • i5_commit - Select the desired option treating the date of the IBM DB2.
  • Decimal Separator - Select the separator type, between a dot or a comma.
  • Persistent Connection - Persistent Connection are connections that do not close when finishing a script.
  • Use the schema before table name - Allows the use of schemas before the name of the tables.

  • Filter : Accessing this tab, we can setup which tables will be listed on this connection:

Filtering the Windows database Filtering the Windows database

  • Show - Allows the display of the the filters on the tables, views, System Tables and procedures.
    • Tables - Allows to setup the display of Tables from your database.
    • Views - Allows to setup the display of Views from your database.
    • System Tables - Allows to setup the display of System Tables from your database.
    • Procedures - Allows to setup the display of Procedures from your database.
  • Searches - Allows to define which tables and Owner will be displayed.
    • Tables - Allows to define a prefix (prefix%) or name of the tables for display.
    • Owner - Allows to define the owner of the tables for listing.
    • Show - Allows to define what will be displayed or not from the table an owner’s setup.