ISPF query tool

Free ISPF query tool for DB2 z/OS.
Download

ISPF query tool Ranking & Summary

Advertisement

  • Rating:
  • 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