Hello all,
is there another way to export data to a csv-file (comma-separated format)?
We tried the EXPORT-command and got the following error
"
SQL1325N The remote database environment does not support the command
or one of the command options.
Explanation: An attempt has been made to issue a DB2 workstation database
specific command or command option against a host database through DB2
Connect or federated server. The following commands generate this error when
issued against a DB2 for MVS*, DB2 for OS/400* or SQL/DS* database:
a.. OPSTAT (Collect Operational Status)
b.. DARI (Database Application Remote Interface)
c.. GETAA (Get Administrative Authorizations)
d.. GETTA (Get Table Authorizations)
e.. PREREORG (Prepare to Reorganize Table)
f.. REORG (Call Reorganize Function)
g.. RQSVPT/ENSVPT/RLBSVPT (Subtransaction Requests)
h.. RUNSTATS (Run Statistics).
i.. COMPOUND SQL ATOMIC STATIC (Atomic Compound SQL)
j.. ACTIVATE DATABASE
k.. DEACTIVATE DATABASE
As well, the following commands generate this error with incorrect options:
a.. IMPORT (Import table) The filetype must be IXF, commitcount must be 0,
and the first word in the Action String (e.g. "REPLACE into ...") must be
INSERT.
b.. EXPORT (Export table) The filetype must be IXF.
The command cannot be processed.
User Response: Do not attempt to issue this command against a host database
through DB2 Connect or federated server.
"
Well, is there a workaround or am I hopelessly stuck?
Thanks for any help in advance!
Bye!
Oli