Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 11 of 11 total
Thread External module procedure
Mon, Feb 16 2009 3:17 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dan,

<< A simple import in csv format is a good idea. >>

Duh, I also forgot one simple thing.  You could use stores to accomplish the
creation/querying of such data:

1) Create the CSV file in the external module and write it to a local store
on the server.
2) Using the remote session on the client, import the CSV file into a
temporary table that you create for just this purpose (CREATE TEMPORARY
TABLE).
3) Use the IMPORT TABLE statement to import the CSV file into the temporary
table.
4) Now you can query this table, etc. just like any other table.
5) Drop the temporary table when you are done with it.

The entire sequence of events above all takes place on the ElevateDB Server.

You can find out more about stores here:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=20

--
Tim Young
Elevate Software
www.elevatesoft.com

« Previous PagePage 2 of 2
Jump to Page:  1 2
Image