Home > IT Answers > Business Intelligence > can anybody tell me how to know max sal in db2/400 means in pf
Siru
15 pts.
 can anybody tell me how to know max sal in db2/400 means in pf
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
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  January 18, 2010  6:29 pm  by  CharlieBrowne   32,915 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,915 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Perhaps a column named Sal (salary) in a table named ??? employee???

philpl1jb
 44,190 pts.
 

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

Kundankumar 83
 75 pts.
 

SELECT MAX(SALARY) FROM LIBRARY/PFILE

here salary is your field name in PFILE

chenthil
 465 pts.