Kbase P147003: SQL Explorer only outputs 101 records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/05/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL Explorer only outputs 101 records
A simple SELECT query is used to fetch records from a table
FACT(s) (Environment):
The output file only contains 101 records
The table has over 800 records
Connecting to the sqlexp using the character client with -infile and -outfile as:
sqlexp -db <db name> -S <port#> -H <localhost> -user <dba user name> -password <dba password> -infile mysql.sql -outfile mysql.out
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
CAUSE:
The default FetchLimit of the SQL Explorer is 101. So it will only fetch 101 records if used in a batch where there is no prompt respose for fetching more records after SQL Explorer fetched 101 records.
FIX:
Increase the FetchLimit of the SQL Explorer by modifying the SQLExplorer.properties file and edit the "FetchLimit=" from 101 to 1000, and save the file. Then r-run the query again.
The FetchLimit of the SQL Explorer can also be set after the login by using the following on the SQLExplorer prompt:
@FetchLimit 1000
If you use "@Show" without the double quotes on the SQLExplorer prompt, it will show the current property settings. After setting the FetchLimit to 1000 using the above statement, you can use "@Show" again, which will show the changed FetchLimit property.