Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Allow to export query results to external files.
Thu, May 23 2013 5:50 PMPermanent Link

Mario Enríquez

Open Consult

Tim,

It would be nice to include an statement that allows to EXPORT to an external file the results of a SELECT statement. Just like EXPORT TABLE but from query's or views at least.

The would allow us to better exchange information with other systems. Wink

Regards,
Mario
Fri, May 24 2013 1:16 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Mario,

You can export data from a view - just indicate the name of a view instead of a table.
The syntax is :

EXPORT TABLE <TableName>|<ViewName> TO <FileName> IN STORE <StoreName> ...

--
Fernando Dias
[Team Elevate]
Thu, May 30 2013 12:17 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mario,

<< It would be nice to include an statement that allows to EXPORT to an
external file the results of a SELECT statement. Just like EXPORT TABLE but
from query's or views at least. >>

This has been on the list for a while, and it was almost done at one point.
However, there's a slight snag in the implementation that needs to be
resolved, and then I can move the code back in.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Image