Troubleshooting
Problem
How do I save off the results of a query run with
Run SQL Scripts?Resolving The Problem
1) Within
Run SQL Scripts select Edit -> Preferences.2) Select the
General tab on the Preferences dialog box.3) Select (check)
Enable saving or results using scrollable cursors.4) Restart your
Run SQL Scripts connection. 5) Run your query.
6) Right click on those results and the option to
Save Results is now available.
NOTE - you may need to use the retrieve all rows button in the lower right of the interface before saving. This will ensure all the data is saved and not just the data displayed.
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001goLAAQ","label":"IBM i Db2-\u003EACS \/ Navigator \/ Run SQL Scripts \/ ODBC"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Historical Number
N1011114
Was this topic helpful?
Document Information
More support for:
IBM i
Component:
IBM i Db2->ACS / Navigator / Run SQL Scripts / ODBC
Software version:
All Versions
Operating system(s):
IBM i
Document number:
684683
Modified date:
10 September 2024
UID
nas8N1011114
Manage My Notification Subscriptions