RI_REPLACE usage (need help).
Posted: Wed Dec 17, 2003 6:17 pm
[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__