Skip to Content
avatar image
Former Member

How can I see the native or generated SQL that runs on the database?

When I get errors in Universe Designer, since the error does not say on what line the error is, and you can use things like @DerivedTable that need to be resolved before running on the database, I would like to see the actual SQL that is generated and then run that on SQL Developer. That way I can take that code and paste it into SQL Developer and see more clearly what is happening. A colleague pointed out that SQL Developer can show you the SQL that is being run on the database via menu option Tools -> Monitor SQL, but it requires version 11 to run and apparently they don't have that installed. I have seen some discussions online referring to generated SQL so I assume it is possible to see it, but how? Also, can it be done with a different database backend? I also read from Teradata.

Thanks.

Pedro

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 02, 2012 at 03:49 PM

    Hello Pedro,

    For Sql server  You can find the sql that is running on database from business objects from Sqlserver management studio->Tools->sql profiler.

    Thanks ,

    Pramod.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      If you want to check how  the sql is generating in universe designer You will get the sql from universe Designer->Tools->query Panel->drag the related object and click Sql . Then you will get the Sql . Parse there only or copy & and run it on your database.

      Thanks,

      Pramod