on 09-22-2014 11:10 AM
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
Insert into TABLE ( Select * from View )
Regards,
Krishna Tangudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.