Adding and modifying server entries

After you open a session, you can add or modify server entries associated with that session.

When you add or modify a server entry, dscp automatically creates or modifies both master and query lines. The master line and the query line of an interfaces file entry contain identical information.

**Table 5-1: Server attributes**
Attributes	Type of value	Default value and valid values	Can be edited when adding or modifying a server entry
Attributes	Type of value	Default value and valid values	Adding	Modifying
Server Object Version	Integer	110	No	No
Server Name	Character string	N/A	N/A	No
Server Service	Character string	SQL SERVER	Yes	No
Server Status	Integer	4 Valid values are: Active Stopped Failed Unknown	No	No
Transport Type	Character string	tcp. Valid values are: decnet, spx, tcp, tli, spx, tli tcp	Yes	Yes
Transport Address	Character string	None. Valid values are character strings recognized by the specified transport type	Yes	Yes
Security Mechanism	Character string You can add up to 20 security mechanism strings for each server entry	None Valid values are character strings associated with object identifiers defined in the user’s objectid.dat.	Yes	Yes

Enter:

add servername

You are now in add mode. You can continue to add server entries, but you cannot execute any other dscp commands until you exit this mode. While in add mode, dscp prompts you for information about servername.

Do one of the following:

Enter a value for each attribute, or
Press Return to accept the default value, which is shown in brackets [ ]

For example, dscp prompts for the following information when you enter:

add myserver

Service: [SQL Server]
Transport Type: [tcp] tcp
Transport Address: victory 8001
Security Mechanism []:

A server entry can have up to 20 transport type/address combinations associated with it.

For a description of the server attributes, see Table 5-1.

To exit add mode, enter:

#done

You cannot use dscp to modify the Version, Service, and Status entries in the interfaces file.

Enter:

mod servername

You are now in modify mode. You can continue to modify server entries, but you cannot execute any other dscp commands until you exit this mode. In modify mode, dscp prompts you for information about servername.

Do one of the following:

Enter a value for each attribute, or
Press Return to accept the default value, which is shown in brackets [ ]

For example, dscp prompts for the following information when you enter:

mod myserver

Version: [1]
Service: [SQL Server] Open Server
Status: [4]
Address:
Transport Type: [tcp]
Transport Address: [victory 1824] victory 1826
Transport Type: [tcp]
Transport Address: [victory 1828]
Transport Type: []
Security Mechanism []:

For a description of the server attributes, see Table 5-1.

To delete an address, enter:

#del

To exit modify mode, enter:

#done