Difference between revisions of "Talk:SQL"
From MidrangeWiki
(Difference between *SYS and *SQL naming) |
(No difference)
|
Latest revision as of 14:55, 21 February 2008
The main difference between *SYS and *SQL naming is how you can reference the schema (library) and table (file name) names.
With *SQL naming you must use the traditional SQL "schema.table" convention, as in SELECT * FROM myschema.mytable. If you do not specify a schema name, DB2 will try to find the table in your current schema (NOT in your library list).
With *SYS naming you use the "library/filename" OS/400 convention: SELECT * FROM libname/filename. If you do not specify a library name the file will be searched in your library list.