IBM INFORMIX 4G / 5724C6680 / 750 - Informix 7.50

The substring operator "[]" does not work when used in a WHERE
clause.

For example, you have a table defined as:

create table t1(
  c1 char(6),
  c2 char(6)
);


You have a 4GL program:

]$ cat sub.4gl
DEFINE r_c1 char(7),
            r_c2 char(7)

MAIN

DATABASE test

LET r_c1 = "Testing"
LET r_c2 = "Testing"

INSERT INTO t1(c1, c2) VALUES (r_c1[1,4], r_c2)

END MAIN


When the program above is run, the following values are inserted
into the table:

c1        c2

Testing Testing

not known / see Local fix

Product is working as designed.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.09.2018
17.05.2019
17.05.2019