Enables deployment of application code and SQL by updating the SQL Server database at compile time.
Creates a stored procedure at compile time for most static SQL statements.
Syntax:
ACCESS=access-plan-name
Parameters:
- access-plan-name
- The name of the access plan.
Properties:
| Default:
|
ACCESS=prog-name
Where
prog-name is the COBOL program name.
|
Dependencies:
ACCESS and DBRMLIB are mutually exclusive.
Scope:
| Used at compile time:
|
Yes
|
| Behavior at run time:
|
Source file
|
See
Scope - HCOSS SQL Compiler Directive Options
for more information.
Advantages:
Convenient for testing when the BIND SQL compiler directive option is to be used for deployment.
Comments:
Less compatible with mainframe deployment behavior than using a combination of the DBRMLIB compiler directive and the DSN Bind utility.
HCOSS generates a separate stored procedure in the schema specified by your SQL Server connection for each static SQL statement in the program.
If stored procedures from a previous compilation are present in the schema, HCOSS drops them before creating new stored procedures.
