cancel
Showing results for 
Search instead for 
Did you mean: 

HANA - get particular field value from column stored in BLOB

yogananda
Product and Topic Expert
Product and Topic Expert
0 Kudos
367

I am looking for an HANA SQL statement to extract the field value and field is stored in BLOB

column stored will look like this

<c>
    <f n="HierarchyCode" b="" a="Equalization_Roll" />  ----------- Need this field value----
    <f n="FstDate" b="" a="20201106" />
    <f n="ContractNoUpline" b="" a="15764327256810001" />
    <f n="LstDate" b="" a="20201106" />
    <f n="DateEff" b="" a="20201106" />
    <f n="ProSta" b="" a="1" />
    <f n="FstUser" b="" a="PMADMIN" />
    <f n="FstTime" b="" a="15848020" />
    <f n="DateExp" b="" a="22000101" />
    <f n="VersNo" b="" a="1" />
    <f n="ContractNo" b="" a="15764318779050000" />
    <f n="Note" b="" a="This Only for Contract Hierarchy" />
    <f n="LstUser" b="" a="PMADMIN" />
    <f n="LstTime" b="" a="15848020" />
    <f n="ContractHierarchyNo" b="" a="16045991280200000" />
    <f n="HierarchyTypeNo" b="" a="15396600916750000" />
</c>
<br>
I need the first field value to be extracted with the result showing = Equalization_Roll

Accepted Solutions (0)

Answers (1)

Answers (1)

Kai_Mueller
Advisor
Advisor
0 Kudos

Hello,

you could use the XMLEXTRACT or XMLEXTRACTVALUE function of HANA.

Best regards, Kai