Hi Gokul -
Unless you query a catalog table in your program, you'd most like not
write the Fully-Qualified name of the table. Here's a little insight into why - When you write a Query in SPUFI or QMF, you'd write
SELECT SEQ_NUM,ANNTY_AMT FROM CSSP.TCTEMPE_PLN;
The Creator-name CSSP is specified, because SPUFI or QMF execute them dynamically. There are no plans.When you write Embedded SQL Queries in a COBOL Program/any other compiled language, you'd write
SELECT SEQ_NUM,ANNTY_AMT FROM TCTEMPE_PLN
Several Mainframe Shops have region-wise different DB2 PLANs. For example, a DB2 PLAN for Production, another PLAN for QA Testing region, another PLAN for Development Region, and yet one more for UAT Region. During BIND PLAN, you'd specify the QUALIFIER() option, so as to add your SQL Executable instructions to the correct plan.