Where condition in FIND using ACB's or ACBX's


Is there any option of providing a “WHERE” condition when doing a S4 command using the direct call to ADABAS from a COBOL or a PL1 program.

Thanks in advance for your replies.


No. The WHERE clause is a Natural construct, used to apply conditional logic to records returned from a database. Adabas direct commands have no facility to provide such conditional logic.

Thanks a lot for a quick reply.

You can use the non-descriptor search. If you include non-descriptor fields in the Search Buffer, Adabas will apply the search criteria to the records read.

This is not exactly a WHERE clause: if the element is a descriptor, the inverted lists will be used to identify the records to select; if it is not, the records will be read.