Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

DB2 Connect help

ISeries database expert Kent Milligan explains why a user receives an error message while trying to pass data from a Unix server with OS/400 V5R2.

We are passing data from a server with system Unix to another server with system OS/400 V5R2.

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.

This was last published in September 2007

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close