Previous Topic: DROPCOLS Function—Remove Table Columns

Next Topic: RENAME Function—Rename Tables

FREE Function—Remove the Global Variable Enqueue

The FREE function removes the global variable enqueue from a table that is being used by another user or orphaned by an unexpected termination that left the enqueue in the held state.

The FREE function has the following syntax:

OI ASOTEAPI FREE TABLE(table_name) {USER(system>userid)}

Note: If you use the optional USER keyword, you can specify that the FREE function can only be performed if a system and user name that you specify match the current value of the enqueue holder. If you do not specify the USER keyword, the FREE function is performed unconditionally. This may cause unpredictable results if other users are manipulating the table.