.NET Connector Method Reference

.NET Connector Method Reference

Show / Hide Table of Contents
  • Attachmate.Verastream.HostIntegrator.E2V
    • Area
    • ExtraArea
    • ExtraOIA
    • ExtraScreen
    • ExtraSession
    • ExtraSessions
    • ExtraSystem
    • OIA
    • Screen
    • Session
    • Sessions
    • System
  • Attachmate.Verastream.HostIntegrator.EAO2V
    • ATM_AREA
    • ATM_FIELDTYPE
    • ATM_FINDFIELD
    • ATM_OIA
    • ATM_OIA_ERRORSTATUS
    • ATM_OIA_OWNER
    • ATM_OIA_XSTATUS
    • ATM_SESSION_STATE
    • ATM_WRAP
    • AtmConTN3270
    • AtmConstants
    • AtmScreen3270
    • AtmSession
    • AtmSessionConstants
    • IAtmConTN3270
    • IAtmOia3270
    • IAtmScreen3270
    • IAtmSession
    • IAtmWait
  • WRQ.Verastream.HostIntegrator
    • AidKey
    • AttributeMetaData
    • Color
    • ColumnMetaData
    • ColumnType
    • ElementLocation
    • ElementType
    • ErrorMessage
    • FieldMetaData
    • HostIntegratorChannelException
    • HostIntegratorConnectorException
    • HostIntegratorDeadSessionException
    • HostIntegratorException
    • HostIntegratorMarshallerException
    • HostIntegratorModelDataException
    • HostIntegratorModelDefException
    • HostIntegratorRejuvenationSession
    • HostIntegratorServerException
    • HostIntegratorSession
    • HostIntegratorTerminalException
    • HostIntegratorTimeoutException
    • HostIntegratorUserException
    • InputFieldInfo
    • LoggingLevel
    • MetaData
    • MetaDataType
    • ModelDataColumn
    • ModelDataTable
    • OperationMetaData
    • ProcedureMetaData
    • ProcedureType
    • RcConst
    • RecordSetMetaData
    • RegionType
    • RejuvenationAidKey
    • RejuvenationEnablementMode
    • RejuvenationMethod
    • Screen
    • ScreenField
    • ScrollMovement
    • SessionType
    • TerminalAttributes
    • TerminalField
    • TerminalScreen
    • VariableInitialization
    • VariableMetaData
    • VariableType

Class HostIntegratorSession

HostIntegratorSession is the primary class used to communicate with the Host Integrator Server.

Inheritance
object
HostIntegratorSession
HostIntegratorRejuvenationSession
Inherited Members
object.ToString()
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
Namespace: WRQ.Verastream.HostIntegrator
Assembly: WRQ.Verastream.HostIntegrator.dll
Syntax
public class HostIntegratorSession
Remarks

The methods and properties in the HostIntegratorSession class interact with a host session.

Constructors

HostIntegratorSession()

HostIntegratorSession class CTOR

Declaration
public HostIntegratorSession()

Properties

ConnectionTimeout

Gets or sets how long Host Integrator continues attempting to establish a connection if for any reason the connection cannot be established on the first try (in seconds).

Declaration
public virtual int ConnectionTimeout { get; set; }
Property Value
Type Description
int

This property gets or sets how long Host Integrator continues attempting to establish a connection if for any reason the connection cannot be established on the first try (in seconds).

Remarks

This property is useful, for example, if the server is temporarily unable to allow any more sessions, or if the domain load has been reached. Connection attempt information, including the number of connection attempts and the time of those attempts, is written to the log.

The default value is 30 seconds.

ErrorScreen

ErrorScreen property

Declaration
public virtual TerminalScreen ErrorScreen { get; }
Property Value
Type Description
TerminalScreen

IsConnected

Gets whether the Host Integrator server session is connected.

Declaration
public virtual bool IsConnected { get; }
Property Value
Type Description
bool

Gets whether the Host Integrator server session is connected.

Remarks

This property returns True if HostIntegratorSession believes it is currently connected to a Host Integrator server session. This property does not actually perform a server operation to determine whether a connection is present. It is possible for the connection to have been lost without the connector detecting it. So isConnected might return True even when a connection is not present.

IsSecureConnection

Gets whether the Host Integrator server session is using an encrypted connection.

Declaration
public virtual bool IsSecureConnection { get; }
Property Value
Type Description
bool

Gets whether the Host Integrator server session is using an encrypted connection.

Remarks

Returns True if the connection is encrypted; False otherwise.

MetaDataOnly

Sets or gets whether the current session is "metadata only."

Declaration
public virtual bool MetaDataOnly { get; set; }
Property Value
Type Description
bool

Sets or gets whether the current session is "metadata only."

Remarks

A metadata only session does not require a host connection and allows only methods and properties that interact with metadata. You must set MetaDataOnly to true before you use a Connect method.

Once a connect method has been called, and before the Disconnect method has been called, any attempt to change the value of the MetaDataOnly property will generate an error with this text: "The MetaDataOnly property cannot be changed while a connection is active."

When a client connects with MetaDataOnly set to true, the server will not report the connection as a session, and will not allocate a new session or a session from a pool. There will be no indication in the Admin Web Station or Session Monitor that there is an active client connection.

Exceptions
Type Condition
HostIntegratorException

Thrown if session is already connected

MethodTimeout

Gets or sets the method timeout for a Host Integrator server session (in milliseconds).

Declaration
public virtual int MethodTimeout { get; set; }
Property Value
Type Description
int

Gets or sets the method timeout for a Host Integrator server session (in milliseconds).

Remarks

This property fails if a server session has not been established.

ModelName

Gets the name of the Host Integrator model for the current session.

Declaration
public virtual string ModelName { get; }
Property Value
Type Description
string

Gets the name of the Host Integrator model for the current session.

Remarks

If a session is not active, this method returns null.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

ModelVersionString

Gets the version of the model.

Declaration
public virtual string ModelVersionString { get; }
Property Value
Type Description
string

Gets the version of the model.

Remarks

The string returned uniquely identifies the version of the model deployed to the Host Integrator server.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

ServerName

Gets the name of the Host Integrator server for the current session.

Declaration
public virtual string ServerName { get; }
Property Value
Type Description
string

Gets the name of the Host Integrator server for the current session.

Remarks

When there is no current session, this property returns null.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

SessionType

Gets the terminal emulation type of the host session.

Declaration
public virtual SessionType SessionType { get; }
Property Value
Type Description
SessionType

The value returned is a member of the SessionType enumeration.

Remarks

Gets the terminal emulation type of the host session.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

Methods

ConnectToModel(string, string)

Establishes a connection to a Host Integrator server and creates a host session with the specified model.

Declaration
public virtual void ConnectToModel(string server, string modelName)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string modelName

