Naming of distributed relational database objects

SQL objects are created and maintained as IBM® i objects. You can use either of the two naming conventions in Db2® for i programming: system (*SYS) and SQL (*SQL).

The naming convention that you use affects the method for qualifying file and table names. It also affects security and the terms used on the interactive SQL displays. Distributed relational database applications can access objects on another IBM i platform using either naming convention. However, if your program accesses a system that is not Db2 for i, only SQL names can be used. Names can be specified by using the NAMING parameter on the Start SQL (STRSQL) command, by using the OPTION parameter on one of the CRTSQLxxx commands, or by using the naming connection property for call level interface (CLI) and Java™ Database Connectivity (JDBC).