Db2 12.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select service_level from sysibmadm.env_inst_info;

SERVICE_LEVEL

DB2 v12.1.5.0

1 rows selected

-- the VECTOR type arrived in Db2 12.1
create table emb (id int, e vector(3, float32));
insert into emb values (1, cast('[1,0,0]' as vector(3, float32)))
                     , (2, cast('[0,1,0]' as vector(3, float32)));

statement completed

select id
     , vector_distance(e, cast('[1,0,0]' as vector(3, float32)), cosine)
       as cosine_distance
from emb order by id;

ID
COSINE_DISTANCE

0 rows selected

-- json_arrayagg() is also new in 12.1
select json_arrayagg(id) as ids from emb;

IDS

[]

1 rows selected