If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Load From Problem using SQLEdtoe400.exe

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-01-03, 02:33
plnind plnind is offline
Registered User
 
Join Date: Aug 2003
Posts: 1
Lightbulb "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 01:28.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On