Access File Syntax

Each declaration consists of a list of attribute and value pairs, separated by commas. The list is free form and can span several lines. Attributes can be specified in any order. Each declaration ends with a comma followed by a dollar sign (,$).


Top of page

Example: Creating an Access File Containing Three Declarations

The following example illustrates how to create an Access File with declarations consisting of attribute and value pairs:

SSCHEMA=PAYROLL,RELEASE=14.0,INDEXAREA=PRIMARY-IX-AREA,$
SEGNAME=ACCOUNT,RECORD=PAYREC,AREA=PAY-REGION,
    CLCFLD=EMPLOYEE_ID,CLCDUP=N,$
IXSET=IXREC-SSN,IXAREA=IX-AREA1,IXFLD=PERS_SSN,
    IXDUP=N,IXORD=A,$

Blank lines and lines starting with a dollar sign ($) in column 1 are treated as comments. Leading and trailing blanks around attributes and values are ignored. Values that contain commas, equal signs, dollar signs, or spaces must be enclosed in single quotation marks.


Information Builders