Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
Effective in version 6.3, when you connect to the Data Vault through a JDBC or an ODBC connection, you can limit the number of rows in the query results. For example, you might want to see a few rows in the results to verify that a query generates the results correctly.
To limit the number of rows in the results, add the
LIMIT
condition to the
SELECT
statement.
Use the following syntax:
<SELECT statement> LIMIT <maximum number of rows in the results>;
Example:
The following statement limits the results to the first 5 rows of the Accounts table.
SELECT col1, col2 FROM Accounts LIMIT 5;
Previously, you could use the LIMIT function only if you connected to the Data Vault through the ssasql Command Line Program.