clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335853 fiddles created (27447 in the last week).

SELECT JSON_OBJECT(KEY 'x' VALUE 1) FROM sysibmadm.env_inst_info
1
 hidden batch(es)


SELECT JSON_OBJECT(KEY 'x' VALUE (SELECT 1 AS myscalar FROM sysibmadm.env_inst_info)) FROM sysibmadm.env_inst_info
[IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token ")" was found following "bmadm.env_inst_info)". Expected tokens may include: "<interval_qualifier>". SQLSTATE=42601 SQLCODE=-104
 hidden batch(es)


SELECT JSON_OBJECT(KEY 'x' VALUE myscalar) FROM sysibmadm.env_inst_info, LATERAL (SELECT 1 AS myscalar FROM sysibmadm.env_inst_info)
1
 hidden batch(es)