GET_SQLSERVER_NAME¶

Applies to: SQLFlex

This command returns the name of the server based on the specified index number. The number of servers can be retrieved from GET_NO_AVAILABLE_SQLSERVERS and the names can be indexed from that number.

Syntax

GET_SQLSERVER_NAME {index} to {variable}

Parameter	Description
index	The numbered index name to retrieve
variable	Variable to hold the server name

Example

GET_NO_AVAILABLE_SQLSERVERS to iServers

While (i <= iServers)
    GET_SQLSERVER_NAME i to sServer
    Showln sServer
    Increment i
Loop

GET_NO_AVAILABLE_SQLSERVERS