INFOR.CLEAR_TABLE and retain Compass data

The infor.clear_table stored procedure clears the optimized data format storage definition. Use the second parameter option of ‘false’ to retain the historic data stored in Compass.

The first parameter is the object name. Enclose the object name in single quotes. Object names that begin with a digit must be enclosed in double quotes and then single quotes. The second parameter is true or false. It is a string literal and must be enclosed within single quotes. A value of false retains Compass data. Query syntax is case-insensitive.

Syntax

EXEC INFOR.CLEAR_TABLE('objectname','false')

Examples

exec infor.clear_table('product', 'false')
exec infor.clear_table('"123object"', ‘false')