Listing Target-Scope Function Strings

Use the rs_helpobjfstring stored procedure to list target-scope function strings for databases such as Adaptive Server and Oracle, that support stored procedures.

To list customized function strings for replicate or standby tables or stored procedures, enter:
rs_helpobjfstring data_server, database, [owner.]object_name[, function_name]
Suppose you create a target-scope function string for the upd_datetime stored procedure:
create function string upd_datetime.upd_datetime
     for database NY_DS.rdb1
     with overwrite
          output language
          'update datetime set
          row_num = ?row_num!param?,
          datecol = ?datecol!param?,
          timecol = ?timecol!param?,
          ndatecol = ?ndatecol!param?,
          ntimecol = ?ntimecol!param?,
          comment = ?comment!param?
          where
          row_num = ?row_num!param?'
If you enter:
  • rs_helpobjfstring NY_DS,rdb1,upd_datetime
    or
  • rs_helpobjfstring NY_DS,rdb1,upd_datetime,upd_datetime
You see:
Function String information for Target Object: 'upd_datetime'.

Object Name     Object Type        Function Name   
-----------     -----------        --------------  
upd_datetime    stored procedure   upd_datetime    

Function String Name   Output Type Option       System Generated
--------------------   -------------------      -----------------
upd_datetime           language not applicable  no


         --- Beginning of Function String Text ---

FString Text
-----------------------------------------------------------------
 update datetime set
         row_num = ?row_num!param?,
         datecol = ?datecol!param?,
         timecol = ?timecol!param?,
         ndatecol = ?ndatecol!param?,
         ntimecol = ?ntimecol!param?,
         comment = ?comment!param?
         where
         row_num = ?row_num!param?

         --- End of Function String Text ---


(return status = 0)
See Replication Server Reference Manual > RSSD Stored Procedures > rs_helpobjfstring for more examples and usage information.
Parent topic: Target-Scope Customized Function Strings