Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-167

First Steps with EXAplus

    XMLWordPrintable

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: EXASolution 5.0
    • Fix Version/s: None
    • Component/s: EXAplus
    • Labels:
    • Solution:
      Hide

      Preconditions

      Please download EXAplus from our download section and install it on your computer.

      The EXAplus Window


      The EXAplus window contains a toolbar and three areas:

      1. Information
        • Use the Database Browser to get information about the objects in your database instance.
        • In the History you find the so far executed statements of this EXAplus instance.
        • You can create Favorites for frequently needed statements and define your own short-cuts to execute these.
        • Use Templates if you are not sure about the precise syntax of a command.
      2. Editors
        • Several SQL Editor-tabs for your statements.
      3. Output
        • The progress of your EXAplus session is stored in the Log.
        • Additionally you find the Result sets of your queries here.

      Connections

      • EXAplus supports one database connection per EXAplus window.
      • You can create a Custom Connection to connect to a database instance spontaneously. You need the connetion-string (e.g. 192.168.1.11..15:8563), a user name and the password.
      • Optionally you can organize your connections in Connection Profiles to make them easy accessible. Please open the EXAplus menu therefore.

      Useful Short-Cuts

      Shortcut Action
      Ctrl-O Open a file
      Ctrl-S Save the current editor tab to a file
      Ctrl-T Open a new editor tab
      Ctrl-Enter Execute selected/focused statement
      Ctrl-Shift-Enter Execute all statements of an editor tab
      Ctrl-Shift-F Auto format selected/focused statement
      Ctrl-K Stop the current statement execution
      Ctrl-E Export result of focused query to a local CSV file
      Ctrl-N Open a new EXAplus window to work for with a second database connection

      Settings in the Window-Footer

      • Choose a schema to set the scope of your statements.
      • Define the auto-commit mode:
        • ON: commit after each statement.
        • OFF: manual transaction management with the commands COMMIT and ROLLBACK.
        • EXIT: do a commit when the connection will be closed.
      • Specify if you want to keep result sets or if you want to replace them with every execution.
      • Set the maximum number of records that will be fetched and displayed.

      See the EXASolution manual for a detailed description of all EXAplus options and the command-line version of EXAplus.

      Show
      Preconditions Please download EXAplus from our download section and install it on your computer. The EXAplus Window The EXAplus window contains a toolbar and three areas: Information Use the Database Browser to get information about the objects in your database instance. In the History you find the so far executed statements of this EXAplus instance. You can create Favorites for frequently needed statements and define your own short-cuts to execute these. Use Templates if you are not sure about the precise syntax of a command. Editors Several SQL Editor -tabs for your statements. Output The progress of your EXAplus session is stored in the Log . Additionally you find the Result sets of your queries here. Connections EXAplus supports one database connection per EXAplus window. You can create a Custom Connection to connect to a database instance spontaneously. You need the connetion-string (e.g. 192.168.1.11..15:8563), a user name and the password. Optionally you can organize your connections in Connection Profiles to make them easy accessible. Please open the EXAplus menu therefore. Useful Short-Cuts Shortcut Action Ctrl-O Open a file Ctrl-S Save the current editor tab to a file Ctrl-T Open a new editor tab Ctrl-Enter Execute selected/focused statement Ctrl-Shift-Enter Execute all statements of an editor tab Ctrl-Shift-F Auto format selected/focused statement Ctrl-K Stop the current statement execution Ctrl-E Export result of focused query to a local CSV file Ctrl-N Open a new EXAplus window to work for with a second database connection Settings in the Window-Footer Choose a schema to set the scope of your statements. Define the auto-commit mode : ON: commit after each statement. OFF: manual transaction management with the commands COMMIT and ROLLBACK. EXIT: do a commit when the connection will be closed. Specify if you want to keep result sets or if you want to replace them with every execution. Set the maximum number of records that will be fetched and displayed. See the EXASolution manual for a detailed description of all EXAplus options and the command-line version of EXAplus.
    • Category 1:
      Clients, Interfaces & Drivers - EXAplus

      Attachments

        Issue Links

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: