Skip to Content
2
May 17, 2020 at 12:02 AM

Executing a FROM DUMMY in a CAP Application

895 Views

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