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

SQL_AVAILABLE_SQL_SERVER_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