NodeType Connection Parameter

Specifies the server role for a logical server member node.

Usage

Anywhere

Values

{ READER | WRITER | ANY }

Default

ANY

Description

A logical server can have both reader and writer nodes as members. This parameter allows an application to connect to a member node with a specific role. You can specify the desired role as NODETYPE = {READER | WRITER | ANY}

READER – applications that execute user-defined functions may need to connect to a member node with the READER role.
WRITER – applications that execute statements (such as INSERT, UPDATE, and DELETE) may need to connect to a member nodewith the WRITER role.
ANY – most read-only applications (that do not execute any UDF) can connect to any member node of the logical server.

SAP Sybase IQ ignores the connection parameter NodeType when you log in with the SERVER logical server context.