Displays the parameters and function-string text for target scope function strings.
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?'
rs_helpobjfstring NY_DS,rdb1,upd_datetimeor
rs_helpobjfstring NY_DS,rdb1,upd_datetime,upd_datetime
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)
create function string dbo.datetime.rs_insert for database NY_DS.rdb1 with overwrite output language 'insert datetime values ( ?row_num!new? , ?datecol!new? , ?timecol!new? , ?ndatecol!new? , ?ntimecol!new? , ?comment!new?) update fn_monitor set insert_count = insert_count + 1'
rs_helpobjfstring NY_DS,rdb1,'dbo.datetime',rs_insert
Function String information for Target Object: 'dbo.datetime'. Object Name Object Type Function Name ------------- ----------- -------------- datetime table rs_insert Function String Name Output Type Option System Generated -------------------- ------------------- ---------------- rs_insert language not applicable no --- Beginning of Function String Text --- FString Text ----------------------------------------------------------------- insert datetime values ( ?row_num!new? , ?datecol!new? , ?timecol!new? , ?ndatecol!new? , ?ntimecol!new? , ?comment!new?) update fn_monitor set insert_count = insert_count + 1 --- End of Function String Text --- (return status = 0)
rs_helpobjfstring NY_DS,rdb1,datetime,rs_insertYou see:
Target Object 'datetime' does not have customized function string. (return status = -1
create function string dbo.tbl1.rs_writetext; unitext_fld1 for NY_DS.rdb1 output RPC 'exec update_repl_unitext @p_key = ?p_key!new?, @unitext_fld = ?unitext_fld1!new?, @last_chunk = ?rs_last_text_chunk!sys?'
rs_helpobjfstring NY_DS,rdb1,'dbo.tbl1',rs_writetext
Function String information for Target Object: 'dbo.tbl1'. Object Name Object Type Function Name ------------- ----------- -------------- tbl1 table rs_writetext Function String Name Output Type Option System Generated ---------------------- ------------------- ---------------- unitext_fld1 RPC not applicable no --- Beginning of Function String Text --- FString Text ----------------------------------------------------------------- exec update_repl_unitext @p_key = ?p_key!new?, @unitext_fld = ?unitext_fld1!new?, @last_chunk = ?rs_last_text_chunk!sys? --- End of Function String Text --- (return status = 0)
create function string dbo.tbl1.rs_datarow_for_writetext for NY_DS.rdb1 output RPC 'exec update_txtimg_stat @p_key = ?p_key!new?, @txtfld_stat = ?unitext_fld1!text_status?'
rs_helpobjfstring NY_DS,rdb1,'dbo.tbl1',rs_datarow_for_writetext
Function String information for Target Object: 'dbo.tbl1'. Object Name Object Type Function Name ------------- ----------- -------------- tbl1 table rs_datarow_for_writetext Function String Name Output Type Option System Generated -------------------- ------------------ ---------------- rs_datarow_for_writetext RPC not applicable no --- Beginning of Function String Text --- FString Text ---------------------------------------------------------------- exec update_txtimg_stat @p_key = ?p_key!new?, @txtfld_stat = ?unitext_fld1!text_status? --- End of Function String Text --- (return status = 0)
rs_helpobjfstring NY_DS,rdb1,'dbo.tbl1'
rs_helpobjfstring NY_DS,rdb1,'dbo.tbl1',rs_datarow_for_writetextfrom this example, and
rs_helpobjfstring NY_DS,rdb1,'dbo.tbl1',rs_writetextfrom Example 3
If you do not supply a function_name, rs_helpobjfstring displays all function strings of the object.
If you supply a function_name, rs_helpobjfstring displays function strings that match function_name, such as rs_insert, rs_delete, rs_update, and rs_select, or a user-defined function.
System-generated default function strings have no function-string text stored in the RSSD. For these function strings, rs_helpobjfstring shows “System-Supplied Transact-SQL Statement”.