SQL/MP Programming Manual for COBOL85

Contents

HP NonStop SQL/MP Programming Manual for COBOL85—429326-004

7. Program Execution

Required Access Authority 7-1

Using DEFINEs 7-1

Entering the TACL RUN Command 7-2

Using the CREATEPROCESS Routine 7-3

Running a Program in the OSS Environment 7-4

Running a Program at a Low PIN on a D-Series Node 7-4

Interactive Commands 7-5

Programmatic Commands 7-5

Pathway Environment 7-6

Determining Compatibility With the SQL Executor 7-6

8. Program Invalidation and Automatic SQL Recompilation

Program Invalidation 8-1

SQL Compiler Validation Functions 8-1

Causes of Program Invalidation 8-2

File-Label and Catalog Inconsistencies 8-4

Preventing Program Invalidation 8-4

Automatic SQL Recompilation 8-5

Causes of Automatic Recompilation 8-6

Run-Time Recompilation Errors 8-9

Preventing Automatic Recompilations 8-9

9. Error and Status Reporting

Using the INCLUDE STRUCTURES Directive 9-1

Generating Structures With Different Versions 9-2

Checking the Version of the COBOL85 Compiler

9-2

Sharing Structures

9-3

Returning Error and Warning Information 9-4

Checking the SQLCODE Identifier 9-4

Using the WHENEVER Directive 9-6

Returning Information From the SQLCA 9-11

Returning Performance and Statistics Information 9-20

10. Dynamic SQL Operations

Using Dynamic SQL 10-2

Uses for Dynamic SQL 10-3

Determining When to Use Dynamic SQL 10-4

Features of Dynamic SQL 10-4

Processing Database Requests 10-4