Support ODBC escape for TOP/LIMIT clauses

  • Thread starter Thread starter Sumit Sarkar
  • Start date Start date
Status
Not open for further replies.
S

Sumit Sarkar

Guest
Several BI tools have data source specific SQL customization to support each TOP/LIMIT clause to preview a limited set of data. For example, Informix supports FIRST n; DB2 supports FETCH FIRST n, etc. It would be ideal if an application can issue a query such as SELECT {TOP n} FROM TABLE; and the driver can push the appropriate syntax down to each data source.

Continue reading...
 
Status
Not open for further replies.
Back
Top