I am new to informix and was asked to load data into informix using dbload.

I installed IDS 9.4 and created a database and created tables.
Now when i try the dbload utility to load data. i get "No connect Permission" error message.

If any one has encountered the similar error with dbload pls help.

Neha

Informix is installed in Win2K

Hi,

For example, You have the follow table

create table T1
( a int,
b char (20),
c varchar(290),
d date,
e smallint
) ......

For see the syntax of dbload, write dbload then press enter, without parameters.

Now, You have flat file with follow format, with name fileload.unl:

flda|fldb|fldc|fldd|flde|
flda|fldb|fldc|fldd|flde|
flda|fldb|fldc|fldd|flde|
....

Create one file of command, for example file.cmd

FILE "fileload.unl" delimiters "|" 5; 5 is field sum
insert into T1;

Now running dbload :

dbload -d database -c file.cmd -e # "error accept" -l log-file -r -n # "rows to commit" .......


Gustavo.