I'm trying to migrate an Informix database into DB2. For every table I've generated the following script:

create table posao
(sif_pos char ( 3 ) not null ,
naz_pos char ( 50 ) not null ,
primary key ( sif_pos )
) ;

CONNECT TO database;
IMPORT FROM "D:\work\bazisok\database.exp\posao00100.unl"
OF DEL MODIFIED BY COLDEL| METHOD P (1, 2)
COMMITCOUNT 5000 MESSAGES D:\work\bazisok\database.exp\PUNI.LOG
INSERT INTO administrator.posao(sif_pos, naz_pos);
CONNECT RESET;

And It works fine with Windows UDB v. 8.1.

However when I tried this script on AS/400 I got the error message: The remote system doesn't support one or more .... (Unfortunately I didn't wrote down the exact error message).

After that, I've also tried the IBM's migrating tool. Where I was unable to connect to the AS (the OK button wasn't enabled after I've typed in the system information).

Does anyone have any suggestion how to do it? (Until Thursday I've to find a solution)


Thanks in advance,
Juhász Lajos