Skip to Content
author's profile photo Former Member
Former Member

Underlying SQL or SQL Script for Calculated Views Create Graphically

Hello,

Is it possible to view the SQL or SQL script generated for calculated views that are created graphically?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Mar 02, 2012 at 04:17 AM

    Hi Mike,

    There is one place where you can see the generated script for Graphical Calc Views,but this will be little complex to understand as it has lot of internal details about the View

    Go to SYSBIC->Column Views->Look for your Calc View(it will be in the form of <Package/View Name>)->Right click "Open Definition"->Go to "Create Statement" Tab

    Rgds,

    Murali

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 02, 2012 at 04:21 AM

    Hi Mike,

    For your calculation view you will find the corresponding column view created in schema '_SYS_BIC'-->Column Tables->

    <packagename>/<Calculation view> --> Open Definition of this and check the 'create statement'.

    Note: This is a information modeler generated SQL script which will show the generated Calculation Scenario and the respective Column View.

    Regards, Rahul

    Seems the answer was already given by Murali while I typed 😊

    Edited by: Rahul Pant on Mar 2, 2012 5:22 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 02, 2012 at 01:45 PM

    Hi,

    Thanks for responding but the "Create Statement" tab is blank for the SYSBIC column view.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.