Hi Cetin

>Bhavbhuti,
>Running gendbc get programmatic version of creating your view (and any connection you might need for it).
>
>Then edit the SQL and other properties that might need change, drop view lcViewName, recreate running the edited code.

Thanks for the suggestion.