What is the difference beween %found and %equal?

770 pts.
Tags:
AS/400
CHAIN
SETLL
What is the difference between %found and %equal? With SETLL we can use both %found and %equal but with CHAIN we can use only %found. It will be good if someone can please clarify this.

Software/Hardware used:
AS400

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb

    Setll %equal means that an exact match to the key exists and the pointer has been positioned at it.

    Setll %found It found and positioned to a row but not necessarily an exact match to the key. 

    Chain %found The system found an exact match for the key and retrieved the record.

    49,435 pointsBadges:
    report
  • ankit2002
    Why cannot we used %equal for CHAIN Operation....?
    770 pointsBadges:
    report
  • philpl1jb

    Because that was not coded in the compiler by IBM.

     

    49,435 pointsBadges:
    report
  • TomLiotta

    SETLL is "Set Lower Limit". It is not "Set Equal".

    SETLL can give three results: (1) found and not equal, (2) found and equal, and (3) not found and not equal. A 'lower limit' does not have to be 'equal'.

    CHAIN has never set an 'equal' condition. It only sets 'no record' on or off. When using the builtin functions, it becomes 'found' or 'not found'.

    As Phil correctly says, it's because IBM coded the language that way.

    Tom

    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following