Advertisements
Recently, while working with a couple of my teammates on different projects I picked up a couple shortcut keys for Aginity for netezza, which I did not know existed. So, I thought about be nice to put a list of shortcut keys for future reference. I don’t use most of them very often, but I have flagged the ones that I have found to be frequently useful. I hope you find this useful as well.
Frequently Used By Me |
Shortcut Keystrokes |
Shortcut Description |
| Alt-C | Complete Code Snippet | |
| Alt-F4 | Exit | |
| Alt-Q | Go to Query | |
| Alt-R | Go to Results | |
| Alt-T | Go to Tree | |
| Atl-H | User Query History | |
| Ctrl-Alt-0 | Goto Bookmark 0 | |
| Ctrl-Alt-1 | Goto Bookmark 1 | |
| Ctrl-Alt-2 | Goto Bookmark 2 | |
| Ctrl-Alt-3 | Goto Bookmark 3 | |
| Ctrl-Alt-4 | Goto Bookmark 4 | |
| Ctrl-Alt-5 | Goto Bookmark 5 | |
| Ctrl-Alt-6 | Goto Bookmark 6 | |
| Ctrl-Alt-7 | Goto Bookmark 7 | |
| Ctrl-Alt-8 | Goto Bookmark 8 | |
| Ctrl-Alt-9 | Goto Bookmark 9 | |
| X | Ctrl-Alt-C | Comment Selection |
| Ctrl-Alt-Left | Goto Previous Bookmark | |
| Ctrl-Alt-Right | Goto Next Bookmark | |
| Ctrl-Alt-Shift-0 | Set Bookmark 0 | |
| Ctrl-Alt-Shift-1 | Set Bookmark 1 | |
| Ctrl-Alt-Shift-2 | Set Bookmark 2 | |
| Ctrl-Alt-Shift-3 | Set Bookmark 3 | |
| Ctrl-Alt-Shift-4 | Set Bookmark 4 | |
| Ctrl-Alt-Shift-5 | Set Bookmark 5 | |
| Ctrl-Alt-Shift-6 | Set Bookmark 6 | |
| Ctrl-Alt-Shift-7 | Set Bookmark 7 | |
| Ctrl-Alt-Shift-8 | Set Bookmark 8 | |
| Ctrl-Alt-Shift-9 | Set Bookmark 9 | |
| Ctrl-Alt-Shift-U | Change select case | |
| X | Ctrl-Alt-U | Uncomment Selection |
| Ctrl-Alt-W | Word Wrap | |
| X | Ctrl-A | Select All |
| Ctrl-B | Toggle Object Browser | |
| X | Ctrl-C | Copy |
| X | Ctrl+Double click object name | Find object in browser panel for current database |
| X | Ctrl-F | Find |
| Ctrl-F5 | Execute as Single Batch | |
| Ctrl-F6 | Next Query Tab | |
| Ctrl-G | Goto Line | |
| Ctrl-H | Replace | |
| Ctrl-N | New Query Window | |
| Ctrl-O | Open SQL File | |
| Ctrl-P | ||
| Ctrl-R | Toggle | |
| Ctrl-S | Save Query | |
| Ctrl-Shift-F6 | Previous Query Tab | |
| Ctrl-Shift-U | Make selection UPPER case | |
| Ctrl-T | Add New Query Editor | |
| Ctrl-U | Make selection LOWER case | |
| Ctrl-V | Paste | |
| X | Ctrl-X | Cut |
| X | Ctrl-Y | Redo |
| X | Ctrl-Z | Undo |
| F11 | Toggle full screen | |
| F12 | Select Query at Cursor | |
| X | F3 | Find Again |
| F5 | Execute | |
| F8 | Explain | |
| F9 | Toggle Bookmark | |
| Shift-F5 | Execute All |
Related References
- Aginity For Netezza – How to Generate DDL
- Aginity for Netezza – How to Display Query Results in a Single Row Grid
- Netezza / PureData – How to rebuild a Netezza view in Aginity
- Aginity Workbench for PureData /Netezza System for Analytics – Useful links
- Aginity for Netezza – How to disable and/or Enable the Autocomplete Function