Mark_rusci
asked on
Can I load a table using a .csv file in db2?
I have tried: load client from 'C:\currentEmail.csv' of del insert into mytablename
but I recieve this error:
SQL1325N The remote database environment does not support the command or one
of the command options.
SQL1325N The remote database environment does not support the command or one of the command options.
Is this a authorization problem or do I have a syntax problem? The data file is comma delimited with " around the data fields.
Thanks for your help.
but I recieve this error:
SQL1325N The remote database environment does not support the command or one
of the command options.
SQL1325N The remote database environment does not support the command or one of the command options.
Is this a authorization problem or do I have a syntax problem? The data file is comma delimited with " around the data fields.
Thanks for your help.
ASKER
Hi Kent,
here is the complete command and response from db2 command center client:
-------------------------- ---- Commands Entered -------------------------- ----
load from 'C:\currentEmailPrd.csv' of del insert into dbplse.pltrf001_emailaddr;
-------------------------- ---------- ---------- ---------- ---------- ---------- --
load from 'C:\currentEmailPrd.csv' of del insert into dbplse.pltrf001_emailaddr
SQL1325N The remote database environment does not support the command or one
of the command options.
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:
o OPSTAT (Collect Operational Status)
o DARI (Database Application Remote Interface)
o GETAA (Get Administrative Authorizations)
o GETTA (Get Table Authorizations)
o PREREORG (Prepare to Reorganize Table)
o REORG (Call Reorganize Function)
o RQSVPT/ENSVPT/RLBSVPT (Subtransaction Requests)
o RUNSTATS (Run Statistics).
o COMPOUND SQL ATOMIC STATIC (Atomic Compound SQL)
o ACTIVATE DATABASE
o DEACTIVATE DATABASE
As well, the following commands generate this error with
incorrect options:
o IMPORT (Import table) The filetype must be IXF, commitcount
must be 0 for offline import or must not be automatic for
online import, and the first word in the Action String (for
example, "REPLACE into ...") must be INSERT.
o 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.
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1325 sqlerrml: 70
sqlerrmc: 37 ITCPIED DB2T QDB2 850
sqlerrp : SQLULOAD
sqlerrd : [1]: 0 [2]: 0 [3]: 0
[4]: 0 [5]: 0 [6]: 0
sqlwarn : [1]: [2]: [3]: [4]: [5]: [6]:
[7]: [8]: [9]: [10]: [11]:
sqlstate: m€|€€€
€m€ €m€ 4|
€ €
here is the complete command and response from db2 command center client:
--------------------------
load from 'C:\currentEmailPrd.csv' of del insert into dbplse.pltrf001_emailaddr;
--------------------------
load from 'C:\currentEmailPrd.csv' of del insert into dbplse.pltrf001_emailaddr
SQL1325N The remote database environment does not support the command or one
of the command options.
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:
o OPSTAT (Collect Operational Status)
o DARI (Database Application Remote Interface)
o GETAA (Get Administrative Authorizations)
o GETTA (Get Table Authorizations)
o PREREORG (Prepare to Reorganize Table)
o REORG (Call Reorganize Function)
o RQSVPT/ENSVPT/RLBSVPT (Subtransaction Requests)
o RUNSTATS (Run Statistics).
o COMPOUND SQL ATOMIC STATIC (Atomic Compound SQL)
o ACTIVATE DATABASE
o DEACTIVATE DATABASE
As well, the following commands generate this error with
incorrect options:
o IMPORT (Import table) The filetype must be IXF, commitcount
must be 0 for offline import or must not be automatic for
online import, and the first word in the Action String (for
example, "REPLACE into ...") must be INSERT.
o 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.
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1325 sqlerrml: 70
sqlerrmc: 37 ITCPIED DB2T QDB2 850
sqlerrp : SQLULOAD
sqlerrd : [1]: 0 [2]: 0 [3]: 0
[4]: 0 [5]: 0 [6]: 0
sqlwarn : [1]: [2]: [3]: [4]: [5]: [6]:
[7]: [8]: [9]: [10]: [11]:
sqlstate: m€|€€€
€m€ €m€ 4|
€ €
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Other thing.
For DB2 LUW if you are connecting to a remote database using your DB2 Connect you
must issue the command
db2 load client ......
otherwise you would get an error.
Regards,
Tomas Helgi
For DB2 LUW if you are connecting to a remote database using your DB2 Connect you
must issue the command
db2 load client ......
otherwise you would get an error.
Regards,
Tomas Helgi
I know that that works on DB2/LUW as I've used it several times. If you're on an LUW system it's probably just a syntax error (please post the exact command).
If you're on DB2 for Z/OS or AS/400, I'll have to defer to one of the guys that knows this better than do I.
Good Luck,
Kent