A_SYB_DEFAULT_CONNECTION configuration variable

A_SYB_DEFAULT_CONNECTION specifies the name of the server to which the runtime will connect. Acu4GL for Sybase checks this variable only if the DSQUERY environment variable has not been set. (Note that Sybase recommends assigning a value to the DSQUERY environment variable.) If neither DSQUERY nor A_SYB_DEFAULT_CONNECTION is set, the default server is named SYBASE, just as for isql. To reference tables in another server, open the file servername.database.owner.table.

Example

Suppose you have two servers, one named TOM and one named HARRY. If most of the tables you want to access are on the server HARRY, you should set:

A_SYB_DEFAULT_CONNECTION  HARRY

For those occasions when you want to access the TOM server, you could open the file this way:

TOM.stores.johndoe.purch1

See also: The Sybase documentation on isql.