>>Firstly, you need to assess why you are doing this (there are some valid reasons, but this is not the normal way). Generally, it is enough to define a few parameterized views and just let them live happily and permanently in a server dbc. Parameterized views, if defined correctly, usually give enough flexibility to allow your app to run without creating any custom ones.

Secondly, if you decide that temporary views IS the way to go, you need to be creating those in a temporary DBC on each users own hard drive, so you don't run into naming conflicts, etc.

The reason to have is we are creating more than 50 views.

We are saving it in the server and using sys() function getting a unique name for dbc. Is that the right way?