/* 嵌入SQL,连接到SAMPLE数据库,查询LASTNAME为JOHNSON的FIRSTNAME信息 */
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "util.h"
#include <sqlca.h>
EXEC SQL INCLUDE SQLCA;
int main()
{
EXEC SQL BEGIN DECLARE SECTION;
char firstname[13];
char userid[9];
char passwd[19];
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT TO sample;
EXEC SQL SELECT FIRSTNME INTO :firstname FROM employee WHERE LASTNAME = 'JOHNSON';
printf("First name = %s\n",firstname );
EXEC SQL CONNECT RESET;
return 0;
}