Use DESCRIBE PROCEDURE to list all the parameters used by the specified procedure or function. The DESCRIBE PROCEDURE statement
returns one row for each parameter, containing:

Parameter The name of the parameter.

Type The data type of the parameter.

In/Out Information about what is passed to, or returned from, the parameter. Possible values are:

In The parameter is passed to the procedure, but is not modified.

Out The procedure ignores the parameter's initial value and sets its value when the procedure returns.

In/Out The parameter is passed to the procedure and the procedure sets the parameter's value when the procedure returns.

Result The parameter returns a result set.

Return The parameter returns a declared return value.

If you do not specify either TABLE or PROCEDURE (for example, DESCRIBE object-name), Interactive SQL assumes the object is a table. However, if no such table exists, Interactive SQL attempts to describe the
object as either a procedure or a function.

Use Syntax 2 to list information about the database or database server that Interactive SQL is connected to. The following
properties are returned:

Database Product The name and version number of the database product Interactive SQL is connected to (for example, SQL Anywhere 11.0.0.83).

Host Name The network name of the computer the database server is running on.

Host TCP/IP Address The IP address of the computer the database server is running on.

Host Operating System The name and version number of the operating system used by the computer the database server is running on.

Server Name The name of the database server.

Server TCP/IP Port The port number used by the database server for the current connection.

Database Name The name of the database that Interactive SQL is connected to.

Database Character Set The character set used for CHAR columns in the database.

Connection String The connection string that was used to connect to the database or database server. Three asterisks replace passwords.

Properties that do not apply to the current connection are omitted. For example, if you connect to a database server using
shared memory, then the TCP/IP port is omitted.