The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Does a simple SELECT * FROM a non-relational (Excel, text file, etc) proxy table preserve the row/record/line ordering in the original file?

This is important to know, for a large class of source files that do not contain ANY data that is suitable for ORDER BY... the initial SELECT must preserve the row ordering... on the SQL Anywhere side an autoincrement column can THEN be used to continue the preservation:

INSERT copy_table ( all-columns-except-the-autoincrement ) SELECT * FROM proxy_table;

asked 31 Aug '10, 14:49

Breck%20Carter's gravatar image

Breck Carter
26.6k418576824
accept rate: 21%


There is no gear in the Remote Data Access layer to preserve row/record/line ordering since no such capability exists within ODBC. As a result you are at the mercy of the underlying ODBC driver (and possibly data source as well). There may be options within the DSN to do the "right" thing, but otherwise, I would say there is no guarantee.

permanent link

answered 31 Aug '10, 15:02

Karim%20Khamis's gravatar image

Karim Khamis
5.6k53870
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×62

question asked: 31 Aug '10, 14:49

question was seen: 630 times

last updated: 31 Aug '10, 15:02