Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using table functions in Query
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. -
Using table functions in Query
--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... -
Using table functions in Query
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...
