cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Remote - Subscribe By Restriction - Expression

Former Member
0 Kudos

Is it possible to use the Remote Subscription Value in a Expression?

In addition to the subscription value, I'd like to distribute rows with null value in the subscribe by column.

Example:

table.column = subscribe.value OR table.column IS NULL

If so, how may I reference the subscribe value in the expression?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188493
Contributor
0 Kudos

Try using SYSSUBSCRIPTION.subscribe_by:

CREATE PUBLICATION PubOrders ( TABLE SalesOrders SUBSCRIBE BY SalesRepresentativeID );
GRANT CONNECT TO Sam_Singer IDENTIFIED BY sql;
GRANT REMOTE TO Sam_Singer TYPE SMTP ADDRESS 'Singer, Samuel';
CREATE SUBSCRIPTION TO PubOrders ('8887') FOR Sam_Singer;

SELECT SYSSUBSCRIPTION.subscribe_by 
  FROM SYSSUBSCRIPTION 
          INNER JOIN SYSUSER
             ON SYSSUBSCRIPTION.user_id = SYSUSER.user_id
          INNER JOIN SYSPUBLICATION
             ON SYSSUBSCRIPTION.publication_id = SYSPUBLICATION.publication_id
 WHERE SYSUSER.user_name               = 'Sam_Singer' 
   AND SYSPUBLICATION.publication_name = 'PubOrders';
         
subscribe_by
'8887'