HTML automatically generated with rman
Table of Contents

Name

tablint - prototype table syntax checker

Synopsis

tablint in= lint= [parameter=value]

Description

tablint checks tables and can optionally apply selections and output this in the same format.

The current version only checks for a consistent number of columns in the file, by default the first non-empty/comment line determines the number of columns, unless maxcol= was used to set it.

Parameters

The following parameters are recognized in any order if the keyword is also given:
in=
input file name
lint=lint_form
lint specification
maxcol=
Number of columns allowed. If set to 0, it will use the first row that looks like data to count the number of columns. Default: 0
linelen=
Override some sensible maximum linelength (normally 16384 in maxsizes.h).
out=
For those rows that pass the criteria specified in lint_form ** not used **

Lint Format

The lint_form is a simple ASCII file that describes the table is some uniform way. You can also apply checks on any column, set validity intervals, and use it to output a new table with these selections applied. Here is an example 
# this is an example ’lint’ specification for tablint
#
maxcol 10
col 1 {
    name id        # name of a column (optional)
    type int
    range -10:10 
    blank -999        # although outside range, this signifies BLANK ???
}
col 2 {
    name town
    type char
    length 1:10        # a string 1-10 characters in length
}
col 3 {
    name zipcode
    type char
    length 2        # all strings must be 2 chars length
    match DC|MD|VA    # example of exclusive OR-ed
}
col 4 {
    name any
    type char
}
col 5 {
    name bad        
    type float        # example of a non-existent type
    john doe        # example of a non-existent 
}
col 6 {
    name good
    type real
    range 0:        # example of a half-infinite range interval
}

See Also

tabmath(1NEMO) , table(5NEMO)

Author

Peter Teuben

Update History


13-Jan-95    V0.1 Prototype created      PJT
18-may-05    V0.3 deprecate lint= for now, and just simple column counting check    PJT

Table of Contents