Skip to Content
avatar image
Former Member

How to implement auto-increment in .hdbtable?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded