on 05-08-2015 12:01 PM
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?
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'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.