The LevelSerial table stores the maximum serial number for each unexpanded loop variable in use for each database project. The Variables table is used in both the RDB DSC 2 and RDB DSC schemas.
Holds the VariableID of the Unexpanded loop variable for the project.
Holds the current maximum serial number in use.
UNICOM Intelligence Data Model uses the
rdb_ReserveLevelSerial stored procedure to retrieve the next serial number for each unexpanded loop variable in use by each project.
rdb_ReserveLevelSerial locks the entire Responses table to find the maximum value of the serial number, increments it, inserts the new serial number into the LevelResponsesX table, and returns the number to the client. For more information, see
Stored procedures.