Database Server Naming Restrictions

If you use the -n switch in start_iq [server-options], certain naming restrictions apply.

No character set is conversion performed on the server name. If the client character set and the database server character set differ, using extended characters in the server name can cause the server to not be found. If clients and servers run on different operating systems or locales, use 7-bit ASCII characters in the server name.

Database server names must be valid identifiers. Long database server names are truncated to different lengths depending on the protocol. Database server names cannot:

Begin with white space, single quotes, or double quotes
End with white space
Contain semicolons
Exceed 128 bytes

Note: On Windows and UNIX, SAP Sybase IQ 12.7 and earlier clients cannot connect to SAP Sybase IQ 16.0 database servers with names longer than the following lengths:

40 bytes for Windows shared memory
31 bytes for UNIX shared memory
40 bytes for TCP/IP

The server name specifies the name to be used on client application connection strings or profiles. Running multiple database servers with the same name is not recommended.