Previous Topic Next topic Print topic


ACCESS

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.

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.

Previous Topic Next topic Print topic