DB2 10.5 for Linux, UNIX, and Windows

DB2Connection.SystemNaming property

Specifies whether the system naming mode or the SQL naming mode is used for a connection to the DB2® for i server.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax

[Visual Basic]
Public Property SystemNaming As Boolean
[C#]
public Boolean SystemNaming {set; get;}
[C++]
public: __property void set_SystemNaming(Boolean);
public: __property Boolean get_SystemNaming();
[JScript]
public function set SystemNaming(Boolean);
public function get SystemNaming() : Boolean;

Property value

A boolean value:

True: The DB2 for i system naming mode is used. File names are qualified with the slash (/) delimiter. Unqualified file names are resolved with the library list for the job.
False: The SQL naming mode, which is the default value. File names are qualified with the period (.) delimiter. Unqualified file names are resolved with either the default library or the current user ID.

Remarks

The SystemNaming property is valid only for a connection to DB2 for i V7R1 and later servers with PTF SI46944.

Example

The following example enables the DB2 for i system naming mode:

[C#]
   DB2Connection myConnection = new DB2Connection();
   myConnection.ConnectionString = "DATABASE=SAMPLE;";
   myConnection.SystemNaming=true;
   myConnection.Open();