Sequence -SAP HANA

[venkatesh_veera2]

Hi All,

I'm totally new to SAP HANA.

can some one please explain me the below code.

as per my understanding sequence is user to generate unique id's.

what are NEXTVAL and CURRVAL?

what id " select seq.nextval from dummy??" and select seq.currval from dummy??

what is dummy in the above code??

it would be very helpful for me if some one explains me the above code in details.

P.S. sorry if it comes under some basic concept

Kind Regards,

Venkatesh

[SergioG_TX · Accepted solution]

Venkatesh,

dummy is the table that you may use to select anything from the HANA db.. like duel in Oracle ..

once you have created a sequence you need to specify a start integer.

then your nextVal would be your incremented value

and your currVal is the current value at the sequence

hope this helps

[former_member182302]

CREATE SEQUENCE - SAP HANA SQL and System Views Reference - SAP Library

Regards,

Krishna Tangudu