msql2dbf(1)

msql2dbf1

Generate xbase-style .dbf-files from sql-tables

Usage

msql2dbf [options] dbf-file

Options: [-v [v]] [{-u | -l}] [-d database] [-t table] [-h host] [-d] [-q query] [-p precision]

Overview

This manual page documents the program msql2dbf. This takes a table, and writes out an xBase-style .dbf-file with the contents of that table.

Options

-v

Display some status-messages.

-vv

Also display progress.

-u

Convert the contents of all fields to uppercase.

-l

Convert the contents of all fields to lowercase.

-d database

Specify the database to use. An error is returned if this database does not exists. Default is "test".

-t table

Specifies the table to select from. An error is returned if this database does not exists. Default is "test".

-h host

Specify the host to which to connect. Default is "localhost".

-q

Specify a custom query to use to fetch the data out of the table (or tables).

-p precision

Specify the precision to use in the case of a REAL field. This is the part after the decimal point.

Environment

These programs are effected by the environment-variables as used by mSQL. See the documentation of mSQL for more information on this.

Releases

Unchanged in 2 releases since Debian 2.0 (Hamm).

  1. 2.0–2.1

Bugs

At the moment none that I know, except for some lacking functionallity.

Availability

You can get the latest version by anonymous FTP from ftp.nerosworld.com/pub/msql/contrib/dbf2msql

From dbf2msql 2.0-6 in Debian 2.1 (Slink). Parsed by carta from the page's man source.