Skip to Content
avatar image
Former Member

Can I create the Historical function in Hana like copy_to_log?

Nov 21, 2016 at 02:47 PM | 30 Views

Hi Expert,

I need move my existing DB PostgreSQL to Hana can we create a function same as Post gress DB like Copy to log ?

SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Lars Breddemann
    Nov 23, 2016 at 08:43 AM

    Please describe what this function does.

  • Former Member Lars Breddemann
    Dec 05, 2016 at 01:15 PM

    Hi Lars ,

    I mean to say in Postgress DB we have some trigger so that sequence is updated the same table statement table after insertion of new record to statement table .

    But as I know in Hana we can't create Trigger which can update the same table after each Insertion . but some where in scn post it was mention we can create a procedure which is update the table and in the Trigger function we can call it ,

    But when I try to do the same it not allow me to do that .

    So can anybody suggest me what should be the best solution .

    Thanks,

    Sumit

  • Get RSS Feed

0 Answers