db2 嵌入式sql开发,遇到以下问题,请高手帮忙分析看看问题在哪
数据库设置如下:/home/cpcs/CPCS/src/dbutil>db2 list db directory
System Database Directory
Number of entries in the directory = 1
Database 1 entry:
Database alias = COMM
Database name = COMM
Node name = COMMDB
Database release level = a.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
/home/cpcs/CPCS/src/dbutil>db2 list node directory
Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = COMMDB
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 131.252.95.89
Service name = 60000
//命令行db2 connect to comm可以正确连接数据库
测试代码:
/******************************************************************************
**
** Source File Name = static.sqc1.4
**
** Licensed Materials - Property of IBM
**
*******************************************************************************/
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
EXEC SQL INCLUDE SQLCA;
int main(int argc, char *argv[]) {
EXEC SQL BEGIN DECLARE SECTION;
long lCount;
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT TO comm USER db2inst1 USING db2inst1;
if (sqlca.sqlcode != 0) {
printf("connect failed:%d\n", sqlca.sqlcode);
}
EXEC SQL select count(*) into :lCount
from comm.T_MER_INST_CONFIG;
if (sqlca.sqlcode != 0) {
printf("select failed:%d\n", sqlca.sqlcode);
}
return 0;
}
运行结果:
connect failed:-5055
select failed:-1024
sqc的你参考下samples目录下的C目录下的sqc的做法!
sqc的要先bind一下,检查一下吧!
页:
[1]