Re: Table content to ASCII file
Posted in 1995
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Migration, Import/Export & Data Conversion
Frederic Bouquet (Frederic_Bouquet@ascus.com) wrote:
: What is the best way to export the content of one table into an ASCII file
: from an ESQL/C application ?
: I noticed the commands unload & load, but they are not allowed from ESQL/C
: application. Is there another way to do that ?
: Many thanks
--
Hi Frederic,
LOAD and UNLOAD are no SQL-Statements, they are coded in isql and dbaccess.
To unload data you can look at the demo files or the documentation of
your ESQL/C. In some versions is an example included that shows how to
unload data using sqlda structures.
To load data you can generate a script for the dbload command and execute
dbload with the appropriated parameters. Doing this by means of sqlda
structures is a bit complicated.
Hope this helps ...
+-------- Herbert Birkenbach -------------------------------------------+
| CSS Fulda GmbH |
| birke@css.de +49 661 93920 Justus-Liebig-Str. 2-4 |
| Germany 36093 Kuenzell |
+-----------------------------------------------------------------------+