Database URL

In the Database URL field, type the database URL of the database server that provides access to the database. The format of the database URL depends on the type of Java Database Connectivity (JDBC) driver that you use to access the database (for more information on JDBC drivers see Driver Identifier and Driver Class). Table 1 shows the format of the database URL for the JDBC driver included with Z and I Emulator for Web.
Table 1. Formats for database URL
Driver provided with Z and I Emulator for Web: Format for database URL: Examples:
AS/400 Toolbox for Java jdbc:as400://[host]
  • jdbc:as400://myISeries
  • jdbc:as400://9.88.24.163
Notice that in the actual database URL (such as jdbc:as400://myISeries) you should not include the square brackets shown in the format.

The remote server can be located on a host other than the host to which the Z and I Emulator for Web emulator session is connected. For example, a FileUpload action can specify an iSeries host, even though the same FileUpload action is part of a macro that is running in a 3270 Display session connected to a zSeries host.

If you are using a JDBC driver other than the driver provided with Z and I Emulator for Web, consult the documentation provided by the driver vendor for the proper format for the database URL.