Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Export Result Set
Wed, May 30 2012 9:53 PMPermanent Link

IQA

In EDB Manager is there an easy way to EXPORT the Result Set window to
say CSV like we could in DBISAM ?
Wed, May 30 2012 10:26 PMPermanent Link

Raul

Team Elevate Team Elevate

I don't believe so. Quickest workaround might be to create a view based
on your sql and then you can export the view.

You can also export a table but creating a view IMHO is quicker and easier.

Raul

On 5/30/2012 9:53 PM, Phil wrote:
> In EDB Manager is there an easy way to EXPORT the Result Set window to
> say CSV like we could in DBISAM ?
Thu, May 31 2012 3:46 AMPermanent Link

IQA

Thanks Raul, that's perfect.
Wed, Jun 20 2012 12:42 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Phil,

<< In EDB Manager is there an easy way to EXPORT the Result Set window to
say CSV like we could in DBISAM ? >>

I tried adding this recently, and there's some architectural issues with
doing so that I have to overcome (new remote CLI changes need to be made for
the EDB Server).

For now, you can just use:

CREATE TEMPORARY TABLE MyTable AS SELECT....
WITH DATA!

EXPORT TABLE MyTable...!

DROP TABLE MyTable!

in an SQL window in the EDB Manager.  The ! character is the default line
terminator in the EDB Manager for executing multiple statements in a single
query tab/window.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Image