Skip to Content
0

Can I create the Historical function in Hana like copy_to_log?

Nov 21, 2016 at 02:47 PM

29

avatar image
Former Member

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 ?

10 |10000 characters needed characters left characters exceeded

Please describe what this function does.

0
Former Member
Lars Breddemann

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

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers