ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Does DATAQUERY create an SQL Plan for an SQL-Mode query? If so, does that plan persist past the execution of the query?

book

Article ID: 14310

calendar_today

Updated On:

Products

Datacom DATACOM - AD

Issue/Introduction



Does Dataquery create a PLAN in DATA-DICT for a Dataquery online execution? 

If so,does that PLAN persist past the execution of the query?

 

Environment

z/OS z/VSE CA Dataquery

Resolution

Yes, an SQL PLAN is created and is deleted when you sign off from Dataquery .

In CICS, the plan name is DQ +termid +P  .

You can override some default PLAN options if you like .

 

 

Additional Information

See the CA Dataquery Administration Guide  '  SQL Plan Options'  here if you want to override default PLAN options.