GBase8s数据库 PUT 语句

当准备 INSERT 语句时（请参阅 PREPARE 语句），您不可在它的 VALUES 子句中使用程序变

量，但可通过问号（

?）占位符表示值。请在 PUT 语句的 FROM 子句中罗列程序变量来提供缺少

的值。

下列 GBase 8s ESQL/C 示例罗列在 PUT 语句中的主变量：

char answer [1] = 'y';

EXEC SQL BEGIN DECLARE SECTION;

char ins_comp[80];

char u_company[20];

EXEC SQL END DECLARE SECTION;

main()

{

EXEC SQL connect to 'stores_demo';

EXEC SQL prepare ins_comp from

'insert into customer (customer_num, company) values (0, ?)';

EXEC SQL declare ins_curs cursor for ins_comp;

EXEC SQL open ins_curs;

 while (1)

{

printf("\nEnter a customer: ");

gets(u_company);

EXEC SQL put ins_curs from :u_company;

printf("Enter another customer (y/n) ? ");

if (answer = getch() != 'y')

break;

}

EXEC SQL close ins_curs;

EXEC SQL disconnect all;

}