Home > Ask the AS/400 Experts > DB2/400 and DB2 UDB Questions & Answers > DB2 Connect help
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

DB2 Connect help

Kent Milligan EXPERT RESPONSE FROM: Kent Milligan

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 25 September 2007
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?


>
EXPERT RESPONSE

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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
DB2 UDB (universal databases)
Auditing: RPG with embedded SQL showing up as a changed object
DB2 on AS/400: What has it done for me lately?
How to: Transfer unlimited data to Excel from AS/400
What is an integrated database?
An automated CL method of moving a query from AS/400 to Excel
Using WebSphere information integrator to access MS server data using SQLRPGLE
Querying system catalog tables to determine table alias
How to use the QQQVEXPL API
Making a file with an automatic key in iSeries with DDS keyword
Retrieving data from AS/400 into Crystal Reports
DB2 UDB (universal databases) Research

DB2/400 and DB2 UDB
Auditing: RPG with embedded SQL showing up as a changed object
Selecting a PF with multiple members from SQL
Referencing a renamed column on SELECT clause in SQL
Using WebSphere information integrator to access MS server data using SQLRPGLE
Joining files using SQLRPGLE
Querying system catalog tables to determine table alias
Excluding characters from AS/400 DB2 SELECT statements prevents mapping errors
How to use the QQQVEXPL API
Using SQL syntax to override DB2 automatic column name generator on iSeries
Making a file with an automatic key in iSeries with DDS keyword

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 1999 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts