A program can also work 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 the statement EXEC SQL n SET SERVERDB <serverdb> [ON <servernode>]. If SET SERVERDB is not specified, the values are taken from the XUSER file.
Calling XUSER creates the XUSER file. It is possible to make eight different entries with USERKEY, USERNAME, SERVERNODE, SERVERDB, TIMEOUT, ISOLATIONLEVEL, and SQLMODE. (For the generation of the XUSER file, see the platform-specific user manuals.)