OnDemand User Group

Support Forums => Other => Topic started by: Steve C on October 30, 2006, 11:45:01 AM

Title: Exit to manipulate query SQL?
Post by: Steve C on October 30, 2006, 11:45:01 AM

Does anyone have any documentation on an exit which manipulates the SQL query before executing it to generate a hitlist?

There was mention of one at the conference.


Cheers

     Steve

Title: Re: Exit to manipulate query SQL?
Post by: elweare on November 24, 2006, 04:43:01 PM

Steve there is an exit called ARSUPERM. You will find a copy of it in the exits library. As coded it does not checking. Activation of the exit is via the config file based on key word settings of what you want to check. In our case we do SQL checking and then consturct a SQL-R gualification that is used to restrict the hitlist when CMOD actually performs the query.