SqlDbx
You are not logged in.
Pages: 1
Small bug when using a side scrolling mouse, when one can scroll from side to side using the mouse wheel. The scrolling works fine when focused in a script tab, but does not work when focused in a results tab. The scroll bar at the bottom moves but the selected result cell does not move with it. The two should be synchronized I would have thought.
For DB2 support, please add a function whereby one can right click a table (or indeed multiple tables if selected) and perform a basic RUNSTATS. ie: RUNSTATS ON TABLE ABC.TEST AND INDEXES ALL;
If you wanted to get even more functional, you could add a context menu for WITH DISTRIBUTION and DETAILED INDEXES (or SAMPLED) options etc, but a basic RUNSTATS would at minimum be an excellent feature. Perhaps even a REORG feature could be added at the same time given the similar nature of the command syntax ?
Offline
This is strange. Horizontal scrolling is not supposed to work at all in script window or results. What version of Windows you use?
We do plan to add custom menu items configurable by user, so it will be possible to implement something like RUNSTATS command you describe.
Offline
Well I can assure you it works fine in an active script tab. It kinda works in the results tab whereby it positions the scroll bar but not the active cell. Interestingly when you then click either to the left or right of the respositioned horizontal scroll, it HAS actually moved the scorll position, you just cannot see to where.
Windows 7 Professional SP1 64-bit, SQLDBX 3.52 Personal Edition.
RUNSTATS is not presently recognized as a valid command in SQLDBX, much the same as TRUNCATE wasn't back a few versions ago untill that was added to the right click context menu. The only way to do a RUNSTATS at present is to include the command in a call statement to the ADMIN_CMD stored procedure. How will you populate the table name from a right click context menu if this functionality remains unchanged ?
Offline
Pages: 1