Previous Topic: DQL ExampleNext Topic: Understanding Your Tasks


Results

Here is how the report from either query looks:

  LAST-NAME                       FIRST-NAME SOCIAL-SECURITY
  ------------------------------  ---------  -------------
  SMITH                           JOHN       098765432
  THOMAS                          ARLENE     987654321
  VICTOR                          ROBERT     234567890
  WILSON                          JAMES      123456789

CA Dataquery provides a wide variety of common reporting capabilities, within the query and also within the reporting functions that present the query output. For instance, a query can sort the information by state, city, zip code, or any category that seems logical. Another query can retrieve only data for a certain state or city. You can use PF keys and online panels to rearrange the report columns or display the rows one at a time. A query can even include data from additional database tables.