The application returns a maximum of 100 records when a table is queried or a SQL statement is executed. How do I retrieve more records?
The application as a default returns first 100 records. You can change this by Selecting Tools from the menu bar, select Set Records, and enter the number of records to be retrieved. Enter zero to return all records or simply click on Return All Records. The setting is displayed at the bottom of the application. It is not recommended to return all records from a large table. 4. I am connected to multiple databases or schemas. How do I switch between connections? Just (left) click on the button at the bottom of the screen displaying the connection. Alternatively, select the connection from the drop down box located in the top toolbar. 5. The main screen shows only 16 objects. How do I see the remaining objects? Click on the book icon (on the toolbar below the connection icon) and you will additional objects. Click on it again and you will be returned to the previous screen. 6. What does the Statistics feature of the application? The Statistics tool calculates tstics of data in database
Related Questions
- The application returns a maximum of 100 records when a table is queried or a SQL statement is executed. How do I retrieve more records?
- Does Warehouse Builder have a published metadata model with SQL based query capability and/or an Application Program Interface (API)?
- Are SQL CALs required when only an application is being deployed on an SQL Server?
