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 drivers
see Driver Identifier and Driver Class). Table 1 shows the format of the database URL for
the driver included with Z and I Emulator for Web.
Notice that in the actual database URL (such as jdbc:as400://myISeries)
you should not include the square brackets
shown in the format.
| Driver provided with Z and I Emulator for Web: | Format for database URL: | Examples: |
|---|---|---|
| AS/400 Toolbox for Java | jdbc:as400://[host] |
|
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 SQLQuery action can specify an iSeries host, even though the same SQLQuery 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.