DBTABL

Use this program to create separate files for each record (table) in the database.


Usage:

dbtabl<environment> <design> <database> <NULL | selection file> <format NULL | F | C char>

 

Results: will be a file per table

Format: <database id>_<design>_<table name>.dbl

 

<> indicates a mandatory switch

[ ] indicates an optional switch

Where:

Option Description

<environment>

Environment name
<design> Database design *dhd"
<database> Database name drillholes.dhd.isis
<selection file> This is optional, but you will need to either hit return when prompted or supply the string NULL if no selection is supplied.

Selection files format <id>.sel
<format> File format NULL | F are the same (column delimited)

C (csv) requires the character to delimit with.

Example:

dbtabl.exe krja dhd drillhole.rdd.isis NULL NULL (same as F)

Result:   

drillhole_rdd_collar.dbl

drillhole_rdd_geo.dbl

drillhole_rdd_survey_dbl

drillhole_rdd_<table...>.dbl

*formatted (columns width as defined in the design)

dbtable.exe krja dhd drillhole.rdd.isis NULL C

will result in the same files and column widths honoured, but also with the character delimiter supplied. In this case a "'".