cancel
Showing results for 
Search instead for 
Did you mean: 

how to consume view data (temporary data) as a permanent data ?

Former Member
0 Kudos

Hi,

Views are not holding any data.

How to consume view data as a permantent data into a hana table...

Manual query execution will be in Sql console or by calling a stored procedure

SELECT * FROM "_SYS_BIC"."PACKAGE/VIEW_NAME" INTO TABLE_NAME_XXXX;

because each time new data will append for a tables, & those data will be used for the views.

so the resultant view data should be stored in a table(permantely).

how to build dynamically this..

please can any one suggest how to reslove this issue..

Thanks,

Thara

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

Insert into TABLE ( Select * from View )

Regards,

Krishna Tangudu         

Former Member
0 Kudos

Hi,

Th..x for ur response...

but the above syntax is not dynamic we should write it manually and execute...

If we create the table manually,having   composite p.k...

first time it inserts all data... from the view..

but the second time new data or updated data may exists for that view, in this scenario,

Left outer join condition will arise,

such that which are all existing data.... it should update with new data, if not existing it should insert new data..

then only the table will hold current view data..

because as we know any insert/update/delete will effect in view first..

but the table is already holding old data..

for 2nd or 3rd time execution it may fails..

or else every time i need to delete records then execute above syntax...

again it will became manual operation...

please suggest how to execute dynamically...

let me know if any more information is required to resolve this..

Thanks,

Thara

former_member182302
Active Contributor
0 Kudos

You can use UPSERT

And regarding dynamic, You want to frame a generic procedure to load ?

May be something like this

Regards,

Krishna Tangudu

Former Member
0 Kudos

Hi,

If we use Generic Procedure, every time it deletes records from the table and inserts new records?

after executing that procedure, we need to call the procedure in sql console manually..

is it possible to set the time such that @ specific time stored procedure will execute automatically..

so that it will became dynamic operation..

Thanks,

Thara.

former_member182302
Active Contributor
0 Kudos

Then you got to use XS Job scheduler or anyother scheduling tools like BODS or job schedulers.

Regards,

Krishna Tangudu

Former Member
0 Kudos

Hi,

Is it possible to use above methods in Developer version.

We are using Developer version - Rev80

Thanks,

Thara

former_member182302
Active Contributor
0 Kudos

Should be possible:

Job Scheduling | SAP HANA

Regards,

Krishna Tangudu

Former Member
0 Kudos

Thank you for providing the link.

Regards,

Thara