Embedded SQL

EXEC SQL INCLUDE file;

EXEC SQL INCLUDE my_file.h;

EXEC SQL INCLUDE MY_FILE.h;

EXEC SQL INCLUDE file.h;

#include <file.h>

EXEC SQL BEGIN DECLARE SECTION;

EXEC SQL END DECLARE SECTION;

EXEC SQL BEGIN DECLARE SECTION;
int fooBar;
char dooDad[16];
EXEC SQL END DECLARE SECTION;

VARCHAR name[len];

VARCHAR foo[100];

VARCHAR foo[100];

struct varchar_foo{
   int len;
   char arr[100];
} foo;

EXEC SQL BEGIN DECLARE SECTION;
char *con = "db@machine";
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT TO :con as conname;

EXEC SQL CONNECT TO connection_target;
   [AS connection_name]
   [USER username]
   [USING password];

EXEC SQL DISCONNECT connection_target

EXEC SQL INCLUDE sqlca;

struct sqlca
{
   char         sqlcaid[8];
   long         sqlabc;
   long         sqlcode;
   struct
   {
      int          sqlerrml;
      char         sqlerrmc[SQLERRMC_LEN];
   } sqlerrm;
   char         sqlerrp[8];
   long         sqlerrd[6];

   /* Element 0: empty
    * 1: OID of processed tuple if applicable
    * 2: number of rows processed	after an INSERT,
    * UPDATE or DELETE statement
    * 3: empty
    * 4: empty
    * 5: empty
    */
   char         sqlwarn[8];

   /* Element 0: set to 'W' if at least one other is 'W'
    * 1: if 'W' then at least one character string
    * value was truncated when it was
    * stored into a host variable.
    * 2: if 'W' then a (hopefully) non-fatal notice occurred
    * 3: empty
    * 4: empty
    * 5: empty
    * 6: empty
    * 7: empty
    */
   char         sqlext[8];
};

EXEC SQL WHENEVER condition action;

EXEC SQL WHENEVER SQLERROR GOTO error;
/* ... program code ...*/
error:
   fprintf(stderr, "an error occurred\n");

CREATE TABLE emp (id INTEGER, name TEXT);

#include <stdio.h>

/* include SQL Communication Area code */
EXEC SQL INCLUDE sqlca;

/* shared variables */
EXEC SQL BEGIN DECLARE SECTION;
int id;
char *name = "fred";
char *db = "user@box";
EXEC SQL END DECLARE SECTION;

/* print all fatal errors */
EXEC SQL WHENEVER SQLERROR SQLPRINT;
EXEC SQL WHENEVER NOT FOUND DO print_not_found();

void print_not_found()
{
	printf("No results were returned.\n");
}

int main()
{
/* open a database connection */
EXEC SQL CONNECT TO :db AS conn;
if (!ECPGstatus(__LINE__, "conn"))
{
	fprintf(stderr, "Unable to connect to database.\n");
	return(1);
}

/* execute query */
EXEC SQL SELECT id INTO :id FROM emp WHERE name = :name;

	if (sqlca.sqlcode == 0)
		printf("ID of %s: %d\n", name, id);

/* disconnect */
EXEC SQL DISCONNECT conn;

	return(0);
}