Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
I know that CCX DB Read and DB Write steps let you create SQL statements that include variables as parameters using the "$" prefix. But is there any way to build the entire SQL string "by hand" (perhaps with the "Set" step) and pass that to the DB R...
All good now. Pilot error. I was using a login that didn't have privileges to execute a stored procedure.Advice on this thread was helpful. FWIW, I don't seem to need to declare and return anything. A single EXECUTE statement does the trick.-Davi...
I feel like an idiot reviving this topic but I think I've followed all the guidelines and have had zero success. If I paste this code directly into MS Management Studio, it runs perfectly, but fails when embedded in a DB Read step in UCCX 8.5 Premiu...
Gergely, thank you so much for this amazing article! I somehow never realized until now that so much Java code could be embedded in a Set step. This is huge for me!
Yes, sorry, I kind of veered from my original topic. I'm basically looking for any options that will make dealing with the database more flexible and "natural" for me.Thanks for your feedback and interest--David
Darn. I was aiming for clarity. Sorry I didn't do better. Will try to answer questions if you have them.In case it's a help, this excellent article is what got me going on my approach:http://www.sommarskog.se/share_data.htmlBest--David