Download SELCOPY Manual
Transcript
ADABAS Processing STARTISN=n KEY See also: • KEY= in section Operation Words, Parameters and Keywords. The KEY parameter for ADABAS, plus argument, allows reading a record with a specified key which matches the Descriptor Field coded on the SEQ parameter. A default STOPAFT=1 is applied where the KEY specified is a literal. Note the EQU statement which allows the abbreviation of repetitive coding. EQU SQFMT RD #7 ADA RD #7 ADA SEQ=BB FORMAT='AB,AN,BB,BH,BN,BZ.' KEY='ABCD ' SQFMT * Default S=1. KEY=5 AT 280 SQFMT * No STOPAFT. STARTKEY The STARTKEY parameter, synonym START, plus argument, allows sequential reading which starts with a record having a specified key which matches the Descriptor field coded on the SEQ parameter. Subsequent action of READ STARTKEY operations will return the next sequential record in SEQ=dd sequence. SEQ=dd must also be coded. There is no default STOPAFT associated with STARTKEY. EQU SQFMT RD #7 ADA RD #7 ADA SEQ=BB FORMAT='AB,AN,BB,BH,BN,BZ.' STARTKEY=5 AT 280 SQFMT * No default STOPAFT. STARTKEY 'ABC ' SQFMT * No default STOPAFT. SEARCH See also: • Syntax without SSA in section IMS and DL/1 Processing. The SEARCH parameter, synonym SRCH, for ADABAS is supported in the same way as for the DL1 data base, but without the Relational Operator. The SEQ parameter is optional when SEARCH is used. If SEQ is omitted, the selected fields are returned unsorted, in ISN sequence. If SEQ=aabbcc is coded, the selected fields for each ISN are returned after sorting the ISNs into the sequence aabbcc, where aa, bb and cc are ADABAS Key Field names. 1, 2 or 3 ADABAS Key Field names may be used. Note that, because ADABAS storage is used for holding the resulting ISN List, if a SEQ parameter is coded it becomes necessary for ADABAS to obtain the full list in storage for sorting. Thus, ADABAS Error 001 (Insufficient Storage) could be encountered if the number of ISNs satisfying the SEARCH argument requires more storage than has been allocated to ADABAS when initiated. EQU SEQFMT1 RD #7 ADA SEQFMT1 SEQ=AB FORMAT='AB,AN,BB.' SRCH=200 'XYZZ009526TTT' SRCH=200 above is assuming position 200 onwards in the workarea to have been set up with a valid Search Buffer for ADABAS. RD #7 ADA RD #7 ADA RD #7 ADA SEQFMT1 SRCH='sb data.' SEQFMT1 SRCH='sb data.' FMT 'AA,BB.' SRCH=200 'field values lit' POS 4001 LEN=22 POS 4001 LEN=22 Changing SEARCH data has no effect until EOF is reached on the previous search. EXCL The EXCL parameter, if coded on one or more statements referencing an ADABAS file, indicates that Exclusive Control is required for that file. 2014-08-07 10:16:24 SELCOPY Manual 290