rs_helprep stored procedure displays quoted identifiers.
Example 1 Given this table and replication definition:
create table t1 (c1 int, c2 int)
create replication definition r1 with primary at ost_wasatch_08.pdb1 with all tables named t1 (c1 int, "c2" int quoted) primary key (c1)
rs_helprep r1 displays c2 as
a quoted identifier:
Replication Definition Name PRS Type Creation Date ---------------------------- -------------------- ---- ------------------- r1 ost_wasatch_09 Tbl Nov 11, 2008 2:28PM PDS.DB Primary Owner Primary Table -------------------- -------------------- -------------------- ost_wasatch_08.pdb1 t1 Replicate Owner Replicate Table -------------------- -------------------- t1 Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep. -------------- --------------- -------- ----------- -------------- No No 1000 On None Col. Name Rep. Col. Name Datatype Len. Pri. Col. Searchable --------- -------------- -------- ---- --------- ---------- c1 c1 int 4 1 0 "c2" "c2" int 4 0 0 Function Name FString Class FString Source FString Name ------------- --------------------------- -------------- ------------ rs_delete rs_sqlserver_function_class Class Default rs_delete rs_insert rs_sqlserver_function_class Class Default rs_insert rs_select rs_sqlserver_function_class Class Default rs_select rs_select_ rs_sqlserver_function_class Class Default rs_select_ with_lock with_lock rs_truncate rs_sqlserver_function_class Class Default rs_truncate rs_update rs_sqlserver_function_class Class Default rs_update Subscriptions known at this Site 'ost_wasatch_09'. Subscription Name Replicate DS.DB Owner Creation Date ----------------- --------------- ----- ------------- (return status = 0)
Example 2 Given the table and replication definition defined in example 1, when you define t1 as a quoted identifier:
alter replication definition r1 alter replicate table name "t1" quoted
rs_helprep r1 displays c2 and t1 as
quoted identifiers:
Replication Definition Name PRS Type Creation Date ---------------------------- -------------------- ---- ------------------- r1 ost_wasatch_09 Tbl Nov 11, 2008 2:28PM PDS.DB Primary Owner Primary Table -------------------- -------------------- -------------------- ost_wasatch_08.pdb1 "t1" Replicate Owner Replicate Table -------------------- -------------------- "t1" Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep. -------------- --------------- -------- ----------- -------------- No No 1000 On None Col. Name Rep. Col. Name Datatype Len. Pri. Col. Searchable --------- -------------- -------- ---- --------- ---------- c1 c1 int 4 1 0 "c2" "c2" int 4 0 0 Function Name FString Class FString Source FString Name ------------- --------------------------- -------------- ------------ rs_delete rs_sqlserver_function_class Class Default rs_delete rs_insert rs_sqlserver_function_class Class Default rs_insert rs_select rs_sqlserver_function_class Class Default rs_select rs_select_ rs_sqlserver_function_class Class Default rs_select_ with_lock with_lock rs_truncate rs_sqlserver_function_class Class Default rs_truncate rs_update rs_sqlserver_function_class Class Default rs_update Subscriptions known at this Site 'ost_wasatch_09'. Subscription Name Replicate DS.DB Owner Creation Date ----------------- --------------- ----- ------------- (return status = 0)
Example 3 Given the replication definition defined in example 2, when you define c2 as not quoted:
alter replication definition r1 alter columns c2 not quoted
rs_helprep r1 displays t1 as
the only quoted identifier:
Replication Definition Name PRS Type Creation Date ---------------------------- -------------------- ---- ------------------- r1 ost_wasatch_09 Tbl Nov 11, 2008 2:28PM PDS.DB Primary Owner Primary Table -------------------- -------------------- -------------------- ost_wasatch_08.pdb1 "t1" Replicate Owner Replicate Table -------------------- -------------------- "t1" Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep. -------------- --------------- -------- ----------- -------------- No No 1000 On None Col. Name Rep. Col. Name Datatype Len. Pri. Col. Searchable --------- -------------- -------- ---- --------- ---------- c1 c1 int 4 1 0 c2 c2 int 4 0 0 Function Name FString Class FString Source FString Name ------------- --------------------------- -------------- ------------ rs_delete rs_sqlserver_function_class Class Default rs_delete rs_insert rs_sqlserver_function_class Class Default rs_insert rs_select rs_sqlserver_function_class Class Default rs_select rs_select_ rs_sqlserver_function_class Class Default rs_select_ with_lock with_lock rs_truncate rs_sqlserver_function_class Class Default rs_truncate rs_update rs_sqlserver_function_class Class Default rs_update Subscriptions known at this Site 'ost_wasatch_09'. Subscription Name Replicate DS.DB Owner Creation Date ----------------- --------------- ----- ------------- (return status = 0)
