Can I use "Load" statement in E/SQL

[pengzhang]

Hi There,

I can use "Load" statement in SQLEditor, but when I tried to use "Load" statement in a E/SQL program, I have some problmes. Does anybody know how (if) I could do this?

Basically, I'm trying to write a program to do automatically and periodly data flushing and load between databases.

And I even had the problem using Truncate in SQLEditor.

Thank you

 

[FCVV]

HI,

You can execute a shell. Such Shell can call a DBACCESS , and the DBACCES will execute a .sql file.

Or
Much Better approach (performance also), try HPL.

Please see:

Guide to the High-Performance Loader, Version 7.3

This manual describes how to access and use the High-Performance Loader (HPL), a feature of Dynamic Server that allows you to load and unload large quantities of data to and from an Informix database

Best Regards,
Francisco Virgilio

 

[pengzhang]

Thanks a lot.

But what I was trying to do is that we need a upload/load program which will do the upload/load when a certain condition happens and it would do the upload/load many times a day. I guess HPL won't meet the requirement.

The program for now is using a cursor to insert row by row. I'm trying to leverage the "Load" statement to make it more efficient. I can try to use a system command to call SQLEditor to load the data. But would it be slow because we invokes another process?

Any thoughts? Thank you again.

 

[pengzhang]

Sorry, me again.

Or if HPL has some programming interface so that I could invoke it from inside a C code, that would be wonderful.

I know Microsft DTS has some COM interfaces allow you programtically scheduling the transformation job. I'm just wondering if Informix HPL has the similar thing.

Thanks

 

[olded]

Hi:

Try looking in the Internation Informix user's group software repository:

http://www.iiug.org/software/software_index.html

They might have something you can use.

Regards,

Ed

 

[pengzhang]

Thanks a lot.

I got a sample code and am currently reviewing.

Regards,

Peng