SQL and system naming conventions

 

You can use either the system (*SYS) or the SQL (*SQL) naming convention in DB2^® UDB for iSeries™ 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, for REXX, selected through the SET OPTION statement. See Qualification of unqualified object names in the SQL Reference for more details.

 

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

 

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

 

Parent topic:

SQL concepts