+ New Ticket

Keep view original format

Comments

3 comments

  • Official comment
    Avatar
    Aleksander Vinokur

    Hello Laurene,

    Aginity Workbench for Netezza does not keep sql anywhere unless you save it in a separate file.

    Meanwhile, you may get DDL of a view object selecting view in the Object Browser and using main menu Object - View - Script - DDL to query window.

     

    Regards,

    Alexander Vinokur

    Comment actions Permalink
  • Avatar
    Laurene

    Thanks for the answer. Unfortunately, that confirm what I think...


    Keep the original sql in aginity could be a very good new feature for the future if it is possible!

    0
    Comment actions Permalink
  • Avatar
    Michael Shreeve

    If you created the view recently on your machine, you can look at your User Query History, and it will be stored there in its original format.  The amount of history kept is kept under Tools - Options - Query Analyzer.  I believe it defaults to the last 1000 queries.

    --Michael

    0
    Comment actions Permalink

Please sign in to leave a comment.