RI_REPLACE usage (need help).

[net4ward]

[updated:LAST EDITED ON Dec-17-03 AT 06:39 PM (EST)]Can you direct me to better documentation on how to use the RI_REPLACE paramter in a Text Control table.____The Developers Guide talks about it and shows examples, but not too detailed.____For Example:____I have an SQL Procedure statement that accepts parameters. I would like to call the Stored Proc using RSWUSER by default like:____EXEC sFundUnitTradeWithUndo ^08/06/2003^, ^08/06/2003^, 51____but I would like to be able to replace the parameters. Do I do it like one of these?____Example1:__EXEC sFundUnitTradeWithUndo <<^08/06/2003^>>, <<^08/06/2003^>>, <<51>>__or Example2:__EXEC sFundUnitTradeWithUndo ^<<08/06/2003>>^, ^<<08/06/2003>>^, <<51>>____Then set up a Text Control File containing:____Example1:__ RI_REPLACE=<<^08/07/2003^>>, <<^08/08/2003^>>, <<50>>__Example2:__ RI_REPLACE=<<08/07/2003>>, <<08/08/2003>>, <<50>>____The question basically boils down to delimeters and placement on the replacable fields.____That would be great if you could provide an example.____Thanks in Advance,____John Ward__

[kfleming]

You would use the first example of each of these.____EXEC sFundUnitTradeWithUndo <<^08/06/2003^>>, <<^08/06/2003^>>, <<51>>____RI_REPLACE=<<^08/07/2003^>>, <<^08/08/2003^>>, <<50>>______Kathleen__R&R Support