SQL Query to Retrieve Rep Subscription Where Clause

Skip to Content

Actions

May 19, 2015 | 9 Views |

SAP Replication Server

Hi All,

I’m wondering if someone already develop a simple query based in replication metadata to retrieve the subscription where clause string.

If yes do you mind to shared it 😀

i have a proc to do do this but looks me super complex to adapt to a normal sql query

Thanks

Joao

To report this post you need to login first.

You must be Logged on to comment or reply to a post.

Mark A Parsons May 19, 2015 at 3:21 pm

NOTE: You should probably post these types of questions as a ‘discussion’ (not as a ‘document’).

There is no ‘simple’ query for reverse engineering a subscription ‘where’ clause.

Your best bet is to look at the source code for rs_helpsub and rs_subddl (called by rs_helpsub). These should contain all the logic for reverse engineering the DDL (including the ‘where’ clause) for a given sub.

like (0)
1. Joao Pedro Costa Post authorMay 19, 2015 at 3:39 pm
  
  hi mark,
  
  thanks for feedback .
  
  the complexy of rs_subddl for where clauses is quite hard to make simple but i will try anyway.
  
  thanks for your feedback
  
  regards
  
  Joao
  
  like (0)
2. Jason Froebe May 21, 2015 at 12:52 pm
  
  Sounds like an excellent candidate for an “Ed Barlow” stored procedure IMO
  
  like (0)
  1. Mark A Parsons May 21, 2015 at 4:55 pm
    
    FWIW, cutting-n-pasting the important parts from rs_subddl is relatively easy (as opposed to reinventing the wheel).
    
    like (0)