CMAX Technical Support

Format for Access Query Language sentences:

verb file.name {item.ids} {datanames} {selection.criteria} {sort.specifications} {modifiers} {(options)}

 

Sample AQL sentences:

SORT CUSTOMER.MASTER BY CITY.STATE.ZIP BREAK-ON CITY.STATE.ZIP TOTAL COUNT DET-SUPP ID-SUPP

SORT CM WITH BIRTH.MONTH = "5" BY NAME NAME BIRTH.DATE AGE

LIST IM WITH STORE = "1001" AND WITH STATUS = "I" AND WITH PRODUCT.CODE = "STK1" AND WITH BRAND = "SONY" PRODUCT.CODE BRAND PURCHASE.DATE PURCHASE.COST AGE (P

LIST CM '103464673' '332099887' NAME LAST.ACTIVITY.DATE

 

• Verbs:

LIST
SORT
COUNT
LIST-ITEM / SORT-ITEM
LIST-LABEL / SORT-LABEL
STAT
SUM
SELECT / SSELECT / SAMPLE
SAVE-LIST
GET-LIST

 

• Item-IDs:

'item.id'
'item.id1' 'item.id2' 'item.idn'
> 'item.id'
< 'item.id'
> 'item.id1' AND < 'item.id2'

 

• Selection Criteria:

WITH dataname = "value"
WITH dataname = "value1" {OR} "value2"
WITH dataname = "value1" AND WITH dataname2 = "value2"
WITH dataname1 = "value1" {OR} WITH dataname2 = "value2"
WITH dataname = "[string]"
WITH {NO} dataname
WITH EVERY dataname = "value"
WITH dataname BEFORE "value"
WITH dataname AFTER "value"

 

• Operators:

  <	LT
  <=	LE
  =	EQ
  >	GT
  >=	GE
  #	NE
  NO

 

• Sort Specifications:

BY dataname
BY-DSND dataname
BY-EXP dataname
BY-EXP-DSND dataname

 

• Break Specifications:

BREAK-ON dataname {"message"}

 

• BREAK-ON Options:

B	Inserts data from the attribute specified in the report heading if the B modifier was used with the HEADING modifier.
D	Suppress the break indicator when there is only one detail line.
L	Suppress the blank line before the break message.
P	Skip to a new page at this break.
R	Forces all data associated with a control break to appear on the same page.
U	Underline any TOTAL fields at the break.
V	Output the break value at the break.

 

• TOTALS and GRAND-TOTAL:

TOTAL dataname
GRAND-TOTAL "message"

 

• GRAND-TOTAL Options:

L	Suppress blank line before total.
P	Skip to a new page for the grand total.
U	Underline the total with == signs.

 

• HEADINGs / FOOTINGs

HEADING "message"
FOOTING "message"

 

• HEADING / FOOTING Options:

B	When used with the B option of the BREAK-ON modifier, inserts data from the attribute specified in the report heading.
Bn	Same as B above except insert the specified attribute in a left justified field on 'n' blanks.
C	Center the text.
D	Insert the current date.
F	Insert the name of the file.
Fn	Same as F above except file name is left justified in a field of 'n' blanks.
L	Skips to a new line.
N	Suppress the end of page pause on screen reports.
P	Insert current page number.
Pn	Insert current page number, left justified, in a field of 'n' blanks.
T	Insert the current time and date.

 

• Modifiers and Options:

BREAK-ON
BY / BY-DSND
BY-EXP / BY-EXP-DSND
COL-HDR-SUPP	(C
DBL-SPC
DET-SUPP	(D
EACH / EVERY
FOOTING
GRAND-TOTAL
HEADING
HDR-SUPP	(H
ID-SUPP	(I
LPTR	(P
NO
NOPAGE
TAPE
TOTAL
USING
WITHIN

 

• List Available Files:

LISTFILES
LISTFILES (P

 

• List Available Datanames:

LISTDICT{S} file.name
LISTDICT{S} file.name (P

 

• LIST-LABEL / SORT-LABEL

?count,rows,skip,indent,size,space {,C}

a	count	Number of labels (items) across each page or screen.
b	rows	Number of lines (attributes) printed for each label. Remember to count the item-ID as one line. This attribute is automatically included in the labels unless using the ID-SUPP modifier in the query.
c	skip	Number of lines to skip vertically between labels.
d	indent	Number of indented spaces from the left margin to the label. 0 is a valid response.
e	size	Maximum width for each attribute line (in other words, the width of each label in columns).
f	space	Number of horizontal spaces between labels.
C	C	Specifies that null attributes should not be printed. Otherwise, null attributes appear as all blanks. This parameter is optional.