HP 3000 Manuals HP 3000 Manuals
Overview PC API builds a connection string from the information in the SQL.INI file or a direct logon (which can be built into a 3GL application). The application software on the PC client requests a connection, and ALLBASE/SQL on the database server uses a listener process to establish the connection between the PC client and the database server. The listener monitors a data communications port for any incoming connection requests. When the listener detects a request, the listener validates the connection string then streams a batch job which establishes a direct link between the PC client and the database server. A new job is established if a different database server or logon is specified in the connection string, or if another window is used. More than one DBEnvironment can be accessed using the same job. A new SQL transaction is started when a different SessionID is used, even though the user, database server, and window are the same (the DBEnvironment can be the same or different). A transaction is shared when an additional connection is requested to open a new cursor, if the same server, user, window, and SessionID are used.