We are writing data using DB2 CONNECT and command LOAD. When we do this, error SQL1325N takes place.
This is the instruction that is executed:
CONNECT TO S910 USER DSSADMIN USING ADMIN LOAD CLIENT FROM /home/dsadm/inpdata.dat OF OF THE MESSAGES/home/dsadm/log.load INSERT into TERESA.SIPEOPTL
S910 is the name of the iSeries machine.
Database Connection Information
Database server = OS/400 5.2.0
SQL authorization ID = DSSADMIN
Local database alias = S910
SQL1325N The remote database environment does not support the command or one of the command options.
DB20000I The SQL DISCONNECT command completed successfully.
DB20000I The QUIT command completed successfully.
Can we use another way?
The DB2 Connect documentation shows that the LOAD command cannot be used with a Host Database. Another option would be using the IMPORT command (requires the data to be in IXF format) or possibly even the DB2 Data Propagator product.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading