Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
Order in EXPORT TABLE statement |
Tue, Mar 26 2013 12:19 PM | Permanent Link |
Francisco Fernandez NewTRON Informatica | Hi all.
Any way to export a table using EXPOR TABLE statement with an order?. I'm exporting a table and I don't know what order takes the csv file to export rows. Thank's and regards. |
Tue, Mar 26 2013 3:18 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Francisco,
<< Any way to export a table using EXPOR TABLE statement with an order?. I'm exporting a table and I don't know what order takes the csv file to export rows. >> At the moment, no. The export/import uses raw access to the tables for performance reasons. However, I'll see about adding an option to specify the ordering. As a workaround, you can define a VIEW with an ORDER BY and then export it using EXPORT TABLE. If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com |
Wed, Mar 27 2013 4:47 AM | Permanent Link |
Francisco Fernandez NewTRON Informatica | Ok.
Thank's and regards. |
Wed, Mar 27 2013 5:18 AM | Permanent Link |
Francisco Fernandez NewTRON Informatica | Hi again.
I have tryed exporting an ordered view and when I export data the csv file don't take the order of the view, may be I'm doing anything wrong but I don't know. Thank's. |
Wed, Mar 27 2013 12:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Francisco,
<< I have tryed exporting an ordered view and when I export data the csv file don't take the order of the view, may be I'm doing anything wrong but I don't know. >> Darn it, forget what I said - the view is going to suffer from the same issue as before. I'm just going to have to change the way that EDB opens the table for the export. Sorry about that, Tim Young Elevate Software www.elevatesoft.com |
Wed, Mar 27 2013 1:35 PM | Permanent Link |
Francisco Fernandez NewTRON Informatica | Tim.
Don't worry, I've solved the problem importing the csv file to a memory ClientDataSet and handle it instead. |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |