cat > script.cc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
#include	<mscc.h>
#include	<stdlib.h>
void	error	(int	i);
EXEC SQL INCLUDE SQLCA;
EXEC SQL BEGIN DECLARE SECTION ;
struct str{
	char	name[25];
	char	date[21];
	char	amount[9];
};
struct str strx;
struct str *strp;
EXEC SQL END DECLARE SECTION ;
int	main (int argc, char** argv)
{
EXEC SQL INIT;
EXEC SQL DATABASE IS "TEST_DATABASE";
strp = (struct str *) malloc(sizeof(struct str));
EXEC SQL SELECT name,date,amount FROM loans 
	INTO :strp->name,:strp->date,:strp->amount 
	WHERE name = "Kilroy";
if(SQLCODE != 0) error(0);
printf("%-26s %21s %10s \n",strp->name,strp->date,strp->amount);

EXEC SQL SELECT name,date,amount FROM loans 
	INTO :strx.name,:strx.date,:strx.amount
	WHERE name = "Peterson";
if(SQLCODE != 0) error(0);
printf("%-26s %21s %10s \n",strx.name,strx.date,strx.amount);

EXEC SQL EXIT ;
	return 0;
}
void	error (int	i)
{
	printf("error number %d\n",i);
	printf("SQLCODE number %ld\n",SQLCODE);
	exit(1);
}
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script.cc
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Kilroy                         16 February  1981    $250.00 
Peterson                        6 June      1981     $50.00 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
use of struct
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
