on 2020 Nov 05 8:51 PM
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
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
45 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.