Difference between revisions of "SQL"
From MidrangeWiki
MrDolomite (talk | contribs) m (cleanup; Template:AN Template:bu Template:Seealso and add error SQL7008 about COMMIT(*NONE)) |
MrDolomite (talk | contribs) m (→Tips: add link to www.mcpressonline.com article with code for RUNSQL custom command) |
||
| Line 8: | Line 8: | ||
:-- 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. | :-- 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)}} | *Resolution: Use {{code|[[RUNSQLSTM]]}} with parameter {{code|COMMIT(*NONE)}} | ||
| + | ;RUNSQL command for ad-hoc SQL statements | ||
| + | :[http://www.mcpressonline.com/mc/.6b4f1e2e "Partner TechTip: Blend SQL and RPGLE to Make Better Tools"] by [http://www.mcpressonline.com/mc/224@@5c0085ad@1@@.6b4f1e2e Kevin Forsythe] | ||
==Categories== | ==Categories== | ||
Revision as of 15:51, 6 April 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)
- RUNSQL command for ad-hoc SQL statements
- "Partner TechTip: Blend SQL and RPGLE to Make Better Tools" by Kevin Forsythe
