---
name: "hk_exportxml"
section: "1"
platform: "linux"
package: "libhk-classes-dev"
version: "0.8.3-4"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/hk_exportxml"
---

# hk\_exportxml(1)

exports the result set of a query or a table to a XML file. hk\_exportxml is part of the hk\_classes package

## 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 \<hk\_classes@knoda.org\>

## SEE ALSO

[**hk\_actionquery**(1)](/hk_actionquery/1.md), [**hk\_exportcsv**(1)](/hk_exportcsv/1.md), [**hk\_importcsv**(1)](/hk_importcsv/1.md), [**hk\_report**(1)](/hk_report/1.md)