Naming of distributed relational database objects

 

SQL objects are created and maintained as i5/OS^® objects. You can use either of the two naming conventions in DB2 Universal Database™ for iSeries™ 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 System i™ platform using either naming convention. However, if your program accesses a system that is not DB2^® UDB for iSeries, 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).

• System (*SYS) naming convention
  When you use the system naming convention, files are qualified by library name in the form library/file.

• SQL (*SQL) naming convention
  When you use the SQL naming convention, tables are qualified by the collection name in the form collection.table.

• Default collection name
  You can specify a default collection name to be used by an SQL program by supplying this name for the DFTRDBCOL parameter on the CRTSQLxxx command when you precompile the program.

 

Parent topic:

Programming considerations for a distributed relational database application

 

Related reference

Naming conventions