前台:
INFORMIXSERVER=hpuxon94
HP-UX 11
IBM Informix Dynamic Server Version 9.40.FC6
INFORMIX-SQL Version 6.05.UD2
INFORMIX-4GL Version 6.05.UD2
后台:
INFORMIXSERVER=scoon73
SCO openserver 507
Informix Dynamic Server Version 7.31.UC5
INFORMIX-SQL Version 7.20.UD7
INFORMIX-4GL Version 7.20.UD7
在前台服务器上,缺省SERVER为scoon73,前、后台均有名为db的数据库
$ cat test.4gl
database db
define p_i_code like insu_info.i_code
define p_i_name like db@hpuxon94:insu_info.i_name
$ cat test1.4gl
database db@online3213
define p_i_code like insu_info.i_code
define p_i_name like db@hpuxon94:insu_info.i_name
test.4gl编译出错
test1.4gl编译正常
isql执行类似语句正常
$ cat test.err
database db
define p_i_code like insu_info.i_code
define p_i_name like db@hpuxon94:insu_info.i_name
|
| The symbol "i_name" is not the name of a column in the
| specified database.
| See error number -4322.
如果将前台改为下列环镜,编译test.4gl或用isql执行类似语句均会死等(前台informix也可能会崩)
SCO openserver 505
Informix Dynamic Server Version 7.30.UC2
INFORMIX-SQL Version 6.05.UD2
INFORMIX-4GL Version 6.05.UD2