Hi Guys....
Welcome back… Today I would share more in SQL400….
Getting Started
Interactive SQL/400 can be run from the Command line. Invoke STRSQL {Start SQL/400} and get at what looks like another command line, where we can key in SQL statements for immediate execution, and/or use the F4 Prompt function to navigate IBM DB2/400 data base, which is a version of UDB
SQL CONCEPTS
• Using basic SQL statements and clauses
• The SELECT clause
• Specifying a search condition using the WHERE clause
• ORDER BY clause
• Date/Time arithmetic
• Creating and using ALIAS names
• Creating descriptive labels using the LABEL ON statement
• Describing an SQL object using COMMENT ON
