DIAGNOSE

This statement executes DIAGNOSE of the specified database or tables or fields.

diagnose
    :    DIAGNOSE DATABASE [ verbose_mode ] [ path_name ]
    |    DIAGNOSE TABLE table_name_list [ verbose_mode ] [ path_name ]
    |    DIAGNOSE FIELD table_dot_column_list [ verbose_mode ] [ path_name ]
    |    DIAGNOSE LINK link_name_list [ verbose_mode ] [ path_name ]

verbose_mode
	:	("verbose"!)?
		( 	"none"
		|	"low"
		|	"normal"
		|	"high"
		|	"veryhigh"
		)
	;

table_name_list
    :	table_name , ...

link_name_list
    :	link_name , ...

table_dot_column_list
    :	table_dot_column, ... 

table_dot_column
    :	table_name.column_name

[verbose_mode]

Specifies how many information will be produced in the log file, but not affect how good diagnose is executed, in any case all database objects are tested.

table_name_list

The list of names of Tables to be diagnosed.

link_name_list

The list of names of Links to be diagnosed.

table_dot_column

The list of full names of Fields to be diagnosed.

path_name

The absolute path to the diagnose report folder.

DIAGNOSE command produces a single-row cursor with a text field, which contains diagnose report, and boolean field with diagnose result. Additionally, if path_name is specified, it produces a text file with the same report.

DIAGNOSE DATABASE;
DIAGNOSE DATABASE VERYHIGH;
 
DIAGNOSE TABLE tblPerson;
 
DIAGNOSE FIELD tblPerson.fldFirstName;