Program

A program is an object that is created as a result of the compilation process for non-ILE compilations or as a result of the bind process for ILE compilations.

An access plan is a set of internal structures and information that tells SQL how to run an embedded SQL statement most effectively. It is created only when the program has been successfully created. Access plans are not created during program creation for SQL statements if the statements refer to an object, such as a table or view, that cannot be found or to which you are not authorized.

The access plans for such statements are created when the program is run. If, at that time, the table or view still cannot be found or you are still not authorized, a negative SQLCODE is returned. Access plans are stored and maintained in the program object for non-distributed SQL programs and in the SQL package for distributed SQL programs.