DQL Read - Executed DQL

Hi,

Is there a way to display an executed DQL with values bounded from a DQL Read actvity? For example, the DQL inputed is static during the build time. During runtime, the actual values are assigned. I would like to know if there a field that stores the dynamically executed DQL with values assigned to troubleshoot what values are exactly mapped.

Thank you.

Find more posts tagged with

Comments

Miller-zzMST

Hi,

No, there is no such field.

Can you describe a more detailed your requirements?

~ Konstantin

kumaran1000001

Thanks Konstantin,

I was looking to see if there is a way to see the fully-qualified executed DQL by a DQL read actvity other than turning on tracing. For example, during the build time, we may specify something like "select a,b,c, from q where p=? and q=? and r=?

However, during execution, since the engine prefills the values. my question was if there is a way to see the executed sql:

For example, "select a,b,c, from q where p=1 and q=2 and r=3".

FYI->The ones that we use in production is very complex and lengthy query. We do not have audit trail or tracing turned on for this specific activity.

Thanks again.