Dear, I have a requirement that can be easily solved by using a SEQUENCE on HANA Database. There is any way to execute a SELECT seq.NEXTVAL FROM DUMMY?
I have tried to create a hdbview with the select that get sequence value and reuse it with @cds.persistence.exists, but the name DUMMY generate the following error:
Error: The file requires "db://DUMMY" which is not provided by any file. I have tried to put DUMMY as Synonym, but it isn't possible.
I have tried to set the attribute on my CDS file with "generated default as identity" but it isn't supported on CAP.
Do you have some tips about it?
Bests