STRSQL - AS400 (IBM i) – PF/LF | AS400 Tutorial for beginners Part 9
1. Database in AS400
a. What is DB2?
b. Why we need a database?
2. Physical File (PF) – SQL table
3. Logical File (LF) – SQL view
4. Create, query and update.
5. STRSQL, UPDDTA
6. Commitment Control should always be *CHG!
7. Save query output in new temp files.
PF = Physical File = SQL table
LF = Logical File = View on SQL table
Field = Column name
Records = Row
#AS400 #DB2 #database #sql #strsql #query #pf #lf
