Load Ingest Data
Results 1 to 3 of 3

Thread: Specifying Recordset Properties using the SQL Utility (ADO Recordset Object)

  1. #1
    Andre is offline Documentation Manager
    Join Date
    Aug 2006
    Posts
    147
    Rep Power
    14

    Specifying Recordset Properties using the SQL Utility (ADO Recordset Object)

    The SQL Utility enables you specify the following recordset properties:

    • Cursor type
    • Lock type
    • Cache size
    • Maximum number of records retrieved

    To set the recordset properties
    1. Select Query, Recordset Properties or press F4. The Recordset Properties screen is displayed.
    2. Specify the parameters corresponding to the recordset property to be set, as follows:


    • Cursor type: Select the type of cursor from the list:
      • ForwardOnly
      • Keyset
      • Dynamic
      • Static
    Note
    The default value is ForwardOnly, meaning you can only scroll forward in an ADO recordset (note that the SQL Utility caches the rowset to the Grid).
    • Lock type: Select the locking type from the list:
      • Read only
      • Pessimistic
      • Optimistic
      • BatchOptimistic
    The default value is read only.

    • Cache size: Specify the size of the cache for the recordset. The default is -1, which sets the SQL Utility to use the ADO default for the cache size of the recordset.
    • MaxRecord: Specify the maximum number of records that are retrieved. Setting -1 indicates that all rows are returned.
    Note
    To save the changes in the registry, select the Save changes checkbox. The saved values will serve as the new default values.

    3. Click OK.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

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

    How do you save the results in a file

    When I try to save the recordset in a file, I only get the sql select statement? How do I save the retrieve rows in SQL Utility? Thank you.

  3. #3
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14
    Attached is a slightly better version of the AdoDemo, which supports two File options:

    - Save Recordset As

    Allows you to save the result as an XML file. The XML format is the standard ADO format.

    - Load Recordset

    Allows you to load the result (XML) to the AdoDemo.

    Download the AdoDemo

    NOTE: The AdoDemo sample is part of the Attunity Server Windows Kit. The attached version is slightly modified. You can add or improve the basic XML support.
    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
  •