INFOR.CLEAR_TABLE and clear Compass data

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 true clears data stored for Compass queries. Query syntax is case-insensitive.

Syntax

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

Examples

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