gzip blob support in HANA

[mayurbelur_mohan]

Hi,

i want to store gzip file as blob in table column, is there any way I can unzip/extract the file inside it using stored procedures or SQL Scripts. or any support for compress and decompress data with SQL as supported by Oracle Utl_compress, gzip and zlib - AMIS Technology Blog.

Regards,

mayur

[lbreddemann]

Although there is no actual support for GZIP de-/compression in Oracle (the referred blog post demonstrates how this could be custom build), there is nothing in SAP HANA that resembles the UTL_* packages in Oracle.

Therefore: the only option to approach something like this as of today (SP8) would be by using XSEngine and JavaScript.

- Lars

[thomas_jung]

I agree and would add that we will introduce a GZIP API into XSJS in SPS09. It will be

$.util. Zip.