Platform Framework
R24 AMR | Min(s) read

Overview

This section helps you to get familiar with key DB tools features.

Authenticated users can access TAFJ DB Tools. Therefore, username and password is passed as parameters to DBTools. User access to DBTools is created using a file tUserMgnt.bat or tUserMgnt.sh. If there are three unsuccessful attempts, the user gets blocked. The blocked user cannot be used further until the user is reset with a new password or it is deleted or recreated.

TAFJ DBTools provide the following functionalities:

  • Execute SQL statements
  • Execute JQL statements
  • Execute OFS statements
  • Execute JED application (edit and modify record)
  • Extract data from database to file
  • Load data from file to database
  • Show current locks on database
  • Release locks on database
  • Display statistics on table

Syntax

This section shows you the DBTools syntax in interactive, script and silent modes.

Presentation

This section gives a brief overview of DBTools console features.

Database Functions

This section shows the Database functions that are supported by TAFJ.

Console Functionalities

This section shows the DBTools Console functions that are supported by TAFJ.

Setup Command

The setup command allows you to access the properties through which you can customize your session. These properties are stored in the DBTools properties file and are shared between users.

Navigation and Display

This section provides information on DBTools console layout such as page, column and console display.

In this topic

Copyright © 2020- Temenos Headquarters SA

Published on :
Monday, May 27, 2024 5:14:10 PM IST