02-13-2012 07:36 AM - edited 03-14-2019 09:21 AM
Is it possible to find out what exately what these stored procedures do? I can't get access to them in UCCX databse with HR user login
"sp_csq_activity" and "sp_csq_call_distribution"
Henrik
Solved! Go to Solution.
02-14-2012 12:29 AM
Hi
They're all accesible in my experience. Some are added as 'functions' and some as 'procedures' seemingly in a fairly arbitrary fashion.
I've found that Squirrel SQL can only read one of the types (functions or procedures, can't recall which) but other products will show both:
AGS Server Studio - expensive
Razor SQL - cheaper
IBM Data Studio - free :-)
The initial 8.0 versions had lots of permission problems but these are all sorted on 8.5 I think.
Principal Engineer at Logicalis UK
Please rate helpful posts...
02-13-2012 09:50 AM
Hi Henrik,
These stored procedures are used to generate reports for that particular CSQ by either activity or distribution
In previous versions prior to 8.0 You could try running it from osql the command prompt and it should look similar to this, but copy the exact command after running the HRC report for the csq_activity and this query will be present in the HRC log files
Exec db_cra.dbo.sp_csq_activity '... AM', '..., 0, '
However from 8.0 onwards you would have to enable root access and be in the SU informix mode to run these queries
Thanks,
Prashanth
02-14-2012 12:24 AM
Hi Prashanth
Thanks. I have a customer who wants to know from which tables and columns these reports are created and therefore would like to know how the SP is designed.
Henrik
02-14-2012 12:29 AM
Hi
They're all accesible in my experience. Some are added as 'functions' and some as 'procedures' seemingly in a fairly arbitrary fashion.
I've found that Squirrel SQL can only read one of the types (functions or procedures, can't recall which) but other products will show both:
AGS Server Studio - expensive
Razor SQL - cheaper
IBM Data Studio - free :-)
The initial 8.0 versions had lots of permission problems but these are all sorted on 8.5 I think.
Principal Engineer at Logicalis UK
Please rate helpful posts...
02-14-2012 12:33 AM
Hi Aaron
Thanks, I'll give of of those a try
Henrik
04-03-2012 07:43 AM
I think that it would be useful to have a list of the stored procedure contents in the UCCX database schema to help with custom UCCX reporting. Can someone post the stored procudures on this forum? Once I find them I will be glad to post them.
09-19-2012 05:08 AM
Mike,
Did you ever post these? I seem to be having issues displaying the historical reports stored procedures. I can't see any with Squirrel. IBM Data Manager allows me to see some, but i don't see any of the ones used for reports under the db_cra database.
Thanks,
Pat.
09-19-2012 05:28 AM
I did find them all using IBM Data Manager, but there is no easy way to export them and they definately won't fit in a single post. Is there a certain one you are looking for?
09-19-2012 05:34 AM
Mike,
Thanks for the very quick reply. Right after I posted this, I finally found where they are storing them. I was looking for the stored procedures under stored procedures. I'm silly that way sometimes. I now see that the majority of stored procedures (and all of the ones used by the historical reporting client) are stored under "user-defined functions". I'm good for now.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide