SQL/MP Programming Manual for C

Contents

HP NonStop SQL/MP Programming Manual for C—429847-008

6. Explicit Program Compilation (continued)

Running the TNS C Compiler in the Guardian Environment 6-9

Running the TNS/R NMC and TNS/E CCOMP Compiler in the Guardian

Environment 6-10

Binding SQL Program Files in the Guardian Environment 6-11

Running the SQL Compiler in the Guardian Environment 6-12

SQL Program File Format 6-24

SQL Compiler Listings 6-25

Developing a C Program in the OSS Environment 6-28

Using TACL DEFINEs in the OSS Environment 6-29

Using the c89 Utility in the OSS Environment 6-30

Developing a C Program in a PC Host Environment 6-33

Using CONTROL Directives 6-34

Static SQL Statements 6-34

Dynamic SQL Statements 6-36

Using Compatible Compilation Tools 6-36

C Compiler 6-36

SQL Compiler 6-36

SQL Program Files 6-37

7. Program Execution

Required Access Authority 7-1

Using TACL DEFINEs 7-2

Entering the TACL RUN Command 7-3

Running a Program in the OSS Environment 7-3

Running a Program at a Low PIN

7-4

Interactive Commands

7-5

Programmatic Commands

7-5

Pathway Environment 7-6

Determining Compatibility With the SQL Executor 7-7

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