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 "'".