A program can also operate in multi-db mode. Thus operations on up to eight different ADABAS databases can be performed simultaneously; i.e., eight concurrent sessions can exist on different databases. SQL statements of the second database session begin with 'exec sql 2'. The database session number (sessionno) 2 must be separated with blanks from 'exec sql'. Similarly, the third database session begins with 'exec sql 3' and the fourth with 'exec sql 4', etc.
Prior to the connect for the second and any other database session, the servernode and the name of the respective database may be specified with 'exec sql n set serverdb <serverdb> [on <servernode>]'. If 'set serverdb' is not specified, the values are taken from the XUSER file. The keywords and the session number 'n' must be placed on the same line and may only be separated by blanks.
Calling xuser creates the XUSER file. It is possible to make eight different entries with 'userkey', 'username', 'servernode', 'serverdb', 'timeout', 'isolation level', and 'sqlmode'. (For the generation of the XUSER file, see the platform-specific ADABAS User Manual.)