Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Lightbulb Unanswered: "Load From" Problem using SQLEdtor400.exe

    We have data in text files and we want these text files to export into
    informix, rather we can say that we want these text files to get loaded
    into informix tables.

    We are using Informix "Load From " command to get data loaded into
    informix table.

    One way of doing things is using "Load From" command directly from
    Delphi but we couldn't able to do so(i.e. its not working) , the other
    way we are following is calling SQL Editor executable file with some
    command line parameters including file name (i.e. file having command to load file).

    following is the piece of Delphi code we are using to load file into
    informix
    ssql := sEditorPath + ' /ignoreerr /ns /min /s ' + sServer + ' /d
    ' + sDbname + ' /u ' + sUser + ' "' + OutPutDBPath + 'LoadFile.sql "' +
    ' /exec /exit';
    FillChar(StartInfo,SizeOf(TStartupInfo),#0);
    FillChar(ProcInfo,SizeOf(TProcessInformation),#0);
    StartInfo.cb := SizeOf(TStartupInfo);
    StartInfo.dwFlags := STARTF_USESHOWWINDOW;
    StartInfo.wShowWindow := SW_HIDE;
    CreateOK := CreateProcess( Nil ,PCHAR(ssql),nil, nil,False,
    CREATE_NEW_PROCESS_GROUP+NORMAL_PRIORITY_CLASS, nil,
    nil, StartInfo, ProcInfo);
    if CreateOK then
    WaitForSingleObject(ProcInfo.hProcess, INFINITE);

    Note : sEditorpath is the path of the sql editor, sServer is server name,
    sDbname is database name, sUser is user name and
    OutPutDBPath + LoadFile.sql is file name including complete
    path having sql command.

    Content of Load.sql
    Load From "d:\ErrorFiles\FormatLog.txt" delimiter ";" insert into
    ErrorLog;

    Following 3 types of errors/crash occurr's
    1. SqlEditor400.exe Crash with the message Illegal memory reference .
    2. CellViewer : SqlEditor400.exe Crash.
    3. Dr. Watson exception for SQL Editor.
    All these 3 errors are occurring randomly, up till now no pattern is
    begin detected.
    Last edited by plnind; 08-04-03 at 02:28.

Posting Permissions

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