DB2Connection.SystemNaming property
Specifies whether the system naming mode or the SQL naming mode is used for a connection to the Db2® for IBM® 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 IBM 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 IBM i V7R1 and later servers with PTF SI46944.
Example
The following example enables
the Db2 for IBM i system
naming mode:
[C#]
DB2
Connection myConnection = new DB2
Connection();
myConnection.ConnectionString = "DATABASE=SAMPLE;";
myConnection.SystemNaming=true;
myConnection.Open();