Keywords › Keyword Descriptions › SELRECIF, AND, OR › Syntax

Syntax

SELRECIF({field-name|position[,scan-length]},operator,data[,…])
	   ({field-name|position,scan-length},data-type[,…])
SELRECIF({field-name|position,scan-length},operator,{field-name|position})

AND({field-name|position[,scan-length]},operator,data[,…])
   ({field-name|position,scan-length},data-type[,…])
AND({field-name|position,scan-length},operator,{field-name|position})

OR({field-name|position[,scan-length]},operator,data[,…])
  ({field-name|position,scan-length},data-type[,…])
OR({field-name|position,scan-length},operator,{field-name|position})

You can use the data definition to imply an OR condition. If the data and position are the same, but the values different, you can simply change the data.

SELRECIF(105,15,EQ,C'A+ Widgets,A Widgets')

When the data is different, but the position is the same, you can still use an implied OR by listing the different data values.

SELRECIF(105,15,EQ,C'A+ Widgets',T'A WIDGETS')