Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Bangalore
    Posts
    6

    Unanswered: problems with dbload utility

    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

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore
    Posts
    6

    Re: problems with dbload utility

    Informix is installed in Win2K

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: problems with dbload utility

    Originally posted by neha9
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •