NAME
hk_exportxml - exports the result set of a query or a table to a XML file. hk_exportxml is part of the hk_classes package
SYNOPSIS
hk_exportxml -d driver -b database [OPTIONS] datasourcename
DESCRIPTION
hk_exportxml exports the result set of a query or a table to a XML file. The data will be printed to stdout. To create a table or a query use knoda (http://www.knoda.org). If the datasource is not a table set the --query option.
OPTIONS
- -b, --database=DATABASE
-
database name
- -d, --driver=DRIVERNAME
-
set the SQL-driver (e.g. mysql). You can get a list of all existing SQL-drivers with -l or --list
- -f, --filter=FILTER
-
filter of the datasource. It has the same syntax as the WHERE clause of a SQL statement, just without the 'WHERE'. Example: "author_id = 5"
- --fieldnameattribute
-
if set the fieldname is a attribute in the 'field' tag, else it is the field delimiter tag
- -h, --host=HOST
-
name or IP-number of the host
- -l, --list
-
List available database drivers
- --maindocumenttag=MAINDOCMENTTAG
-
the document delimiter tag
- -p, --password=PASSWORD
-
user password at the SQL server
- -q, --query
-
if set the datasource is a query, not a table
- -r, --port=PORT
-
TCP-port on host
- --rowtag=ROWTAG
-
the row delimiter tag
- -u, --user=USERNAME
-
user name at the sql-server
- --version
-
version and author of hk_classes
DIAGNOSTICS
hk_exportxml returns 0 if everything was ok, or 1 if an error occured. A clear text error message will be written to stderr.
AUTHOR
Horst Knorr <[email protected]>
SEE ALSO
hk_actionquery(1), hk_exportcsv(1), hk_importcsv(1), hk_report(1)