When you submit an application with embedded SQL, you can specify the authorization ID (or schema) that owns the application. You use the SQL Preprocessor AUTHID= option to make this assignment.
The value you assign to AUTHID= must be the name of a schema which already exists in the CA Datacom Datadictionary.
In COBOL, you can also specify the plan name for an application using the SQL Preprocessor's PLANAME= option. If you do not assign a value to PLANAME=, the plan name defaults to the value specified for the PROGRAM-ID in your COBOL application.
In PL/I, C, and Assembler, you must also specify the plan name for an application using the SQL Preprocessor's PLANAME= or PLANNAME= option.
In COBOL and Assembler, the plan name must be unique for each program owned by a specific authorization ID.
When you precompile or preprocess a program with embedded SQL, CA Datacom Datadictionary creates a PLAN entity-occurrence and relates this occurrence to the specific program. The name of the PLAN occurrence is formed by concatenating the authorization ID and the plan name, that is to say, the value assigned:
A plan name remains associated with a specific application. You can update a plan if you make changes to an application by rebinding the plan, or, if necessary, precompiling the application again.
In COBOL, if a rebind fails and you have to precompile the application, you must use the same authorization ID and plan name specified during the first precompile.
|
Copyright © 2014 CA.
All rights reserved.
|
|