Host

Description

If your DBMS supports it, specifies the workstation name when connecting to the database in DataWindow Designer. The Host parameter lets you assign any 10-character label to identify the process you are about to create when you connect to the database. This label helps you distinguish your process from others running on the database server.

When to specify Host You must specify the Host parameter before connecting to the database in DataWindow Designer.

Applies to

SYC Sybase Adaptive Server Enterprise

Syntax

Host = 'workstation_name'

Default

None

Usage

When you specify a value for Host, DataWindow Designer sets the CS_HOSTNAME connection property to the workstation name you specify.

The value you specify for the Host parameter displays in the hostname column of the MASTER.DBO.SYSPROCESSES table in a SQL Server database. How you use the Host parameter depends on the design of your DataWindow Designer application.

For example, many sites want to secure their production tables so that updates are possible only through a specific application. To do this, you can grant explicit authority to the DataWindow Designer application but not to users. The application prompts the user for an authorization ID and password, verifies it, and then connects to the database through a single application login ID. Only this application login ID has authorization to update production tables.

In this scenario, you can use the Host parameter to store the name of the user running the application.

Examples

Example 1

To set the host name to Alan:

Database profile Type the following in the Workstation Name box on the Network tab in the Database Profile Setup dialog box:
```
Alan
```
Application Type the following in code:
```
SQLCA.DbParameter = "Host='Alan'"
```

Example 2

You can use the Host and AppName parameters together to specify both the host name and the application name. To set the host name to Jane and the application name to Sales:

Database profile Type Jane in the Workstation Name box and Sales in the Application Name box on the Network tab in the Database Profile Setup dialog box.

Application Type the following in code:

SQLCA.DbParameter = "Host='Jane',AppName='Sales'"