|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.