Skip to Content
avatar image
Former Member

How to implement auto-increment in .hdbtable?

May 05, 2017 at 11:47 AM | 240 Views

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

SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Lucas Oliveira
    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