Could you please help us to get the SQL Query to extract the default allocation Percentage in Prteam table ? Thanks in advance for the help.
Unfortunately it is not a simple piece of data held in the database, there is some discussion here ; https://communities.ca.com/thread/2280432 regarding the complexity of this.
Yes this is quite messy. and I generally need a beer or two to wrap my head around it.
Hi - Did Dave's response help you resolve your issue? If so please mark as Correct Answer. Thanks! Chris
Also, look at the following technical article:
Document ID: TEC439131
The PRALLOCCURVE field is a BLOB field that cannot be read through a SQL query.
You may be able to get it using XOG for the Team??? Have you explored that option?
Retrieving data ...