If your DBMS supports it, specifies the workstation name when connecting to the database in InfoMaker. 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 InfoMaker.
ASE, SYC Sybase Adaptive Server Enterprise
SNC SQL Native Client for Microsoft SQL Server
Host='workstation_name'
None
For Adaptive Server, when you specify a value for Host, InfoMaker 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 InfoMaker 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 InfoMaker 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.
To set the host name to Alan, type Alan in
the Workstation Name box on the Network page in the Database Profile
Setup dialog box.
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, type Jane in the Workstation Name box and Sales in the Application Name box on the Network page in the Database Profile Setup dialog box.
