#include <stdio.h>

int main(int argc, char *argv[])
{

	EXEC SQL BEGIN DECLARE SECTION;
		char *target = "bob@snode5";
		char *user = "philip";
		char *message = "It came from embedded C - again!";
		char *pquery = "INSERT INTO test (message) VALUES(?)";
		
	EXEC SQL END DECLARE SECTION;

	if(argv[1] != NULL)
		message = argv[1];

	EXEC SQL WHENEVER sqlerror sqlprint;

	EXEC SQL CONNECT TO :target USER :user;
	/*EXEC SQL SET AUTOCOMMIT TO ON; */

	EXEC SQL PREPARE stmt_id FROM :pquery;
	EXEC SQL EXECUTE stmt_id USING :message;
	EXEC SQL COMMIT;
	EXEC SQL FREE stmt_id;	
	EXEC SQL DISCONNECT ALL;

}