SCR/AL1 - TOME II. Les Objets
4. ISAM
4.1 Syntaxe d'un ISAM
isam_defn ::= {
"filename"
[CTREE | CISAM | INGRES | INFORMIX | ORACLE | SYBASE]
[NO_OBJ | DEF_OBJ]
[CRYPT]
[NO_HIST]
[VARLEN]
[BUF_SEARCH]
[DEF_MAX]
[WRITE_FN action]
[REWRITE_FN action]
[DELETE_FN action]
[READ_FN action]
[MODIFY_CATG catg]
[CREATE_CATG catg]
[DELETE_CATG catg]
[SEARCH_CATG catg]
FIELD {external_isf | field_type} [NAME name] [isf_attr] [HSI_FIX]
VFIELD field_type [NAME name] [isf_attr] [HSI_FIX]
...
INDEX {external_idx | index_defn} [NAME name] [ASC | DES] [DUP | NODUP]
...
}
catg ::= nn
external_isf ::= ISAM isam_defn isf_name
| {FOREIGN_KEY | FK} isam_defn code [DELETE] [UPDATE]
field_type ::= CHAR
| SHORT
| SHORT1
| LONG
| AUTO
| DATE
| TIME
| FLOAT
| DOUBLE
| STRING lg
| ZSTRING lg
| MENU [name] menu_defn
isf_attr ::= [REQUIRED] [NL nn] [NC nn] [NLV nn] [NLC nn]
[TODAY] [NB_DEC nn] [FIX_DEC] [DEL_EOF]
[OUTPUT | INPUT | HIDDEN | ACCESSIBLE]
[UPPER | LOWER]
[CENTER | LJUST | RJUST | SQZ | ASIS]
[ALLOWED "string"]
[COMPULSORY | NOT_COMPULSORY]
[FNKEY [name] fnkey_defn]
[HELP "string"]
[TITLE "string"]
[PROMPT "string"]
[FORMAT format_defn]
[CODE isam_defn index_name [= field_name]]
[string]
[NO_OBJ | DEF_OBJ]
[COMMENT "text"]
[HSI_FIX]
external_idx ::= {FOREIGN_KEY | FK} isam_defn idx_name [DELETE] [UPDATE]
index_defn ::= {
field_name[:length]
[SQZ | UPPER | LOWER]
[DEF_OBJ | NO_OBJ]
[GE2EQ {Yes|No}]
...
}
format_defn ::=
for a type DATE : "dd-mm-yyyy" or "mm-dd-yy" ...
for a type TIME : "hh:mm:ss" or "hh:mm" ...
for a type INTEGER : "09 " ..
for a type STRING : "X.X.."
