Examples

Establish a search argument to be used by a TBSCAN operation of the table TELBOOK. Assume that LNAME and ZIPCODE are columns in table TELBOOK. Specify a scan direction of forward and terminate the scan when the row value for the LNAME column is equal to "JOHNSON" and the ZIPCODE column is greater than 08007.

• Invoke TBVCLEAR for table TELBOOK
• Set variable LNAME to JOHNSON
• Set variable ZIPCODE to 08007
• Issue this request:

ISPEXEC TBSARG TELBOOK NEXT NAMECOND(LNAME,EQ,ZIPCODE,GT)

Set the program variable BUFFER to contain:

TBSARG TELBOOK NEXT NAMECOND(LNAME,EQ,ZIPCODE,GT)

Set program variable BUFLEN to the length of the variable BUFFER. Issue the command:

CALL ISPEXEC (BUFLEN, BUFFER);

or alternately

CALL ISPLINK ('TBSARG  ','TELBOOK ',' ','NEXT    ',
              '(LNAME,EQ,ZIPCODE,GT)');