SQL
From MidrangeWiki
Revision as of 15:18, 30 March 2007 by MrDolomite (talk | contribs) (cleanup; Template:AN Template:bu Template:Seealso and add error SQL7008 about COMMIT(*NONE))
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
&FILEin&LIBRARYnot valid for operation.- -- Code 3 --
&FILEis 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
RUNSQLSTMwith parameterCOMMIT(*NONE)
