sp_iqmpxsubscribeuser procedure

Function

Creates the SQL Remote subscription to IQMP_PUB for a multiplex user.

Syntax

sp_iqmpxsubscribeuser( IN _user VARCHAR(30),
		IN _path LONG VARCHAR default NULL,
IN _perm VARCHAR(15) default ‘REMOTE’
		)

Description

**Table 9-40: sp_iqmpxsubscribeuser columns**
Column name	Description
_user	User name to subscribe
_path	Directory path for this remote. If NULL, se t the subscription but do not change the SQL Remote configuration otherwise.
_perm	‘REMOTE’ or ‘CONSOLIDATE.’ This user’s role in SQL Remote.

Sybase IQ uses SQL Remote to replicate data among multiplex servers. Data replicated by SQL Remote is arranged in publications. The consolidated database is the one where changes will be replicated, and the remote databases is the one where changes are made. Each database that shares information in a publication must have a subscription to the publication. For more details, see the Adaptive Server Anywhere SQL Remote User’s Guide.

Usage

Used internally by other stored procedures.