How to read multi member Physical file through SQL?

1215 pts.
Tags:
AS/400
AS/400 SQL
AS400 physical file
How to read multi member Physical file through SQL?

Software/Hardware used:
AS400

Answer Wiki

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

Create an alias – which identifies the file and member.
Then SQL against the alias.

Phil

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
  • TomLiotta
    Using an ALIAS is one of the two general ways to process members. The alternative is to use OVRDBF to choose a member. The choice depends on a couple of factors. An ALIAS is a permanent object that is available to all jobs that are authorized to it. It can require all of the usual maintenance elements that all permanent objects can need. A specific ALIAS points to a specific member. Each member needs a different ALIAS. An OVRDBF override is temporary and limited to the job that creates it. It goes away automatically when the job ends. There are no maintenance issues. An override can point to a different member every time the job runs. Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    And alias takes on the job scope and duration when created in qtemp phil
    49,960 pointsBadges:
    report
  • TomLiotta
    ...alias takes on the job scope and duration when created in qtemp Good point and a useful clarification. Under those conditions, performance becomes the only significant issue. But as long as it's only created/deleted once (or a few times), performance can be ignored. Even in QTEMP, an ALIAS is a "permanent" object. That is, an object description is physically created, ownership attributes are assigned, authorities are granted and a physical address is associated. Most sites won't care nor even notice, so ALIAS in QTEMP can work well. Some high-volume systems will want to keep its "permanance" in mind (in terms of how they're created; not their lifetime). Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Cool towo good ways to deal with the issue. Phil
    49,960 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