SQL and system naming conventions

You can use either the system (*SYS) or the SQL (*SQL) naming convention in Db2® for i programming.

The naming convention used affects the method for qualifying file and table names and the terms used on the interactive SQL displays. The naming convention used is selected by a parameter on the SQL commands or by using the SET OPTION statement.

System naming (*SYS)

In the system naming convention, tables and other SQL objects in an SQL statement are qualified by schema name in the form: 

schema/table
or 
schema.table

SQL naming (*SQL)

In the SQL naming convention, tables and other SQL objects in an SQL statement are qualified by schema name in the form: 

schema.table