You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Thomas Lindenhofer <li...@webdynamite.com> on 2009/06/24 09:43:15 UTC

Error in Bulk-Export documentation

Hi,

I think there is an error on the page 
http://db.apache.org/derby/docs/10.0/manuals/tools/tools91.html#HDRSII-IMPORT-92876

> To export the result of a SELECT statement to a file, use the 
> SYSCS_UTIL.SYSCS_EXPORT_QUERY procedure. The procedure definition is:
> *SYSCS_UTIL.SYSCS_EXPORT_QUERY(IN selectStatement VARCHAR(32672), 
> IN tableName VARCHAR(128), IN fileName VARCHAR(32672), 
> IN columnDelimiter CHAR(1), IN characterDelimiter CHAR(1), 
> IN codeset VARCHAR(128))*
>   
I was wondering why I need a table name when I provide a query. In the 
examples and on other websites I found that I do not need a table name 
and the correct procedure definition is:

> SYSCS_UTIL.SYSCS_EXPORT_QUERY(IN SELECTSTATEMENT VARCHAR(32672),
> IN FILENAME VARCHAR(32672), IN COLUMNDELIMITER CHAR(1),
> IN CHARACTERDELIMITER CHAR(1), IN CODESET VARCHAR(128)) 


KR and many thanks for derby!
Thomas

-- 
_________________________________________

  Thomas Lindenhofer (Development)
  WebDynamite IT Solutions GmbH
  Landstrasse 49, A-4020 Linz, Austria
  http://www.webdynamite.com
  +43 / 732 / 777 810 - 27 (fixed)
  +43 / 732 / 777 810 - 50 (fax)
  Firmenbuchnummer und -gericht:
  FN 205355v, Landesgericht Linz
_________________________________________

TOP NEWS: BlackBerry®-Schulungen für Administratoren, IT-Leiter und End-User
Details unter: http://webdynamite.com/index.php?id=184


Re: Error in Bulk-Export documentation

Posted by Knut Anders Hatlen <Kn...@Sun.COM>.
Thomas Lindenhofer <li...@webdynamite.com> writes:

> Hi,
>
> I think there is an error on the page http://db.apache.org/derby/docs/10.0/
> manuals/tools/tools91.html#HDRSII-IMPORT-92876

Thanks! I've logged it in the bug tracker:
https://issues.apache.org/jira/browse/DERBY-4288

Note that the 10.0 manuals are very old and are no longer maintained, so
using a newer version is strongly recommended. The manuals for Derby
10.5 can be found here: http://db.apache.org/derby/docs/10.5/

Unfortunately, the problem is still present in the latest revision of
the manual.

-- 
Knut Anders