Hi Has any body done PLSQL to parse UData info?
I know I have in the past but I cannot find them,
If you have some it would be greatly apraciated…
regard,
E
It depends on UData format,but I do not think that anybody from this forum want write SQL code for your proposal and for you. So,try to put a little bit effort
1 Like
Kubig, the posting asked if somebody has code, not if somebody could write, so put a little effort to read the question before posting.
1 Like
Ok,in this way I would say “yes”
hahahaha, yes, me too.
Now edobellamy put an little effort on your side and do it too
Why reinvent the wheel ???
1 Like
Reinvent wheel?! The SQL script which is formating the User datas it’s not possible to write in general form,because each environment and related UserData is in different format. Such a script would be so unreasonably robust and in most cases completely useless - logical.
The code only needs to to extract the keys and the values from a string, or the value for a key, or return nothing if nothing.
very simple, and I done it before many times. Even from blobs and clobs, No biggie. Only I don’t know what I did with my kv sps.
Thanks anyway. 
You are not right. How would you write general SQL script for KVP pairing,if you did not write from which source/database? KVPs can be stored in a lot of format type and in lot of source (database,WS,file,etc.) . Each point can change dependencies and format of final SQL script.
1 Like
You can get inspired in EVDATA from Call Concentrator, check the BLOB form UCS, cheers
I do not want inspiration,I do not need anything,you need it I know,how to format KVP for my customers and needs. I’m done with this pointless debate that leads nowhere.
1 Like