title: how to retrieve JSON data stored in CLOB Datatype in DB2?
body: <p>I have JSON data stored in CLOB in DB2 database. I want to query this JSON data and retrieve some data . </p>
  
  <p>I tried with <code>JSON_VAL</code> and get this error</p>
  
  <blockquote>
    <p>DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=JSON_VAL.</p>
  </blockquote>
  
  <p>can anyone please let me know if I can use JSON_VAL if not right one with an example helps.</p>