UDB import to AS400 
Author Message
 UDB import to AS400

Can anyone offer any suggests about the attached. Import fails.
Using UDB 7.2 fixpack 5

------------------------------ Command Entered
------------------------------
connect to TORONTO user bp03951 using ********
-----------------------------------------------------------------------------
   Database Connection Information
 Database server        = OS/400 4.5.0
 SQL authorization ID   = BP03951
 Local database alias   = TORONTO

------------------------------ Command Entered
------------------------------
import from d:\temp\shop.ixf of ixf insert into bp03951.newshop
-----------------------------------------------------------------------------
SQL3150N  The H record in the PC/IXF file has product "DB2    02.00", date

"20020226", and time "184034".

SQL3153N  The T record in the PC/IXF file has name "d:\temp\shop.ixf",
qualifier "", and source "            ".

SQL3109N  The utility is beginning to load data from file
"d:\temp\shop.ixf".

SQL3306N  An SQL error "-7008" occurred while inserting a row into the
table.

SQL7008N  REXX variable "NEWSHOP   " contains inconsistent data.
SQLSTATE=55019

SQL3110N  The utility has completed processing.  "1" rows were read from
the
input file.



Tue, 17 Aug 2004 06:33:08 GMT
 UDB import to AS400

Many possibilities.  It really is an incompatability between the data and
the target field, check for valiad date, that a small int isn't receiving a
value too large, check for nulls in a not nullable field.  Takes a little
sleuthing.


Quote:
> Can anyone offer any suggests about the attached. Import fails.
> Using UDB 7.2 fixpack 5

> ------------------------------ Command Entered
> ------------------------------
> connect to TORONTO user bp03951 using ********
> --------------------------------------------------------------------------
---
>    Database Connection Information
>  Database server        = OS/400 4.5.0
>  SQL authorization ID   = BP03951
>  Local database alias   = TORONTO

> ------------------------------ Command Entered
> ------------------------------
> import from d:\temp\shop.ixf of ixf insert into bp03951.newshop
> --------------------------------------------------------------------------
---
> SQL3150N  The H record in the PC/IXF file has product "DB2    02.00", date

> "20020226", and time "184034".

> SQL3153N  The T record in the PC/IXF file has name "d:\temp\shop.ixf",
> qualifier "", and source "            ".

> SQL3109N  The utility is beginning to load data from file
> "d:\temp\shop.ixf".

> SQL3306N  An SQL error "-7008" occurred while inserting a row into the
> table.

> SQL7008N  REXX variable "NEWSHOP   " contains inconsistent data.
> SQLSTATE=55019

> SQL3110N  The utility has completed processing.  "1" rows were read from
> the
> input file.



Wed, 18 Aug 2004 10:31:24 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DB2 UDB, WinNT/AS400

2. query AS400 from DB2 UDB on AIX

3. Connection UDB NT - AS400

4. Update data on UDB from DB2/AS400

5. Executing DB2/UDB utilities (LOAD/IMPORT) using JDBC

6. import tables created with QMF for windows (DB2 v6.1) into UDB 7.1 runing on win98

7. date format when importing files to UDB

8. Importing physical and logical files from the AS400 to SQL7

9. Importing last days data from AS400/DB2 to SQL7

10. Trying to import logical files from the AS400 into SQL 7

11. Importing table from As400 to sql-server

12. Import file from AS400


 
Powered by phpBB® Forum Software