cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Studio, Save and Activate a View via SQL console

Former Member
0 Kudos

Hi Guys,

is it possible to

1. save and activate OR

2. redeploy a view

via sql console?

Thanks in advance

Sebastian

Accepted Solutions (1)

Accepted Solutions (1)

former_member208449
Active Participant
0 Kudos

Hello Sebastian

SQL Console is used to execute statements and preview the results. Save and activate, Redeployment are done at the view level. May I know why do you want to achieve these functionalities via SQL Console.

Former Member
0 Kudos

Hello Gowthami,

there is a phenomenon that sometimes views are invalidated by an unknown issue.Then, it's possible to identify those views via SQL. Based on that analysis, I would like to redeploy or reactivate them. Therefore i need a command to do that within the SQL console. The goal is to use a script for identification and activation at ones.

Otherwise you are right, i can use the graphical interface but there i need to select every view by its own and activate it afterwards.It would be nice to shorten that process by the explained idea above.

Best regards

Sebastian

chandan_praharaj
Contributor
0 Kudos

Sebastian,

there is no such way to activate from SQL console, as version management of file is not done through SQL console. You can check _SYS_REPO.ACTIVE_OBJECTS or _SYS_REPO.INACTIVE_OBJECTS tables for activae and inactivated object and activate them manually. Below two thread will give you details, related to this topic, which is already discussed.

Table for inactive information views? | SCN

Former Member
0 Kudos

Hi Chandan,

thanks for your feedback, I already got the list of inactive objects. What a pity, that the view activation doesn't work via SQL commands.

Have a nice day all,

Best Regards

Sebastian

Answers (0)