-sqlcheck

Verifies that the data is correct in sqlized tables.

Usage

ctutil -sqlcheck file iss_file [-conv=sign_convention] [-show=show_type]

•	file is the name of the c-tree file. The default file extension (that is ".dat" if not configured differently) must be omitted. Relative paths are resolved according to the c-tree server working directory.

•	iss_file is the dictionary file. Relative paths are resolved according to the c-tree server working directory.

•	sign_convention identifies the numeric data convention.

o	use A for programs compiled with -dca option or without data compatibility options.

o	use D for programs compiled with -dcd option.

o	use I for programs compiled with -dci option.

o	use M for programs compiled with -dcm option.

o	use N for programs compiled with -dcn option.

o	use R for programs compiled with -dcr option.

 

If omitted, A is assumed

•	show_type is the level of error to show:

Type	Meaning
all	show all errors in the table
first	show the first error in the table
firstrec	show all errors in the first problematic record in the table