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.