can anybody tell me how to know max sal in db2/400 means in pf

15 pts.
Tags:
DB2
DB2/400
PF
can anybody tell me how to know max sal in db2/400 means in pf

Software/Hardware used:
software
ASKED: January 18, 2010  1:07 PM
UPDATED: January 20, 2010  5:58 PM

Answer Wiki

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

I am not familiar with max sal on the AS400,
A PF has two maximum values.
1. Max Size – Which determines that maximum number of records
2. Max Mbrs – Which determines the maximum number of members in a PF. This is usually 1.

Please let use know where you found this max sal displayed and we will be able to help you out.

Discuss This Question: 3  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
    Perhaps a column named Sal (salary) in a table named ??? employee???
    48,575 pointsBadges:
    report
  • Kundankumar 83
    You can use SQL query for that purpose. 1. Select * from employee _table where salary = ( Select max(Salary) from employee_table) 2 Select Max(salary) from employee_table
    75 pointsBadges:
    report
  • chenthil
    SELECT MAX(SALARY) FROM LIBRARY/PFILE here salary is your field name in PFILE
    465 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