如何将raw(18)列重写为informix [英] How to rewrite column raw(18) to informix
问题描述
在我的应用程序中,我有oracle列:
in my application I have oracle column:
COLUMN_NAME RAW(18)不为空
COLUMN_NAME RAW(18) not null
我应该如何将其重写为notifyix?我发现类似的类型是字节,但是我还需要在此列上创建索引,这是不允许在字节上创建的(在oracle上可能是原始格式)
How should I rewrite it to informix ? I found that similar type is byte but I need also create index on this column which is not allowed on byte (in oracle on raw it is possible)
推荐答案
我想您是否正在使用Informix的12.10版本.
这有点奇怪,因为在11.70版中,我无需注册datablade就可以使用相同的命令.
I'm supposing are you working with version 12.10 of Informix.
This is little weird since at version 11.70 I'm able to use this same command without need to register the datablade.
无论如何,请尝试以下方法:
Anyway, try this :
execute function SYSBldPrepare('binaryudt.*','create');
(expression)
0
1 row(s) retrieved.
CREATE TABLE bindata_test (int_col integer, bin_col binaryvar) ;
Table created.
在onstat -m
(或select * from sysmaster:sysonlinelog order by offset desc
),您应该会看到类似这样的消息:
At the onstat -m
(or select * from sysmaster:sysonlinelog order by offset desc
) you should see a message like this :
11:56:57 Unloading Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld>
11:56:57 The C Language Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld> unloaded
这篇关于如何将raw(18)列重写为informix的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!