Specifies the name of a Host Integrator model.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid model name.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToModel(string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates a host session with the specified model.

Declaration
public virtual void ConnectToModel(string server, string modelName, IDictionary modelVariables)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string modelName

Specifies the name of a Host Integrator model.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid model name.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToModel(string, string, string, string)

Establishes a connection to a Host Integrator server and creates a host session with the specified model.

Declaration
public virtual void ConnectToModel(string server, string modelName, string userid, string password)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string modelName

Specifies the name of a Host Integrator model.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid model name.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToModel(string, string, string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates a host session with the specified model.

Declaration
public virtual void ConnectToModel(string server, string modelName, string userid, string password, IDictionary modelVariables)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string modelName

Specifies the name of a Host Integrator model.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid model name.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToModelViaDomain(string, string, string)

Establishes a connection to a Host Integrator server and creates a host session with the specified model. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToModelViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToModelViaDomain(string directoryServer, string domain, string modelName)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string modelName

Specifies the name of a Host Integrator model.

Remarks

Reasons for failure include:

  • Failure to locate Host Integrator domain server.
  • Invalid model name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToModelViaDomain(string, string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates a host session with the specified model. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToModelViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToModelViaDomain(string directoryServer, string domain, string modelName, IDictionary modelVariables)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string modelName

Specifies the name of a Host Integrator model.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Failure to locate Host Integrator domain server.
  • Invalid model name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToModelViaDomain(string, string, string, string, string)

Establishes a connection to a Host Integrator server and creates a host session with the specified model. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToModelViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToModelViaDomain(string directoryServer, string domain, string modelName, string userid, string password)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string modelName

Specifies the name of a Host Integrator model.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

Remarks

Reasons for failure include:

  • Failure to locate Host Integrator domain server.
  • Invalid model name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToModelViaDomain(string, string, string, string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates a host session with the specified model. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToModelViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToModelViaDomain(string directoryServer, string domain, string modelName, string userid, string password, IDictionary modelVariables)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string modelName

Specifies the name of a Host Integrator model.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Failure to locate Host Integrator domain server.
  • Invalid model name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSession(string, string)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. This version of ConnectToSession presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSession(string server, string session)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string session

Specifies a Host Integrator session pool.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid session name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSession(string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. This version of ConnectToSession presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSession(string server, string session, IDictionary modelVariables)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string session

Specifies a Host Integrator session pool.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid session name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSession(string, string, string, string)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. This version of ConnectToSession presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSession(string server, string session, string userid, string password)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string session

Specifies a Host Integrator session pool.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid session name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSession(string, string, string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. This version of ConnectToSession presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSession(string server, string session, string userid, string password, IDictionary modelVariables)
Parameters
Type Name Description
string server

Specifies the name of the Host Integrator server. This value can be a DNS name or an IP address.

string session

Specifies a Host Integrator session pool.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Host Integrator server is not running.
  • Invalid server name or IP address.
  • Invalid session name.
  • Invalid userID or password.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSessionViaDomain(string, string, string)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToSessionViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSessionViaDomain(string directoryServer, string domain, string session)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string session

Specifies a Host Integrator session pool.

Remarks

Reasons for failure include:

  • Unable to locate Host Integrator domain server.
  • Unable to locate AADS server.
  • Invalid session name.
  • Invalid userID or password.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSessionViaDomain(string, string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToSessionViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSessionViaDomain(string directoryServer, string domain, string session, IDictionary modelVariables)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string session

Specifies a Host Integrator session pool.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Unable to locate Host Integrator domain server.
  • Unable to locate AADS server.
  • Invalid session name.
  • Invalid userID or password.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSessionViaDomain(string, string, string, string, string)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToSessionViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSessionViaDomain(string directoryServer, string domain, string session, string userid, string password)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string session

Specifies a Host Integrator session pool.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

Remarks

Reasons for failure include:

  • Unable to locate Host Integrator domain server.
  • Unable to locate AADS server.
  • Invalid session name.
  • Invalid userID or password.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

ConnectToSessionViaDomain(string, string, string, string, string, IDictionary)

Establishes a connection to a Host Integrator server and creates or allocates a host session with the specified session pool. The connection is made using the specified AADS server and Host Integrator domain. This version of ConnectToSessionViaDomain presents a user ID and a password, to establish authorization on the Host Integrator server, and also provides a set of model variables, to set upon connection.

Declaration
public virtual void ConnectToSessionViaDomain(string directoryServer, string domain, string session, string userid, string password, IDictionary modelVariables)
Parameters
Type Name Description
string directoryServer

Specifies a Host Integrator authentication and authorization directory server (AADS).

string domain

Specifies a Host Integrator domain.

string session

Specifies a Host Integrator session pool.

string userid

Specifies a user ID to present to the Host Integrator server.

string password

Specifies a password to present to the Host Integrator server.

IDictionary modelVariables

Specifies model variables to set on connection.

Remarks

Reasons for failure include:

  • Unable to locate Host Integrator domain server.
  • Unable to locate AADS server.
  • Invalid session name.
  • Invalid userID or password.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the client connection attempt fails

HostIntegratorTimeoutException

Thrown if the client connection times out waiting for a response from the VHI server

HostIntegratorServerException

Thrown if the server refuses a client connection attempt

HostIntegratorServerException

Thrown if the requested model or session is not available

HostIntegratorServerException

Thrown if the host connection does not succeed

Disconnect()

Disconnects from a Host Integrator server session.

Declaration
public virtual void Disconnect()
Remarks

Reasons for failure include:

  • No current session.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

EnableTerminalAttributes()

Enables the availability of terminal attributes when retrieving attribute or field data from the Host Integrator server.

Declaration
public virtual void EnableTerminalAttributes()
Remarks

This method applies to subsequent GetAttributes or FetchRecords method calls during the current session. Attributes are only retrieved if they are enabled at run-time with this method call, and also enabled in the model file for the entity or recordset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

EnableTerminalAttributes(bool)

Enables the availability of terminal attributes when retrieving attribute or field data from the Host Integrator server.

Declaration
public virtual void EnableTerminalAttributes(bool enable)
Parameters
Type Name Description
bool enable

Specifies whether terminal attributes are enabled.

Remarks

This method applies to subsequent GetAttributes or FetchRecords method calls during the current session. Attributes are only retrieved if they are enabled at run-time with this method call, and also enabled in the model file for the entity or recordset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

ExecuteSQLStatement(string)

Executes an SQL statement on a table defined in the model.

Declaration
public virtual DataSet ExecuteSQLStatement(string sqlStatement)
Parameters
Type Name Description
string sqlStatement

Specifies the SQL statement to execute.

Returns
Type Description
DataSet

This method returns a DataSet containing the results of the query. If no data are returned, this method returns an empty DataSet.

Remarks

Executes an SQL statement on a table defined in the model.

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if the SQL statement cannot be resolved

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

ExecuteSQLStatement(string, int)

Executes an SQL statement on a table defined in the model.

Declaration
public virtual DataSet ExecuteSQLStatement(string sqlStatement, int maxRows)
Parameters
Type Name Description
string sqlStatement

Specifies the SQL statement to execute.

int maxRows

Specifies the maximum number of rows to return. A value of zero will return all rows.

Returns
Type Description
DataSet

This method returns a DataSet containing the results of the query. If no data are returned, this method returns an empty DataSet.

Remarks

Executes an SQL statement on a table defined in the model.

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if the SQL statement cannot be resolved

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

FetchRecords()

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords()
Returns
Type Description
DataSet

This method returns a DataSet containing the requested records.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

FetchRecords(IList)

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords(IList fieldNames)
Parameters
Type Name Description
IList fieldNames

Specifies field names to fetch from the recordset.

Returns
Type Description
DataSet

This method returns a DataSet containing the requested records. If no fields match the fieldNames provided, an empty DataSet is returned.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorModelDefException

Thrown if a reference is made to nonexistent fields

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

FetchRecords(IList, string)

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords(IList fieldNames, string filterExpression)
Parameters
Type Name Description
IList fieldNames

Specifies field names to fetch from the recordset.

string filterExpression

Specifies an expression that qualifies the records to fetch. See the Remarks section for details.

Returns
Type Description
DataSet

This method returns a DataSet containing the requested records. If no fields match the fieldNames provided, or if the filterExpression eliminates all records, an empty DataSet is returned.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

FetchRecords(int)

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords(int maxRows)
Parameters
Type Name Description
int maxRows

Specifies the maximum number of rows of data to be returned. If maxRows is set to 0, no limit is imposed on the number of rows returned.

Returns
Type Description
DataSet

This method returns a DataSet containing the requested records.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

FetchRecords(int, IList)

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords(int maxRows, IList fieldNames)
Parameters
Type Name Description
int maxRows

Specifies the maximum number of rows of data to be returned. If maxRows is set to 0, no limit is imposed on the number of rows returned.

IList fieldNames

Specifies field names to fetch from the recordset.

Returns
Type Description
DataSet

This method returns a DataSet containing the requested records. If no fields match the fieldNames provided, an empty DataSet is returned.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

FetchRecords(int, IList, string)

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords(int maxRows, IList fieldNames, string filterExpression)
Parameters
Type Name Description
int maxRows

Specifies the maximum number of rows of data to be returned. If maxRows is set to 0, no limit is imposed on the number of rows returned.

IList fieldNames

Specifies field names to fetch from the recordset.

string filterExpression

Specifies an expression that qualifies the records to fetch. See the Remarks section for details.

Returns
Type Description
DataSet

This method returns a DataSet containing the requested records. If no fields match the fieldNames provided, or if the filterExpression eliminates all records, an empty DataSet is returned.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

FetchRecords(int, string)

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords(int maxRows, string filterExpression)
Parameters
Type Name Description
int maxRows

Specifies the maximum number of rows of data to be returned. If maxRows is set to 0, no limit is imposed on the number of rows returned.

string filterExpression

Specifies an expression that qualifies the records to fetch. See the Remarks section for details.

Returns
Type Description
DataSet

This method returns a DataSet containing the requested records. If the filterExpression eliminates all records, an empty DataSet is returned.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

FetchRecords(string)

Fetches data from the Host Integrator server for the current recordset of the current entity.

Declaration
public virtual DataSet FetchRecords(string filterExpression)
Parameters
Type Name Description
string filterExpression

Specifies an expression that qualifies the records to fetch. See the Remarks section for details.

Returns
Type Description
DataSet

This method returns a DataSet containing the requested records. If the filterExpression eliminates all records, an empty DataSet is returned.

Remarks

The set of records returned begins with the first record following the current record. If the current record is before the first record in the recordset, searching starts with the first record. After a FetchRecords, the current record is the last record included in the returned set of records.

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

GetAttributeAtCursor()

Gets the name of the attribute at the current cursor position.

Declaration
public virtual string GetAttributeAtCursor()
Returns
Type Description
string

This method returns the attribute name, or an empty string if the cursor is not currently within one of the defined entity attributes.

Remarks

Gets the name of the attribute at the current cursor position.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetAttributeLocations()

Gets locations for attributes of the current entity.

Declaration
public virtual IList GetAttributeLocations()
Returns
Type Description
IList

This version of the GetAttributeLocations method (without parameters) returns a list of ElementLocation objects, for each attribute for the current entity.

Remarks

Gets locations for attributes of the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetAttributeLocations(IList)

Gets locations for attributes of the current entity.

Declaration
public virtual IList GetAttributeLocations(IList attributeNames)
Parameters
Type Name Description
IList attributeNames

Specifies attribute names.

Returns
Type Description
IList

This version of the GetAttributeLocations method returns a list of ElementLocation objects, for each attribute in the list of attribute names.

Remarks

Gets locations for attributes of the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetAttributeMetaData(string, string)

Gets metadata for the specified attribute and entity in the Host Integrator model.

Declaration
public virtual AttributeMetaData GetAttributeMetaData(string entityName, string attributeName)
Parameters
Type Name Description
string entityName

Specifies an entity in the Host Integrator model.

string attributeName

Specifies an attribute in the specified entity.

Returns
Type Description
AttributeMetaData

This method returns metadata about the specified attribute.

Remarks

Gets metadata for the specified attribute and entity in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity or attribute

GetAttributes()

Gets all attributes for the current entity that are not write-only.

Declaration
public virtual DataSet GetAttributes()
Returns
Type Description
DataSet

This version of the GetAttributes method (without parameters) returns all attributes of the current entity.

Remarks

Gets attributes for the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetAttributes(IList)

Gets attributes for the current entity.

Declaration
public virtual DataSet GetAttributes(IList attributeNames)
Parameters
Type Name Description
IList attributeNames

Specifies attributes to get from the entity. If attributeNames is null, getAttributes will return all attributes of the entity that are not write-only.

Returns
Type Description
DataSet

This version of the GetAttributes method (without parameters) returns all attributes of the current entity.

Remarks

Gets attributes for the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetColumnMetaData(string, string)

Gets metadata for a table column in the Host Integrator model.

Declaration
public virtual ColumnMetaData GetColumnMetaData(string tableName, string columnName)
Parameters
Type Name Description
string tableName

Specifies a table in the current host integrator model.

string columnName

Specifies a column in the specified table.

Returns
Type Description
ColumnMetaData

This method returns column metadata.

Remarks

Gets metadata for a table column in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent table or column

GetCurrentEntity()

Gets the name of the current entity in the Host Integrator model.

Declaration
public virtual string GetCurrentEntity()
Returns
Type Description
string

This method returns the name of the current entity in the Host Integrator model.

Remarks

Gets the name of the current entity in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetCurrentRecord()

Get the current record

Declaration
public virtual DataSet GetCurrentRecord()
Returns
Type Description
DataSet

the current record. If there is no current record, the method returns an empty Dataset.

GetCurrentRecordIndex()

Gets the index number of the current record in the current recordset.

Declaration
public virtual int GetCurrentRecordIndex()
Returns
Type Description
int

This method returns the index of the current record in the current recordset.

Remarks

Gets the index number of the current record in the current recordset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

GetCurrentRecordSetName()

Gets the name of the current recordset.

Declaration
public virtual string GetCurrentRecordSetName()
Returns
Type Description
string

This method returns the name of the current recordset in the Host Integrator model.

Remarks

Gets the name of the current recordset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

GetEntityAttributes(string)

Gets the names of the attributes for the specified entity in the Host Integrator model.

Declaration
public virtual IList GetEntityAttributes(string entityName)
Parameters
Type Name Description
string entityName

Specifies an entity in the Host Integrator model.

Returns
Type Description
IList

This method returns the names of the attributes for the specified entity in the Host Integrator model.

Remarks

Reasons for failure include:

  • Server session not established.
  • Invalid entity name.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity

GetEntityDescription(string)

Gets the description for the specified entity in the Host Integrator model.

Declaration
public virtual string GetEntityDescription(string entityName)
Parameters
Type Name Description
string entityName

Specifies an entity in the current Host Integrator model.

Returns
Type Description
string

This method returns the description for the specified entity.

Remarks

Gets the description for the specified entity in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity

GetEntityOperations(string)

Gets the names of the operations in the specified entity.

Declaration
public virtual IList GetEntityOperations(string entityName)
Parameters
Type Name Description
string entityName

Specifies an entity in the current Host Integrator model.

Returns
Type Description
IList

This method returns the names of the operations in the specified entity.

Remarks

Reasons for failure include:

  • Server session not established.
  • Invalid entity name.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity

GetEntityRecordSets(string)

Gets the names of the recordsets in the specified entity.

Declaration
public virtual IList GetEntityRecordSets(string entityName)
Parameters
Type Name Description
string entityName

Specifies an entity in the current Host Integrator model.

Returns
Type Description
IList

This method returns the names of the recordsets in the specified entity.

Remarks

Reasons for failure include:

  • Server session not established.
  • Invalid entity name.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity

GetFieldLocations()

Gets field locations for the current record in the current recordset in the current entity.

Declaration
public virtual IList GetFieldLocations()
Returns
Type Description
IList

This version of the GetFieldLocations method returns all field locations in the current record.

Remarks

Gets field locations for the current record in the current recordset in the current entity.

Recordset fields are always linear regions.

This method is guaranteed to work correctly only when a record in the recordset is selected. If no record is selected:

  • For recordsets containing fixed records, the field locations returned are those for the first record in the recordset, based upon the information stored in the model.
  • For recordsets containing variable-length records, the information returned is not meaningful.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

GetFieldLocations(IList)

Gets field locations for the current record in the current recordset in the current entity.

Declaration
public virtual IList GetFieldLocations(IList fieldNames)
Parameters
Type Name Description
IList fieldNames

Specifies fields for which locations are to be returned.

Returns
Type Description
IList

This version of the GetFieldLocations method returns all field locations in the current record.

Remarks

Gets field locations for the current record in the current recordset in the current entity.

Recordset fields are always linear regions.

This method is guaranteed to work correctly only when a record in the recordset is selected. If no record is selected:

  • For recordsets containing fixed records, the field locations returned are those for the first record in the recordset, based upon the information stored in the model.
  • For recordsets containing variable-length records, the information returned is not meaningful.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

GetFieldMetaData(string, string, string)

Gets metadata for the specified field in the specified recordset and entity in the Host Integrator model.

Declaration
public virtual FieldMetaData GetFieldMetaData(string entityName, string recordSetName, string fieldName)
Parameters
Type Name Description
string entityName

Specifies an entity in the Host Integrator model.

string recordSetName

Specifies a recordset in the specified entity.

string fieldName

Specifies a field in the specified recordset.

Returns
Type Description
FieldMetaData

This method returns metadata for the specified field.

Remarks

Gets metadata for the specified field in the specified recordset and entity in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity, recordset, or field

HostIntegratorModelDefException

Thrown if there is no current recordset

GetHomeEntityName()

Gets the name of the home entity for the current Host Integrator model.

Declaration
public virtual string GetHomeEntityName()
Returns
Type Description
string

This method returns the name of the home entity. If there is no home entity (for example, because the model contains only connection information), this method returns a null.

Remarks

Gets the name of the home entity for the current Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

GetLastRequestID()

Gets an identifier for the most recent request performed against the current Host Integrator server session.

Declaration
public virtual int GetLastRequestID()
Returns
Type Description
int

This method returns an integer identifying the most recent request performed against the current Host Integrator server session.

Remarks

If a server request has not yet been performed in the current session, GetLastRequestID returns 0.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetLocale()

Gets the locale for the current session.

Declaration
public virtual string GetLocale()
Returns
Type Description
string

This method returns the locale for the current session.

Remarks

Gets the locale for the current session.

GetLoggingLevel()

Gets the logging level for the current Host Integrator session.

Declaration
public virtual LoggingLevel GetLoggingLevel()
Returns
Type Description
LoggingLevel

The value returned is a member of the LoggingLevel enumeration.

Remarks

Gets the logging level for the current Host Integrator session.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetMajorVersion()

Gets the major version number for the locally installed Verastream software.

Declaration
public virtual int GetMajorVersion()
Returns
Type Description
int

This method returns the major version number for Verastream.

Remarks

The major version is the part of the complete version number that precedes the first period. So, for example, if the complete version number is "5.6", the major version portion is "5".

GetMinorVersion()

Gets the minor version number for the locally installed Verastream software.

Declaration
public virtual int GetMinorVersion()
Returns
Type Description
int

This method returns the minor version number for Verastream.

Remarks

The minor version is the part of the complete version number that follows the first period. So, for example, if the complete version number is "5.6", the minor version portion is "6".

GetModelEntities()

Gets the names of the entities in the current Host Integrator model.

Declaration
public virtual IList GetModelEntities()
Returns
Type Description
IList

This method returns the names of the entities in the current Host Integrator model.

Remarks

Reasons for failure include:

  • Server session not established.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

GetModelVariableNames()

Gets the names of all non-hidden model variables in the Host Integrator model.

Declaration
public virtual IList GetModelVariableNames()
Returns
Type Description
IList

This method returns the names of all non-hidden model variables in the Host Integrator model.

Remarks

Reasons for failure include:

  • Server session not established.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

GetModelVariables()

Gets the values of all non-hidden model variables in the current Host Integrator model.

Declaration
public virtual IDictionary GetModelVariables()
Returns
Type Description
IDictionary

This method returns the values of all non-hidden model variables in the Host Integrator model.

Remarks

Reasons for failure include:

  • Server session not established.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetOperationMetaData(string, string)

Gets metadata for an operation in the current Host Integrator model.

Declaration
public virtual OperationMetaData GetOperationMetaData(string entityName, string operationName)
Parameters
Type Name Description
string entityName

Specifies the name of an entity in the Host Integrator model.

string operationName

Specifies the name of an operation associated with the specified entity.

Returns
Type Description
OperationMetaData

This method returns metadata for an operation in the current Host Integrator model.

Remarks

Gets metadata for an operation in the current Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity or operation

GetPatternLocations()

Gets the locations for all patterns for the current entity.

Declaration
public virtual IList GetPatternLocations()
Returns
Type Description
IList

This version of the GetPatternLocations method (without parameters) returns a list of ElementLocation lobject for all patterns defined for the current entity.

Remarks

Gets the locations for all patterns for the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetPatternLocations(IList)

Gets the locations for the specified patterns for the current entity.

Declaration
public virtual IList GetPatternLocations(IList patternNames)
Parameters
Type Name Description
IList patternNames

Specifies the names of the patterns for which locations are to be returned.

Returns
Type Description
IList

This version of the GetPatternLocations method (with a patternName parameter) returns locations for the specified patterns for the current entity.

Remarks

Gets the locations for the specified patterns for the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent pattern

GetProcedureMetaData(string, string)

Gets metadata for a table procedure in the Host Integrator model.

Declaration
public virtual ProcedureMetaData GetProcedureMetaData(string tableName, string procedureName)
Parameters
Type Name Description
string tableName

Specifies a table in the current Host Integrator model.

string procedureName

Specifies a procedure in the specified table.

Returns
Type Description
ProcedureMetaData

This method returns metadata for the specified table procedure.

Remarks

Gets metadata for a table procedure in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent table or procedure

GetRecordSetLocations()

Gets the locations for all recordsets in the current entity.

Declaration
public virtual IList GetRecordSetLocations()
Returns
Type Description
IList

This version of the GetRecordSetLocations method (without parameters) returns locations for all recordsets in the current entity.

Remarks

Gets the locations for all recordsets in the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetRecordSetLocations(IList)

Gets the locations for the specified recordsets in the current entity.

Declaration
public virtual IList GetRecordSetLocations(IList recordSetNames)
Parameters
Type Name Description
IList recordSetNames

Specifies the names of the recordsets for which locations are to be returned.

Returns
Type Description
IList

This version of the GetRecordSetLocations method (with a recordSetNames parameter) returns locations for the specified recordsets in the current entity.

Remarks

Gets the locations for the specified recordsets in the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent recordset

GetRecordSetMetaData(string, string)

Gets metadata for a recordset in the specified entity.

Declaration
public virtual RecordSetMetaData GetRecordSetMetaData(string entityName, string recordSetName)
Parameters
Type Name Description
string entityName

Specifies an entity in the Host Integrator model.

string recordSetName

Specifies a recordset in the specified entity.

Returns
Type Description
RecordSetMetaData

This method returns metadata for the specified recordset.

Remarks

Gets metadata for a recordset in the specified entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent entity or recordset

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent recordset

GetSessionID()

Gets an identifier for the current Host Integrator session.

Declaration
public virtual int GetSessionID()
Returns
Type Description
int

This method returns an integer identifying the current Host Integrator session.

Remarks

Gets an identifier for the current Host Integrator session.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetStringAtOffset(int, int)

Gets a string of the specified length, starting at the specified offset, from the current entity.

Declaration
public virtual string GetStringAtOffset(int offset, int length)
Parameters
Type Name Description
int offset

Specifies an offset from the start of the screen buffer.

int length

Specifies the length of the string to be returned.

Returns
Type Description
string

This method returns a string of the specified length, starting at the specified offset, from the current entity.

Remarks

Reasons for failure include:

  • Server session not established.
  • Invalid offset.
  • Invalid length.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if the offset or length values are out of range

GetStringAtRowColumn(int, int, int, int)

Gets a string from a rectangular region of the current entity.

Declaration
public virtual string GetStringAtRowColumn(int topRow, int leftColumn, int numRows, int numColumns)
Parameters
Type Name Description
int topRow

Specifies the starting row for the selection.

int leftColumn

Specifies the starting column for the selection.

int numRows

Specifies the number of rows in the selection.

int numColumns

Specifies the number of columns in the selection.

Returns
Type Description
string

This method returns a string containing the contents of a rectangular region of the current entity.

Remarks

Gets a string from a rectangular region of the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown a value is out of range

GetTableColumns(string)

Gets the column names for a table in the Host Integrator model.

Declaration
public virtual IList GetTableColumns(string tableName)
Parameters
Type Name Description
string tableName

Specifies the name of a table in the Host Integrator model.

Returns
Type Description
IList

This method returns the column names for the specified table.

Remarks

Gets the column names for a table in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent table

GetTableDescription(string)

Gets the description for a table in the Host Integrator model.

Declaration
public virtual string GetTableDescription(string tableName)
Parameters
Type Name Description
string tableName

Specifies the name of a table in the Host Integrator model.

Returns
Type Description
string

This method returns the name of a table in the Host Integrator model.

Remarks

Gets the description for a table in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent table

GetTableNames()

Gets the names of all tables in the Host Integrator model.

Declaration
public virtual IList GetTableNames()
Returns
Type Description
IList

This method returns the names of all tables in the Host Integrator model.

Remarks

Gets the names of all tables in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

GetTableProcedures(string)

Gets the procedure names for a table in the Host Integrator model.

Declaration
public virtual IList GetTableProcedures(string tableName)
Parameters
Type Name Description
string tableName

Specifies the name of a table in the Host Integrator model.

Returns
Type Description
IList

This method returns the procedure names for a table in the Host Integrator model.

Remarks

Gets the procedure names for a table in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent table

GetTerminalFieldAtCursor()

Gets a TerminalField object that contains information about the terminal field at the current cursor position on the Host Integrator screen.

Declaration
public virtual TerminalField GetTerminalFieldAtCursor()
Returns
Type Description
TerminalField

This method returns a TerminalField object that contains information about the terminal field at the current cursor position.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

GetVMRFilePrefix()

Gets the VMR file prefix.

Declaration
public virtual string GetVMRFilePrefix()
Returns
Type Description
string

The VMR file prefix.

GetVariableMetaData(string)

Gets metadata for a model variable in the Host Integrator model.

Declaration
public virtual VariableMetaData GetVariableMetaData(string variableName)
Parameters
Type Name Description
string variableName

Specifies the name of a variable in the Host Integrator model.

Returns
Type Description
VariableMetaData

This method returns metadata for the specified variable.

Remarks

Gets metadata for a model variable in the Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent variable

GetVersionString()

Gets the version string for the Verastream .NET connector. This string is of the form majorVersion.minorVersion.

Declaration
public virtual string GetVersionString()
Returns
Type Description
string

This method returns the version string for the Verastream .NET connector.

Remarks

Gets the version string for the Verastream .NET connector. This string is of the form majorVersion.minorVersion.

InsertRecord(IDictionary)

Performs an insert operation for the current recordset.

Declaration
public virtual void InsertRecord(IDictionary record)
Parameters
Type Name Description
IDictionary record

Specifies a set of name-value pairs (each representing a record field) to insert into the entity recordset.

Remarks

Performs an insert operation for the current recordset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if the insert operation fails.

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

InsertRecords(DataSet)

Performs the insert operation for the current recordset multiple times.

Declaration
public virtual void InsertRecords(DataSet records)
Parameters
Type Name Description
DataSet records

Specifies a set of name-value pairs (each representing a record field) to insert into the recordset.

Remarks

This method sends the complete list of records to insert to the server at one time, making insertion of multiple records more efficient than with the InsertRecord(IDictionary) method.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if the insert operation fails.

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

InsertStringAtCursor(string)

Inserts the specified string into the current entity on the Host Integrator server starting at the current cursor position.

Declaration
public virtual void InsertStringAtCursor(string str)
Parameters
Type Name Description
string str

Specifies the string to insert.

Remarks

Reasons for failure include:

  • Server session not established.
  • Invalid string.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorTerminalException

Thrown if the insert fails

InsertStringAtOffset(string, int)

Inserts a string into the current entity on the Host Integrator server starting at an offset.

Declaration
public virtual void InsertStringAtOffset(string str, int offset)
Parameters
Type Name Description
string str

Specifies the string to insert.

int offset

Specifies the offset from the start of the screen buffer.

Remarks

Inserts a string into the current entity on the Host Integrator server starting at an offset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorTerminalException

Thrown if the insert fails

HostIntegratorServerException

Thrown if a row or column value is out of range

HostIntegratorConnectorException

Thrown if an argument is invalid

InsertStringAtRowColumn(string, int, int)

Inserts a string into the current entity on the Host Integrator server starting at the given row and column location.

Declaration
public virtual void InsertStringAtRowColumn(string str, int rowNum, int columnNum)
Parameters
Type Name Description
string str

Specifies the string to insert.

int rowNum

Specifies the row number of the starting location for insertion on the entity.

int columnNum

Specifies the column number of the starting location for insertion on the entity.

Remarks

Inserts a string into the current entity on the Host Integrator server starting at the given row and column location.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorTerminalException

Thrown if the insert fails

HostIntegratorServerException

Thrown if a row or column value is out of range

HostIntegratorConnectorException

Thrown if an argument is invalid

MoveCurrentRecordIndex(ScrollMovement)

Moves the current record index to a new position in the current recordset.

Declaration
public virtual void MoveCurrentRecordIndex(ScrollMovement movement)
Parameters
Type Name Description
ScrollMovement movement

The value must be a member of the ScrollMovement enumeration.

Remarks

Moves the current record index to a new position in the current recordset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

HostIntegratorModelDefException

Thrown if the requested scroll operation is not defined on the current recordset

HostIntegratorTerminalException

Thrown if the operation fails or is not permitted

NextRecord()

Returns the next record in the current recordset.

Declaration
public virtual DataSet NextRecord()
Returns
Type Description
DataSet

This method returns the next record in the current recordset.

Remarks

If there are no more records in the recordset, this method throws an exception: "Caught VHI Exception in GetItem(); ElementDoesNotExist". (This does not happen in Java.)

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if there is no current recordset

HostIntegratorConnectorException

Thrown if there are no more records

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

NextRecord(string)

Finds and returns a record in the current recordset using a filter expression.

Declaration
public virtual DataSet NextRecord(string filterExpression)
Parameters
Type Name Description
string filterExpression

Specifies an expression that qualifies the records to fetch. See the Remarks section for details.

Returns
Type Description
DataSet

This method returns the next record in the current recordset matching the filter. Searching starts with the record following the current record. If the current record is before the first record in the recordset, searching starts with the first record.

Remarks

If there are no more records in the recordset, or no records that match the filter expression, this method throws an exception: "Caught VHI Exception in GetItem(); ElementDoesNotExist". (This does not happen in Java.)

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorModelDefException

Thrown if there is no current recordset

HostIntegratorConnectorException

Thrown if there are no more records

HostIntegratorConnectorException

Thrown if there are no records matching the filter expression

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

PerformAidKey(AidKey)

Enters an aid key (for example, a Program Function key) into the current Host Integrator server session.

Declaration
public virtual void PerformAidKey(AidKey key)
Parameters
Type Name Description
AidKey key

Specifies any of the terminal key constants defined in the AidKey enumeration.

Remarks

Enters an aid key (for example, a Program Function key) into the current Host Integrator server session.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

PerformEntityOperation(string)

Performs an operation on the current entity.

Declaration
public virtual void PerformEntityOperation(string operationName)
Parameters
Type Name Description
string operationName

Specifies the name of the operation to perform.

Remarks

Reasons for failure include:

  • Server session not established.
  • Invalid operation.
  • Session is already connected to a Host Integrator server.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent operation

HostIntegratorTerminalException

Thrown if the operation fails

PerformTableProcedure(string, string, IDictionary)

Performs a procedure on a table defined in the model.

Declaration
public void PerformTableProcedure(string tableName, string procedureName, IDictionary inputValues)
Parameters
Type Name Description
string tableName

Specifies the name of the table on which to perform the procedure.

string procedureName

Specifies the name of the table procedure to perform.

IDictionary inputValues

Specifies a set of column name-value pairs to input.

Remarks

Performs an INSERT procedure on a table defined in the model.

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if a reference is made to a non-existent table, procedure, or table column

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if an error occurs while performing the procedure

PerformTableProcedure(string, string, IDictionary, bool)

Performs a SELECT or a DELETE procedure on a table defined in the model.

Declaration
public DataSet PerformTableProcedure(string tableName, string procedureName, IDictionary filterValues, bool filterIsCaseSensitive)
Parameters
Type Name Description
string tableName

Specifies the name of the table on which to perform the procedure.

string procedureName

Specifies the name of the table procedure to perform.

IDictionary filterValues

Specifies a set of filter column name-value pairs to use.

bool filterIsCaseSensitive

Specifies whether the filter comparison should be case sensitive.

Returns
Type Description
DataSet

This method returns the result of a SELECT procedure. If no data match the specified conditions, this method returns an empty DataSet.

Remarks

Performs a SELECT procedure on a table defined in the model.

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if a reference is made to a non-existent table, procedure, or table column

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if an error occurs while performing the procedure

PerformTableProcedure(string, string, IDictionary, bool, IList, int)

Performs a SELECT procedure on a table defined in the model.

Declaration
public DataSet PerformTableProcedure(string tableName, string procedureName, IDictionary filterValues, bool filterIsCaseSensitive, IList outputColumnNames, int maxRows)
Parameters
Type Name Description
string tableName

Specifies the name of the table on which to perform the procedure.

string procedureName

Specifies the name of the table procedure to perform.

IDictionary filterValues

Specifies a set of filter column name-value pairs to use.

bool filterIsCaseSensitive

Specifies whether the filter comparison should be case sensitive.

IList outputColumnNames

Specifies the names of the columns to return.

int maxRows

Specifies the maximum number of rows to return. If maxRows is set to 0, no limit is imposed on the number of rows returned.

Returns
Type Description
DataSet

This method returns the result of a SELECT procedure. If no data match the specified conditions, this method returns an empty DataSet.

Remarks

Performs a SELECT procedure on a table defined in the model.

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if a reference is made to a non-existent table, procedure, or table column

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if an error occurs while performing the procedure

PerformTableProcedure(string, string, IDictionary, IDictionary, bool)

Performs an UPDATE procedure on a table defined in the model.

Declaration
public void PerformTableProcedure(string tableName, string procedureName, IDictionary inputValues, IDictionary filterValues, bool filterIsCaseSensitive)
Parameters
Type Name Description
string tableName

Specifies the name of the table on which to perform the procedure.

string procedureName

Specifies the name of the table procedure to perform.

IDictionary inputValues

Specifies a set of column name-value pairs to input.

IDictionary filterValues

Specifies a set of filter column name-value pairs to use.

bool filterIsCaseSensitive

Specifies whether the filter comparison should be case sensitive.

Remarks

Performs an UPDATE procedure on a table defined in the model.

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if a reference is made to a non-existent table, procedure, or table column

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if an error occurs while performing the procedure

PerformTableProcedure(string, string, IDictionary, IDictionary, bool, IList, int)

Performs a procedure on a table defined in the model.

Declaration
public DataSet PerformTableProcedure(string tableName, string procedureName, IDictionary inputValues, IDictionary filterValues, bool filterIsCaseSensitive, IList outputColumnNames, int maxRows)
Parameters
Type Name Description
string tableName

Specifies the name of the table on which to perform the procedure.

string procedureName

Specifies the name of the table procedure to perform.

IDictionary inputValues

Specifies a set of column name-value pairs to input.

IDictionary filterValues

Specifies a set of filter column name-value pairs to use.

bool filterIsCaseSensitive

Specifies whether the filter comparison should be case sensitive.

IList outputColumnNames

Specifies the names of the columns to return.

int maxRows

Specifies the maximum number of rows to return. If maxRows is set to 0, no limit is imposed on the number of rows returned.

Returns
Type Description
DataSet

This method returns the result of the table procedure, if applicable. If no data match the specified conditions, this method returns an empty DataSet.

Remarks

Performs a table procedure on a table defined in the model.

Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if a reference is made to a non-existent table, procedure, or table column

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if an error occurs while performing the procedure

ProcessString(string)

Calls the ProcessString event handler on the server.

Declaration
public virtual string ProcessString(string inStr)
Parameters
Type Name Description
string inStr

Specifies the input string to be processed.

Returns
Type Description
string

This method returns a string containing the results returned by the ProcessString event handler.

Remarks

Returns a string containing the results returned by the ProcessString event handler.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorServerException

Thrown if the ProcessString method is not supported for the current model, or an execution error occurs

RequireSecureConnection(bool)

This method is kept for backwards compatibility. Connections to a Host Integrator Server are always encrypted.

Declaration
public virtual void RequireSecureConnection(bool require)
Parameters
Type Name Description
bool require

Ignored.

Remarks

This method is kept for backwards compatibility. Connections to a Host Integrator Server are always encrypted.

ResumeConnection(string)

Resumes the execution of a currently suspended Host Integrator server session.

Declaration
public virtual void ResumeConnection(string connectionToken)
Parameters
Type Name Description
string connectionToken

Specifies the token received from the SuspendConnection(int) method.

Remarks

If the requested session is already running, this method does nothing.

Reasons for failure include:
  • Server session not established.
  • Server session no longer present.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if already connected

HostIntegratorChannelException

Thrown if the attempt to resume the connection fails

SelectCurrentRecord()

Selects the current record in the current recordset.

Declaration
public virtual void SelectCurrentRecord()
Remarks

Selects the current record in the current recordset, by performing the user-defined selection operation.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

SelectRecordByFilter(string)

Finds a record in the current recordset using a filter expression, and perform a selection operation.

Declaration
public virtual bool SelectRecordByFilter(string filterExpression)
Parameters
Type Name Description
string filterExpression

Specifies an expression that qualifies the record to find. See the Remarks section for details.

Returns
Type Description
bool

This method returns True if the selection succeeds, or False if the method fails to find a record to select.

Remarks

Searching starts with the record following the current record. If the current record is before the first record in the recordset, searching starts with the first record.

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorModelDefException

Thrown if there is no current recordset

HostIntegratorTerminalException

Thrown if there is an execution error

SelectRecordByIndex(int)

Performs its selection operation on a record in the current recordset. The record to select is determined by the specified index number.

Declaration
public virtual bool SelectRecordByIndex(int index)
Parameters
Type Name Description
int index

Specifies the index of the record to select.

Returns
Type Description
bool

This method returns True if the selection succeeds, or False if no record can be selected.

Remarks

Performs its selection operation on a record in the current recordset. The record to select is determined by the specified index number.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if there is no current recordset

HostIntegratorTerminalException

Thrown if there is an execution error

SetAttributes(IDictionary)

Sets the attributes for the current entity.

Declaration
public virtual void SetAttributes(IDictionary attributes)
Parameters
Type Name Description
IDictionary attributes

Specifies attributes for the current entity, using name-value pairs.

Remarks

SetAttributes does not need to specify all attributes for the entity, but it should specify all required attributes.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent attribute

HostIntegratorTerminalException

Thrown if there is an execution error

SetAttributes(DataSet)

Sets the attributes for the current entity.

Declaration
public virtual void SetAttributes(DataSet attributes)
Parameters
Type Name Description
DataSet attributes

Specifies attributes for the current entity, using name-value pairs.

Remarks

SetAttributes does not need to specify all attributes for the entity, but it should specify all required attributes.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent attribute

HostIntegratorTerminalException

Thrown if there is an execution error

SetAttributesDelayed(IDictionary, string)

Sets the attributes for the specified entity. Attributes are not actually set until the entity is reached.

Declaration
public virtual void SetAttributesDelayed(IDictionary attributes, string entityName)
Parameters
Type Name Description
IDictionary attributes

Specifies attributes for the current entity, using name-value pairs.

string entityName

Specifies the name of an entity in the current Host Integrator model.

Remarks

SetAttributesDelayed does not need to specify all attributes for the specified entity, but it should specify all required attributes.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent attribute

HostIntegratorTerminalException

Thrown if there is an execution error

SetAttributesDelayed(DataSet, string)

Sets the attributes for the specified entity. Attributes are not actually set until the entity is reached.

Declaration
public virtual void SetAttributesDelayed(DataSet attributes, string entityName)
Parameters
Type Name Description
DataSet attributes

Specifies attributes for the current entity, using name-value pairs.

string entityName

Specifies the name of an entity in the current Host Integrator model.

Remarks

SetAttributesDelayed does not need to specify all attributes for the specified entity, but it should specify all required attributes.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown when client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent attribute

HostIntegratorTerminalException

Thrown if there is an execution error

SetCurrentEntity(string)

Sets the current entity.

Declaration
public virtual void SetCurrentEntity(string entityName)
Parameters
Type Name Description
string entityName

Specifies the name of an entity in the current Host Integrator model.

Remarks

This method will traverse to a particular screen in the host application.

Reasons for failure include:

  • Server session not established.
  • Invalid entity name.
  • No traversal path to entity.
Exceptions
Type Condition
HostIntegratorModelDefException

Thrown if the entity name is not found in the model

HostIntegratorTerminalException

Thrown if the navigation fails

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

SetCurrentRecordIndex(int)

Sets the current record in the current recordset, using the record's index number.

Declaration
public virtual void SetCurrentRecordIndex(int index)
Parameters
Type Name Description
int index

Specifies the index of the record to make current.

Remarks

Use -1 as the index to force the host's current record to match Verastream's current record. This is only appropriate if you intend to bypass the model to interact directly with the host (for example, by sending a terminal key).

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorTerminalException

Thrown if the index value is out of range

HostIntegratorModelDefException

Thrown if the action fails because of an undefined scroll operation

SetCurrentRecordSetByName(string)

Sets the current recordset, by name.

Declaration
public virtual void SetCurrentRecordSetByName(string name)
Parameters
Type Name Description
string name

Specifies the name of a recordset in the current entity.

Remarks

This method is only relevant if there is more than one recordset in the current entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent recordset

SetLocale(string)

Sets the locale for the current session.

Declaration
public virtual void SetLocale(string locale)
Parameters
Type Name Description
string locale

Specifies a valid locale.

Remarks

Sets the locale for the current session.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if locale is null

SetLoggingLevel(LoggingLevel)

Sets the logging level for the current Host Integrator session.

Declaration
public virtual void SetLoggingLevel(LoggingLevel loggingLevel)
Parameters
Type Name Description
LoggingLevel loggingLevel

Specifies a logging level. The specified value must be a member of the LoggingLevel enumeration.

Remarks

The logging level you set with SetLoggingLevel overrides the global logging level for the server and lasts until you change it again or until disconnection. This is intended primarily for debugging, allowing you to log a larger class of messages for a single session without raising the global logging level for the Host Integrator server. You cannot use SetLoggingLevel to set the logging level lower than the server's logging level configuration.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

SetModelVariables(IDictionary)

Sets the values of variables in the current Host Integrator model.

Declaration
public virtual void SetModelVariables(IDictionary variables)
Parameters
Type Name Description
IDictionary variables

Specifies a set of name-value pairs.

Remarks

Reasons for failure include:

  • Server session not established.
  • Invalid variable name.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent variable

HostIntegratorModelDefException

Thrown if an attempt is made to change the value of a variable that is not writeable

SetVMRFilePrefix(string)

Sets the VMR file prefix.

Declaration
public virtual void SetVMRFilePrefix(string prefix)
Parameters
Type Name Description
string prefix

the VMR file prefix.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

SuspendConnection(int)

Suspends the execution of a currently running Host Integrator server session.

Declaration
public virtual string SuspendConnection(int timeout)
Parameters
Type Name Description
int timeout

Specifies how many minutes can elapse before the suspended session is automatically terminated.

Returns
Type Description
string

This method returns the connection token for this session, which can then be used with the ResumeConnection(string) method to re-establish the connection.

Remarks

On successful suspension, SuspendConnection returns a token to be used when resuming the session. If the current session is already suspended, this method does nothing.

Reasons for failure include:

  • Server session not established.
  • Current server session cannot be suspended.
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if not connected

HostIntegratorException

Thrown if the connection is for metadata only

UpdateCurrentRecord(IDictionary)

Sets the values for the current record in the current recordset.

Declaration
public virtual void UpdateCurrentRecord(IDictionary record)
Parameters
Type Name Description
IDictionary record

Specifies one or more name-value pairs to be updated.

Remarks

Sets the values for the current record in the current recordset.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorTerminalException

Thrown if there is an execution error

UpdateCurrentRecord(DataSet)

Sets the values for the current record in the current recordset.

Declaration
public virtual void UpdateCurrentRecord(DataSet record)
Parameters
Type Name Description
DataSet record

Specifies one or more name-value pairs to be updated.

Remarks

Sets the values for the current record in the current recordset.

UpdateRecordByFilter(IDictionary, string)

Changes the values of a record in the current recordset. The record that gets changed is the first one after the current record that satisfies the filter expression.

Declaration
public virtual bool UpdateRecordByFilter(IDictionary record, string filterExpression)
Parameters
Type Name Description
IDictionary record

Specifes one or more name-value pairs for the record elements to be updated.

string filterExpression

Specifies an expression that qualifies the records to be updated. See the Remarks section for details.

Returns
Type Description
bool

This method returns True if a record is found to update and the Host Integrator server performs the record update, and False otherwise.

Remarks

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorServerException

Thrown if the table does not support updates

UpdateRecordByFilter(DataSet, string)

Changes the values of a record in the current recordset. The record that gets changed is the first one after the current record that satisfies the filter expression.

Declaration
public virtual bool UpdateRecordByFilter(DataSet record, string filterExpression)
Parameters
Type Name Description
DataSet record

Specifes one or more name-value pairs for the record elements to be updated.

string filterExpression

Specifies an expression that qualifies the records to be updated. See the Remarks section for details.

Returns
Type Description
bool

This method returns True if a record is found to update and the Host Integrator server performs the record update, and False otherwise.

Remarks

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorTerminalException

Thrown if there is an execution error

HostIntegratorServerException

Thrown if the table does not support updates

UpdateRecordByIndex(IDictionary, int)

Changes the values of a record in the current recordset. The record to change is determined by the specified index number.

Declaration
public virtual bool UpdateRecordByIndex(IDictionary record, int index)
Parameters
Type Name Description
IDictionary record

Specifes one or more name-value pairs for the record elements to be updated.

int index

Specifies the index of the record to update.

Returns
Type Description
bool

This method returns True if the Host Integrator server is able to perform the record update, or False otherwise.

Remarks

Changes the values of a record in the current recordset. The record to change is determined by the specified index number.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorTerminalException

Thrown if there is an execution error

UpdateRecordByIndex(DataSet, int)

Changes the values of a record in the current recordset. The record to change is determined by the specified index number.

Declaration
public virtual bool UpdateRecordByIndex(DataSet record, int index)
Parameters
Type Name Description
DataSet record

Specifes one or more name-value pairs for the record elements to be updated.

int index

Specifies the index of the record to update.

Returns
Type Description
bool

This method returns True if the Host Integrator server is able to perform the record update, or False otherwise.

Remarks

Changes the values of a record in the current recordset. The record to change is determined by the specified index number.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorTerminalException

Thrown if there is an execution error

UpdateRecords(IDictionary, string)

Updates the values of records in the current recordset, after the current record, that satisfy the specified filter expression.

Declaration
public virtual int UpdateRecords(IDictionary record, string filterExpression)
Parameters
Type Name Description
IDictionary record

Specifes one or more name-value pairs for the record elements to be updated.

string filterExpression

Specifies an expression that qualifies the records to be updated. See the Remarks section for details.

Returns
Type Description
int

This method returns the number of records updated.

Remarks

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorTerminalException

Thrown if there is an execution error

UpdateRecords(DataSet, string)

Updates the values of records in the current recordset, after the current record, that satisfy the specified filter expression.

Declaration
public virtual int UpdateRecords(DataSet record, string filterExpression)
Parameters
Type Name Description
DataSet record

Specifes one or more name-value pairs for the record elements to be updated.

string filterExpression

Specifies an expression that qualifies the records to be updated. See the Remarks section for details.

Returns
Type Description
int

This method returns the number of records updated.

Remarks

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

AND condition_expression AND condition_expression
OR condition_expression OR condition_expression
NOT NOT condition_expression
Equal to value_expression = value_expression
Equal to (case insensitive) value_expression =* value_expression
Not equal to value_expression <> value_expression
Less than value_expression < value_expression
Greater than value_expression > value_expression
Less than or equal to value_expression <= value_expression
Greater than or equal to value_expression >= value_expression ( ) (multiple condition_expressions)

Value Expressions

A value expression can take any of the following:

  • Variable (variables.variablename)
  • Attribute (attribute name)
  • Field (recordset.recordsetfield)
  • String
  • Integer
  • Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith"

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)
Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if the filter expression is not valid

HostIntegratorModelDefException

Thrown if a reference is made to a nonexistent field

HostIntegratorTerminalException

Thrown if there is an execution error

WaitForCondition(int, string)

Waits for a condition to be fulfilled.

Declaration
public virtual void WaitForCondition(int timeout, string entityName)
Parameters
Type Name Description
int timeout

Specifies a timeout period, in seconds.

string entityName

Name of entity to wait for.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorConnectorException

Thrown an argument is invalid

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if the conditional expression is not valid

HostIntegratorServerException

Thrown if the event times out

WaitForCondition(int, string, string)

Waits for a condition to be fulfilled.

Declaration
public virtual void WaitForCondition(int timeout, string expression, string entityName)
Parameters
Type Name Description
int timeout

Specifies a timeout period, in seconds.

string expression

Conditional expression.

string entityName

Specifies the name of an entity in the current Host Integrator model.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorConnectorException

Thrown an argument is invalid

HostIntegratorException

Thrown if the connection is for metadata only

HostIntegratorModelDefException

Thrown if the conditional expression is not valid

HostIntegratorServerException

Thrown if the event times out

WaitForCursor(int, int, int)

Waits for the presence of the terminal cursor at the specified terminal screen coordinates.

Declaration
public virtual void WaitForCursor(int rowNum, int columnNum, int timeout)
Parameters
Type Name Description
int rowNum

Specifies a row number in the terminal screen.

int columnNum

Specifies a column number in the terminal screen.

int timeout

Specifies a timeout period (in seconds). An exception is thrown if the timeout period elapses without the cursor arriving at the specified coordinates.

Remarks

Waits for the presence of the terminal cursor at the specified terminal screen coordinates.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorConnectorException

Thrown an argument is invalid

HostIntegratorServerException

Thrown if the event times out

HostIntegratorConnectorException

Thrown an argument is invalid

WaitForEntityChange(string, int)

Waits for the recognition of any entity other than the specified entity.

Declaration
[Obsolete("This method has been deprecated.  It can result in a race condition.")]
public virtual void WaitForEntityChange(string entityName, int timeout)
Parameters
Type Name Description
string entityName

Specifies the entity that cannot satisfy the entity change condition--typically the entity that is current when WaitForEntityChange is called.

int timeout

Specifies a timeout period (in seconds). An exception is thrown if the timeout period elapses without an entity other than the specified entity being recognized.

Remarks

Waits for the recognition of any entity other than the specified entity.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorConnectorException

Thrown an argument is invalid

HostIntegratorServerException

Thrown if the event times out

WaitForString(string, int, int, int)

Waits for the presence of the specified string starting at the specified screen coordinates.

Declaration
public virtual void WaitForString(string str, int rowNum, int columnNum, int timeout)
Parameters
Type Name Description
string str

Specifies the string to wait for.

int rowNum

Specifies the row where the string is to appear (use -1 to designate any row).

int columnNum

Specifies the column where the string is to appear (use -1 to designate any column).

int timeout

Specifies a timeout period (in seconds). An exception is thrown if the timeout period elapses before the specified string appears at the specified screen location.

Remarks

Waits for the presence of the specified string starting at the specified screen coordinates.

Exceptions
Type Condition
HostIntegratorServerException

Thrown if the event times out

HostIntegratorConnectorException

Thrown an argument is invalid

HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorException

Thrown if the connection is for metadata only

WaitForStringRelCursor(string, int, int, int)

Waits for the presence of a string at a screen location relative to the current terminal screen cursor.

Declaration
public virtual void WaitForStringRelCursor(string str, int rowOffset, int columnOffset, int timeout)
Parameters
Type Name Description
string str

Specifies the string to wait for.

int rowOffset

Specifies the starting screen row for the string relative to current cursor row.

int columnOffset

Specifies the starting screen column for the string relative to current cursor column.

int timeout

Specifies a timeout period (in seconds). An exception is thrown if the timeout period elapses before the specified string appears at the specified screen location.

Remarks

Waits for the presence of a string at a screen location relative to the current terminal screen cursor.

Exceptions
Type Condition
HostIntegratorConnectorException

Thrown if client is not connected

HostIntegratorConnectorException

Thrown an argument is invalid

HostIntegratorServerException

Thrown if the event times out

HostIntegratorConnectorException

Thrown an argument is invalid

In This Article
Back to top © 1985-2024 Rocket Software, Inc. or its affiliates. All Rights Reserved