I have a handler in CIC 2.2 doing a database query using the DB Stored Procedure step. The stored procedure is taking really long (the Informix database is slow) to return a result set. To the caller, this is a really long pause of silence. Is there a way to play a music or message while waiting for the database query to complete? The music should stop playing as soon as the the DB Fetch step could be reached.

Right before you execute the DB query, use the Hold toolstep (telephony tab). As soon as it returns, use the PickUp toolstep on the call. If you want to play a specific file (it will loop) you set the OnHoldAudioFile to a filename that exists in the resources directory. You might want to cache the value and then reset it to the existing after you are done with this.

Hi Loucks, Thanks for the suggestion. I tested it out on CIC2.4 and it works. Now to try it in CIC2.2. I currently have Hold step's parameter claim control of this call = false. Pick Up step's claim control of this call = true, and Move Call to System Queue= false. Going to do a few more tests to see if this serves my purpose. Thanks again.