db2/400 course content

• what is physical file
• dds for physical file
• creating the physical file in as 400
• inserting data to physical file
• how to see the content of physical file
• KEYWORDS in physical file
• keyword levels in physical file
• PHYSICAL FILE MAINTENANCE COMMANDS in as400
• unique keyword physical file as400
• inserting data INto physical file USING SQL
• field reference file in as400
• REFFLD keyword in db2
• Change Physical File (CHGPF) command
• ADDPFM in as 400
• ovrdbf command in as400
• referential integrity in as400

• logical file in as400
• NONJOIN LOGICAL FILES
• create simple logical in as400
• how to create simple logical file in as400
• how to insert data into pf using logical file
• SELECT AND OMIT LEVEL IN NON JOIN LOGICAL FILE
• WHAT IS JOIN LOGICAL FILE
• HOW TO CREATE JOIN LOGICAL FILE
• DYNSLT (Dynamic Select) keyword
• JDFTVAL (Join Default Values) keyword
• JDUPSEQ (Join Duplicate Sequence) keyword
• CONCAT (Concatenate) keyword
• ALL (All) keyword
• journal in as400