Performing Query Functions › Charge Query Panels › Charge Query Specifications Entry Field Options

Charge Query Specifications Entry Field Options

CA PMA Chargeback supports standard SQL queries. The format of the SQL query is:

SELECT fieldname FROM tablename WHERE (condition) {ORDER BY fields}

The following sections discuss how to use the various entry fields with the processing options to generate SQL queries that:

• SELECT fields from the CCCTAB or CCCMOD tables (see A below)
• Choose a table to retrieve information FROM (see B below)
• Choose only select records for viewing WHERE (HAVING) certain conditions are true (see C and D below)
• Optionally view results in a particular order (see E below)

  USERID                     CA PMA Chargeback                MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
 
 
 +-- CBQQRYS ------------- Charge Query Specifications ------------------------+
 |      Panel   Exit   Help                                                    |
 | -----------------------------------------------------------------------B.-- |
 | Type information for Query CPUCOST   Desc CPU COST FOR PER.1-3    Table TAB |
 |                                                                             |
 | Summarize N  Break N  Bud/DBCR N   A.   E.   Version : PROD PROD            |
 |                                   Brk Srt                            Op Sum |
 | ORD Type . . . .                   N      Rec Count                   > SUM |
 | Charge Element .                   N      Units  . .     D.           > SUM |
 | Qualifier  . . .                   N      Rate . . .                  > AVG |
 | Period Number  .       thru    C.  N      Charge . .                  > SUM |
 | DIVISION . . . .                   N                                        |
 | DEPARTMENT . . .                   N                                        |
 |                                                                             |
 |                                                                             |
 |                                                                             |
 |   F2=Exec   F5=Save   F6=Delete   F11=Refresh                               |
 +-----------------------------------------------------------------------------+
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp

In the following sections, each entry option is discussed and then followed by usage example(s).