Data Replication 2
Results 1 to 4 of 4

Thread: maximum rows

  1. #1
    lsabster is offline Junior Member
    Join Date
    Oct 2006
    Posts
    29
    Rep Power
    0

    maximum rows

    Hello,

    We have an datasource that may need to return about one million rows.
    Is there a row limit by using SQL Utility. I looked in the reference guide, and it does not say if there is a rowlimit.

    We were using Excel, but the version we are using can only return about 50,000 rows.

    If I were to do a

    nav_util execute datasource sql.txt out.txt

    Is this a good way to extract data. What is the exact syntax for Windows or Unix. Thank you.

  2. #2
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14

    Limit To

    Hi

    The Query processor of Attunity Connect supports the LIMIT TO syntax which enables you in the SQL statemnet to determine how many rows you want to get back - e.g. select * from nation LIMIT TO 10 rows (it will give you only 10 rows back)- for more details refer pls to the documentation and search for the LIMIT TO syntax.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    lsabster is offline Junior Member
    Join Date
    Oct 2006
    Posts
    29
    Rep Power
    0

    maximum rows

    Is there an upper limit to the no. of rows in the SQL Utility? Will this utility be able to return one million rows? Thank you.

  4. #4
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    SQL Utility is a demo ADO program written in VB6 - the sources are in the samples demo directory. This utility load all data to be displayed in a grid so I think 1,000,000 is way beyond it capability.

    NAV_UTIL, on the other hand, can be used to dump a table (just capture the output it prints to the console) but it is not designed for this task.

    You did not describe exactly what you want to do but there are many tools (free tools too) that use ODBC or ADO to extract data into text files. Also if you have the Microsoft Office suite then you can use MS-Access for this task too.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •