How to check a perticular record

5 pts.
Tags:
AS/400
IBM iSeries
Physical File
How to check a perticular record in aphysical file without using READ and CHAIN

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

If your file is keyed and you want to check that the key exists, you can use SETLL to check the existance of a record. USe the Equal indicator to see whether a record exists with your key. It’s also possible to use embedded SQL for this, but that’s probably overkill.

Regards,

Martin Gilbert.

==========================================================

It depends on your definition of “check”. Check for existence will be as Martin says, though it does require a key value. In that sense, the check is for whether or not a particular key value exists in the index. The existence of the key directly implies the existence of a record.

But if “check” means to check the content of a record, then you must actually read the record. READ and CHAIN are the two main record input operations (in RPG; with variations such as READE and READP).

Tom

Discuss This Question: 1  Reply

 
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
  • Denny Cherry
    In what language are you writing this?
    66,270 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