Deal of the Day

Showing posts with label SQL Select. Show all posts
Showing posts with label SQL Select. Show all posts

Thursday 30 June 2011

SQL400 for Beginners Part 2


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