Skip to Content
0

How to implement auto-increment in .hdbtable?

May 05, 2017 at 11:47 AM

157

avatar image
Former Member

My requirement is to get a dynamically generated column with auto-incremented values more like an index or GUID.

I searched through "IDENTITY"but, that is not supported by .hdbtable syntax.

Another way was to have another sequence added and then using id_seq.nextval to generate the values.

Even that does not seem to work.

Please, help me out with some solution or relevant document to see through.

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
May 05, 2017 at 04:45 PM
1

Hello Uday,

I don't think there's an easy way of doing that with hdbtable. Sequences would be my bet to alleviate that. However, you mentioned:

Another way was to have another sequence added and then using id_seq.nextval to generate the values.Even that does not seem to work.

Why that does not work?

Regards,

Lucas de Oliveira

Share
10 |10000 characters needed characters left characters exceeded