c-treeRTG V2 Update Guide

ctutil -sqlcheck enhanced to return all problems in the table

The ctutil -sqlcheck facility verifies if a table, given an XDD, has records causing conversion errors in SQL. In its implementation, it stops on the first error it encounters. This functionality has been expanded to print out all errors in all records or to print out all errors on the first failing record. The default value is to stop on the first error.

Usage:

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

• file - File name without extension
• xdd_file - Path to a data definition file in XML format
• convention_ID - Optional numeric storage convention ID:

  A - ACUCOBOL-GT (default)

  B - MBP COBOL

  D - Data General

  I - IBM

  M - Micro Focus

  N - NCR COBOL

  R - Realia COBOL

  V - VAX COBOL

• 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