Talk:SQL

From MidrangeWiki
Jump to: navigation, search

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.