5 38 2 Using the SQLService

LANSA Integrator

5.38.2 Using the SQLService

Whether you are writing your client application in RDML / RDMLX or in a 3GL such as RPG, you have to complete the same basic steps.

For example, an application that needs to access a remote database would typically issue the following sequence of commands:

JSM(X)_OPENJSM(X)_COMMANDs

     SERVICE_LOAD

          CONNECT

          SET

          EXECUTE

          READ

          COMMIT

          ROLLBACK

          METADATA

          DISCONNECT

     SERVICE_UNLOAD

JSM(X)_CLOSE

Refer to the Java Service Manager Clients for the command details that apply to your chosen development language.