Navigation:  Programs > Command-Line Utilities >

CATDBF

Previous pageReturn to chapter overviewNext page

Concatenate DBF Log Files

CATDBF outfile inspec


Each day a log file is created with a date for a filename. If you wish to combine more than one day's worth of data for analysis using your own reporting package, you should use the CATDBF utility. The CATDBF program will combine or concatenate all of the .DBF files that match the second filename and create the filename given as the first argument. If you have used the $log_field command to add fields to the log file, you cannot use CATDBF successfully to concatenate log files of different record formats.

Note that if you use Microsoft Excel to view log files, it cannot process more than 64k records.

Command-Line Arguments:

outfile the name of an output DBF file (with no extension)
inspec specification of input file(s) with DBF extension and optional wildcards

You can use the RUNDATE program to automate the entry of date arguments.

Examples:

Write all of December 1999 into a file called MONTH12.DBF.

CATDBF MONTH12 199912??.DBF

Write all of 2003 data into one file called YEAR03.DBF

CATDBF YEAR03 2003????.DBF

 


Topic url: http://www.copia.com/support/refmanual/index.html?catdbf.htm