int _tmain(int argc, _TCHAR* argv[])
{
	exec sql include sqlca;
	exec sql begin declare section;
		int   officenum;
		char  cityname[ 16 ];
		char  regionname[ 11 ];
		float tergetval;
		float salesval;
	exec sql end declare section;

	exec sql whenever sqlerror goto query_error;
	exec sql whenever not found goto bad_number;

	printf("Введите инентификатор офиса: ");
	scanf("%d", &officenum);

	exec sql select city, region, target, sales
			   from offices
		     where office = :officenum
			   into :cityname, :regionname:, :targetval, :salesval;
 
	printf("Город:  %s\n", cityname);
	printf("Регион:  %s\n", regionname);
	printf("План:  %s\n", targetval);
	printf("Продажи:  %s\n", salesval);
	exit( 0 );

	query_error:
		printf("Ошибка SQL:  %ld\n", sqlca.sqlcode);
		exit( 1 );
	bad_number:
		printf("Неправильный идентификатор офиса.\n");
		exit( 1 );
}