How to read CSV data from a CLOB column in HANA DB using SQL script?

[former_member189561]

Hi, Anybody knows how to do these listed below?

1. How to read CSV data from a CLOB column in HANA DB using SQL script?

2. How to convert a table data into CSV format and save it into a CLOB column using SQL script?

Thanks and regards,

Yuxin

[lbreddemann]

That's not efficiently doable in SQL Script.

You would have to loop over the content of the CLOB column and find the delimiters and then dynamically create a target structure for this.

The question would anyhow be: why do you want to do that in the first place?

You seem to have structured data and want to store it into a "dumb" container.

Why?

That's building a low level structure onto a high-level API (SQL tables).