title: AS400 iSeries DB2: break lines at new line character for SQL output for JSON_OBJECT
body: <p>I am writing the below mentioned query in the interactive session of sql in AS/400 (STRSQL)</p>
  
  <pre><code>SELECT 
  CAST(
  json_object ('Product_id' value PROID,'Product_name' value PRONAME)as 
  VARCHAR(100))
  from Product
  </code></pre>
  
  <p>The output that I am getting looks something like this</p>
  
  <pre><code>{"Product_id":"PRD001","Product_name":"Dairy"}
  </code></pre>
  
  <p>The output for JSON object is a CLOB data, so I have typecasted it to VARCHAR.
  If I am not wrong, there are new line characters (\n) and tabs (\t) in the output, but they are not getting displayed. I need the output with the new line characters and tabs.</p>
  
  <p>The output should be something like:</p>
  
  <pre><code>{
   "Product_id":"PRD001",
   "Product_name":"Dairy"
  }
  </code></pre>