SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
A-1
A C Sample Programs
This appendix presents the steps shown in figures in previous sections as complete C
programs.
Using a Static SQL Cursor
Example A-1 executes the steps shown in Figure 6-1 on page 6-2.
Example A-1. Using a Static SQL Cursor (page1of3)
/* ---------------------------------------------------------
Description: Using a Static SQL Cursor
Statements: Static DECLARE CURSOR
BEGIN WORK
OPEN
FETCH
Positioned UPDATE
CLOSE
COMMIT WORK
WHENEVER
GET DIAGNOSTICS
------------------------------------------------------------ */
#include <stdio.h>
#include <string.h>
EXEC SQL MODULE EXF61M NAMES ARE ISO88591;
int main()
{
char SQLSTATE_OK[6]="00000";
char SQLSTATE_NODATA[6]="02000";
EXEC SQL BEGIN DECLARE SECTION;
char SQLSTATE[6];
unsigned NUMERIC (4) hv_partnum; /* Parts table */
char hv_partdesc[19];
NUMERIC (8,2) hv_price;
NUMERIC (5) hv_qty_available;
unsigned NUMERIC (4) in_partnum; /* WHERE value */
long hv_num; /* Statement info */
long i; /* Used for condition loop */
char hv_sqlstate[6]; /* Condition info */
VARCHAR hv_tabname[129];
VARCHAR hv_colname[129];
VARCHAR hv_msgtxt[129];
EXEC SQL END DECLARE SECTION;
C