请建议如何解决这个问题,我在linux上使用informix,它在共享内存创建中出现致命错误。
su - informix
-sh-2.05亿美元-v
ONCONFIG /usr/informix/etc/onconfig.active is not owned by user with id 4000.
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig.active'
这是Linux上的Informix11.70.FC6GE。
假设表mytable包含列value varchar(16),函数如下:
create function myfunc(str varchar(16)) returning varchar(16)
define result varchar(16);
while (<some-condition>)
let result = ...;
return result with resume;
end while;
end function;
当我这样做的时候
select * from myta
我正在对一个IBM Informix数据库运行以下查询,并获得一个ERROR 42000: A syntax error has occurred。FROM和WHERE子句在其他查询中运行得很好,所以我看一下SELECT和GROUP BY部分。你知道语法有什么问题吗?
SELECT COUNT(DISTINCT "informix".agentconnectiondetail.sessionid) AS calls_abandoned,
DAY("informix".agentconnectiondetail.startdatetime) AS Expr2
有谁能帮我提高以下sql的性能吗?使用is informix的数据库
SELECT
informix.set_reason_codes.description as reason_code,
count(*) as number_of_calls
FROM
informix.contact_history,
informix.set_reason_codes,
informix.customers
WHERE
(informix.contact_history.reason_code = informix.set_reason_codes.reason_code)
an
为尝试了这段代码。来自
我一直在得到这个错误,.Is,有什么解决办法吗??
16:03:57.054 [main] DEBUG com.informix.stream.cdc.IfxCDCEngine - Closing down CDC engine
Exception in thread "main" java.sql.SQLException: Routine (cdc_opensess) can not be resolved.
at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.
我试图使用JDBC查询将blob插入到informix数据库中的表中。但是,我得到了这个错误:
java.sql.SQLException: Smart-large-object error.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3494)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3807)
at com.informix.jdbc.IfxSqli.dispatc
我刚刚更新了我的应用程序上的informix驱动程序(从3.0更新到V4.10.JC4DE),在试图连接informix 9时发生了以下错误。
java.sql.SQLException: Routine (get_data_type) can not be resolved.
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3130)
at com.informix.jdbc.IfxSqli.D(IfxSqli.java:3412)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli
在我的Informix表中,有两个索引在三个表中只有一个不同的列。以下是索引:
CREATE INDEX informix.ix_1
ON informix.test(date, operator, rn)
CREATE INDEX informix.ix_2
ON informix.test(choice, date, operator)
date is from type Date
operator is Char(3)
choice is Integer
rn is Integer
将这些索引组合为一个并以这样的方式删除它们是否明智:
CREATE INDEX inf