Author Topic: Exit to manipulate query SQL?  (Read 23271 times)

Steve C

  • Guest
Exit to manipulate query SQL?
« 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

elweare

  • Guest
Re: Exit to manipulate query SQL?
« Reply #1 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.