Micro Focus Studio Enterprise Edition Test Server > Programming > Mainframe Programming > HCO for SQL Server (HCOSS) > Reference > SQL Compiler Directive Options - HCOSS > BIND

BIND

Syntax

BIND=bind-script-file

Parameters:

bind-script-file: The name of the bind file.

Properties:

Default:

BIND=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:

Security can be applied separately to procedures and data so that application users can only access and update data via the application.
DBAs can review SQL that is to be deployed without having to access source code.

Comments:

The filename extension for generated bind script files is .sql. For example, if you specify BIND=myprog, the generated bind script file name is myprog.sql.

To update the SQL Server database, run the generated bind script file using sqlcmd or from SQL Server Management Studio.

The generated bind script file contains commands to create 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.