Difference between revisions of "SQL"
From MidrangeWiki
MrDolomite (talk | contribs) m (2x cat) |
MrDolomite (talk | contribs) m (cleanup; Template:AN Template:bu Template:Seealso and add error SQL7008 about COMMIT(*NONE)) |
||
| Line 1: | Line 1: | ||
| − | + | {{AN}}, or {{bu|S|tructured}} {{bu|Q|uery}} {{bu|L|anguage}}, 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]]. | |
| − | + | {{Seealso|SQL Primer|SOUNDEX}} | |
| − | + | ==Tips== | |
| − | * [[ | + | ;SQL7008 error |
| + | :{{code|&FILE}} in {{code|&LIBRARY}} not valid for operation. | ||
| + | :-- Code 3 -- {{code|&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 {{code|[[RUNSQLSTM]]}} with parameter {{code|COMMIT(*NONE)}} | ||
| + | ==Categories== | ||
[[Category:Programming]] | [[Category:Programming]] | ||
[[Category:SQL|*]] | [[Category:SQL|*]] | ||
[[Category:Query]] | [[Category:Query]] | ||
Revision as of 15:18, 30 March 2007
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)
