5.30 SQLService

The SQLService enables users to develop applications than can communicate with any database that can be accessed with a JDBC driver. A key requirement is to obtain a JDBC driver for the database that you want to connect to. You will have to obtain this yourself from the database vendor. Most vendors will provide the requisite drivers, in many cases at no charge. The SQLService ships with the IBMi JTOpen toolkit so an IBMi JDBC driver is already available.

The SQLService supports the following commands:

5.30.1 SERVICE_LOAD

5.30.2 CONNECT

5.30.3 SET

5.30.4 GET

5.30.5 EXECUTE

5.30.6 READ

5.30.7 COMMIT

5.30.8 ROLLBACK

5.30.9 METADATA

5.30.10 DISCONNECT

5.30.11 SERVICE_UNLOAD