偶然使用db2,编译时遇到问题经过测试,解决后记到这里备查。
一、代码:test_db2.SQC【
[code]
/************************************************************
函数名称:
功能说明: 输入参数:
输出参数:
返 值:
0: 成功
-1: 失败
************************************************************/
EXEC SQL INCLUDE SQLCA;
int main(int argc, char **argv)
{
int iRet=0;
EXEC SQL BEGIN DECLARE SECTION;
char Uname[8+1]="test";
char Pwd[8+1]="test";
long TotCnt = 0;
char MsgIdNo[35+1];
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT to EEPS USER :Uname USING :Pwd;
memset( MsgIdNo, 0x00, sizeof(MsgIdNo) );
EXEC SQL SELECT count(*) INTO :TotCnt FROM ChkTotRcv;
if( SQLCODE ) {
printf( "SQLCODE=[%d]/n",SQLCODE );
return(SQLCODE);
}
else {