c-treeRTG V2 Update Guide

-sqlcheck

This ctutil option verifies that the data is correct in sqlized tables. The -sqlcheck option is used to verify that data in a file is compatible with SQL definitions. The command scans all records of the given file using the primary key index and stops at the first conversion error encountered showing an error message, the record number, schema and field name of the incorrect data.

Usage:

ctutil -sqlcheck file xdd_file [-conv=convention_ID] [-show=show_type]

The -sqlcheck option checks SQL definitions against data in a file. Valid parameters are:

• file - File name without extension
• xdd_file - Path to a data definition file in XML format
• convention_ID - COBOL Users Only: Optional numeric storage convention ID; see convention_ID values.
• show_type - level of errors to show:

  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

Example:

The usage and output of the command is as follows:

C:\>ctutil -sqlcheck filecompa filecompa.xdd -conv=A

ctutil Version 11.2.0.5893-160315

Initialized from (ctree.conf)

Checking filecompa...

ascii value is not a digit. Record#: 8 Schema#: 0 Field: NS

Operation completed successfully.