subscripts in stored procedures.
Does anybody know how to use a variable to subscript a character string in
Informix 5.03 stored procedures? I have had no success, as shown in the
following simple example. Any suggestions would be appreciated.
dsl@one.net
-------------------------------------------------
create procedure subscript_test()
define lv_string char(4) default "ABCD";
define lv_ctr smallint;
define lv_char char(1);
let lv_ctr = 2;
let lv_char = lv_string[lv_ctr];
# ^
# 201: A syntax error has occurred.
#
end procedure;
--------------------------------------------------