ISPF query toolFree ISPF query tool for DB2 z/OS. | |
Download |
ISPF query tool Ranking & Summary
Advertisement
- License:
- Freeware
- Publisher Name:
- Cardett Associates Ltd.
- Publisher web site:
- Operating Systems:
- Windows 2003/XP/2000/Me/NT
- File Size:
- 58KB
ISPF query tool Tags
ISPF query tool Description
Main features of the ISPF query tool the program runs on z/OS (ISPF), so runs very fast because it is close to the data source. you can view a table by simply typing the table name (how many hundreds of times have you typed "select * from"? No more). you can easily display all the tables in your system, or within given criteria. you can easily display the definition of a table (eg. columns in the table). you can enter any SQL statement, both Selects and non-select Statements. your SQL statement and the results from it are displayed on the same screen. You don?t have to switch between ?Edit Query? and ?Run Query? modes as you do on many other systems. having displayed the rows of a table / results of a query, you can view the Details of an individual row. queries can be saved. you can scroll through a table without limit on the number of rows. if you update a table you will be prompted to commit or rollback. This prevents inadvertent updating of data. you can switch into EXPLAIN mode. Your queries will be Explained without being run. This is useful for checking SQL syntax and for getting cost estimates of various alternatives, without actually running the SQL.
ISPF query tool Related Software