SHOW PROPERTIES Result
A SHOW PROPERTIES command returns a cursor with two main columns: fld_name and fld_value. Also present helper columns that give additional information about property, e.g. if it is System or User, if it is persistent or temporary.
Below are described columns of the result table.
The name of STATUS parameter.
The value of STATUS parameter.
TRUE if this property is system-defined.
TRUE if this property is read only. FALSE if you can change its value using SET PROPERTY command.
TRUE if this property is temporary, i.e. is not stored in the schema. For example IOEncoding property of DB/Table/Field is never saved to DB.
TRUE if value of this property is inherited from the parent object. Usually this is for set of Encoding properties of Db/Table/Field chain.