Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Unanswered: Informix Error Code 349

    Hi ,
    I am getting a problem while loading data. A C++ program reads text file holding more that 1 million records and loads the data into Informix database with simple insert or update statements, one per line of data from text file.

    After a certain number of records are inserted or updated the insert or update statements start failing with Informix Error Code 349. This does not happen at the same record everytime. So I guess it has to do something with Informix Configuration.

    If anybody has faced this problem and know the answer, please help me.

    Thanks

  2. #2
    Join Date
    Oct 2002
    Posts
    52
    can you retrive the records you loaded- until it fails?
    My guess is no, because the error is you did not connect to the database.

    Dafna

  3. #3
    Join Date
    Nov 2002
    Posts
    3
    Originally posted by thedafna
    can you retrive the records you loaded- until it fails?
    My guess is no, because the error is you did not connect to the database.

    Dafna
    Yes I can retrieve the partially loaded records. Actually the network connection times out giving error code 25582 and after that it gives error code 349 which is understandable because the connection is no more there. But what causes the network connection to time out suddenly while processing is still not resolved.

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    This is verry weird.
    349 occurs when your database is not open. Are you sure that the C++ program doesn't close the database?
    What are your connection settings? C++ on WinNT? with ODBC?
    Or both on Unix?
    I might suggest you to look into the HPL (High Performance Loader).
    This product is included in your engien software. Is is typically used to load lots of data into and out from the database.
    rws

  5. #5
    Join Date
    Mar 2002
    Posts
    112

    re

    I thing so ,
    You have to find out your code where does it define database to use

  6. #6
    Join Date
    Dec 2002
    Location
    shanghai
    Posts
    1

    Red face error code

    when i use the ifx_connect(),it has the error code

    SQLSTATE=IX 001 SQLCODE=-1829

    what is it meating?

    thanks!!

  7. #7
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    -1829

    __________________________________________________ ________

    Cannot open file citoxmsg.pam.

    The file citoxmsg.pam is missing from the directory $INFORMIXDIR/msg.
    rws

Posting Permissions

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