Thanks a lot!! Frederico
The database is dash db (DB2 database hosted in IBM Cloud).
DB2 version is DB2 v11.5.4.0.
I am not sure which OS the DB2 is hosted.
--Here is the DDL
CREATE OR REPLACE
FUNCTION OPT1VHZM_DRILLS.fn_parse_string_del(text VARCHAR(1000) ) RETURNS TABLE
( "ENTITY" VARCHAR(10) )
--LANGUAGE SQL
NO EXTERNAL ACTION
LANGUAGE SQL
READS SQL DATA NOT DETERMINISTIC
--DISALLOW PARALLEL
--CARDINALITY 10
--BEGIN ATOMIC
RETURN...
The table function fn_parse_string_del parses a comma separated string.
Ex: The string 'TH663,TH550,TH445' is parsed as rows
TH663
TH550
TH445
I have used the table function fn_parse_string_del in my query below and it is taking more time say about 7 secs but the query with IN operator...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.