Hi,
I've tried the following script(in dbacess) on IDS 9.4 TC2 on two Windows 2000 machines, IDS server will be brought down (the same script works fine on IDS 9.21)
Could someone try it for me on your environment?
Thanks
Peng
--- Start of Informix testing scripts
CREATE FUNCTION sp_ChangeToUpper(a_name VARCHAR(255))
returning VARCHAR(255) with (not variant);
define upper_name CHAR(255);
Let upper_name = UPPER(a_name);
return upper_name;
END FUNCTION;
create table test(f1 integer,f2 char(40));
create unique index test_idx on test (f1,sp_ChangeToUpper(f2));
alter table test add (f3 smallint);
--- End of Informix testing scripts
I've tried the following script(in dbacess) on IDS 9.4 TC2 on two Windows 2000 machines, IDS server will be brought down (the same script works fine on IDS 9.21)
Could someone try it for me on your environment?
Thanks
Peng
--- Start of Informix testing scripts
CREATE FUNCTION sp_ChangeToUpper(a_name VARCHAR(255))
returning VARCHAR(255) with (not variant);
define upper_name CHAR(255);
Let upper_name = UPPER(a_name);
return upper_name;
END FUNCTION;
create table test(f1 integer,f2 char(40));
create unique index test_idx on test (f1,sp_ChangeToUpper(f2));
alter table test add (f3 smallint);
--- End of Informix testing scripts