intra-mart Accel Platform / System Administrator Guide

«  File Operation   ::   Contents   ::   Portlet management  »

Database Operation

This is a simple tool to execute SQL statements directly on the database.
There are two methods of execution. In the first method, the SQL statement is written in the text area and “Execute SQL” button is pressed. In the other method, SQL statement is defined in a file, that file is imported and the statement is executed.

Executing SQL

  1. Click ” System Manager ” → “Database operation”.

  2. “Database operation” screen is displayed.

    ../../_images/apply_guide_7_1.png
    • Database connection

      Selected from registered “Shared database” or “Tenant database”.

  3. Click “Execute”.

    ../../_images/apply_guide_7_2.png

  4. SQL is executed.

    ../../_images/apply_guide_7_3.png

Note

Refer “System management” - “Shared database settings” for the shared database settings.

Note

Referring the execution history
The last 10 executed SQL statements are stored in the execution history and on selecting the date from the combo box, the respective SQL is displayed.

Executing SQL by importing SQL file

  1. Click ” System Manager ” → “Database operation”.

  2. Click “Import SQL file”.

    ../../_images/apply_guide_7_4.png

  3. “Database operation” screen will be displayed.

    ../../_images/apply_guide_7_9.png
    • Connection destination

      Selected from registered “Shared database” or “Tenant database”.

    • SQL file

      Click on “Select file” and then select the file from “File selection dialog” screen.

    • Transaction unit
      • SQL statement
        Set SQL statement for each transaction.
        Every time the SQL statement is executed, commit and rollback can be carried out.
        Even if there is an error during the execution, all the SQL statements will be executed.
      • Batch
        Transactions are set in batch.
        Once all the SQL statements defined in the file are executed, commit is performed.
        If there is an error during the process, roll back is performed and the process is terminated.
        ※However, the behavior of the transaction when DDL statement is executed depends on the database.

  4. Click “Import”.

    ../../_images/apply_guide_7_6.png

  5. Click “Confirm”.

    ../../_images/apply_guide_7_7.png

  6. SQL file is imported and executed.

    ../../_images/apply_guide_7_8.png

Warning

  • In the SQL file, every SQL statement should be delimited by “semi colon (;)＋ linefeed”.

  • Character code of the file to be imported should be the same as the character code of storage space.
    If the character code is different, it may result in garbling of characters.

«  File Operation   ::   Contents   ::   Portlet management  »

© Copyright 2013 NTT DATA INTRAMART CORPORATION.