how to load data in table from large .unl

Ibm Informix se developer concurrnt sess...
February 22, 2011 at 02:06:04
Specs: Windows XP, Intel core2duo/2 gb
Problem Scenario is for Informix 11.5:

I have table schema and one .unl file for data..
.unl file is of 1.5gb
I have created table with this schema using third party tool QTODBC6.1 IN MY database known as: dbtesting
Table named as: OFL

WHEN I RUN DBACCESS COMMAND AND IN QUERY LANGUAGE I TYPE

LOAD FROM “D:\OFL_1.UNL” INSERT INTO OFL

IT ONLY INSERTS 93092 RECORDS AND IT GIVES ERROR
271: COULD NOT INSERT NEW ROW INTO TABLE AND 131:ISAM ERROR:NO FREE DISK SPACE

SO WHAT SHOULD I DO TO INSERT ALL 1200000 RECORDS IN MY .UNL FILE…?
KINDLY GIVE ME SYNTAX OR STEPS TO SOLVE THIS ISSUE.
Is any gui tool available to insert all records from this .unl file to my table in Informix..

Kindly reply as soon as possible.

Thanking you

Mubin


See More: how to load data in table from large .unl

Report •

#1
February 23, 2011 at 01:44:56
How much free space do you have? I've used dabase systems that could use potentially twice the sum of the database and results.

Report •
Related Solutions


Ask Question