SQL

From MidrangeWiki
Revision as of 19:36, 16 November 2007 by Starbuck5250 (talk | contribs) (+ select *)
Jump to: navigation, search

SQL, or Structured Query Language, is a platform independent way of accessing databases. However, the version of SQL which runs on the AS/400, known as SQL400 or SQLDB2, does have syntax differences from standard wikipedia:SQL.

See also: SQL Primer and SOUNDEX

Tips

SQL7008 error
&FILE in &LIBRARY not valid for operation.
-- Code 3 -- &FILE is not journaled, or you do not have authority to the journal. Files with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be journaled to the same journal.
  • Resolution: Use RUNSQLSTM with parameter COMMIT(*NONE)
SELECT *
For the sake of example, use two files, master and trans. We want to select all the columns in trans but only the name column from table master.
If using *SYS naming you can execute SELECT trans.*, name FROM trans JOIN master ON...
If using *SQL naming, we need to use a correlation name: SELECT t.*, name FROM trans t JOIN master ON...
RUNSQL command for ad-hoc SQL statements
"Partner TechTip: Blend SQL and RPGLE to Make Better Tools" by Kevin Forsythe

Categories