Identify the Progress SQL mode (i.e., SQL89 or SQL92)

1. Login to your Progress DBMS server.

2. Locate the database log file. Typically, the log file should have the same name as the database .db file with a .lg extension.

3. Make a copy of the database log file.

4. Open the copy with a text editor.

5. Locate the entries that pertain to the last database startup.

6. See if the entries contain an entry similar to this:

11:50:04 BROKER  0: This broker supports both 4GL and SQL server groups. (8865)

Reference to 4GL indicates SQL89 mode. Reference to SQL indicates SQL92 mode. Reference to both is referred to as "mixed" mode.