IBM DB2 for i

STRSQL Enhancement

Many iSeries & AS/400 programmers still use the green-screen interactive SQL interface (STRSQL). One issue, however, with this SQL interface is that the F9 key did not behave like it does on other OS/400 5250 interfaces. The F9- key on most OS/400 5250 interfaces such as the QCMD command line provides a retrieve function that retrieves the source for previously executed commands. STRSQL supported the F9 retrieve function, but it only would retrieve the last SQL statement - no matter how many times the F9 key was pressed. In contrast, if the F9 key was pressed two times on the QCMD interface it would retrieve the second to last executed command; if the F9 key was pressed again then the command source for the third to last command would be retrieved.

The PTFs listed below now bring that same capability to cycle through all of the previously executed statements using the F9 key in an interactive SQL session. Instead of the F9 key only retrieving the last executed SQL statement, you can now cycle through all of the previously executed commands.

V5R1 - SI08965
V5R2 - SI08966