Global Preferences - Database SQL

This chapter is composed of :

1. Introduction
2. Database SQL
   1. SQL Execution Behaviour
      1. On Error
      2. Autocommit
      3. SQL Output Result
   2. Encoding Policy

1. Introduction

The SQL Preferences allows the developer to set SQL execution global settings.

These settings will be inherited to each new SQL Forward wizard page.

2. Database SQL

2.1. SQL Execution Behaviour

With the SQL Execution Behaviour set of options you can control the way your SQL instructions are processed.

2.1.1. On Error

With the On Error options you control the flow of your processed SQL instructions.

• Continue
• Stop
• Abort

2.1.2. Autocommit

The Autocommit option will consider each SQL instruction as a transaction.

2.1.3. SQL Output Result

The SQL Output Result will display a detailed report in the DatabaseConsole window.

2.2. Encoding Policy

• You can control how Database Schema Reversed Default Values are encoded.
• You can control how extracted Database Data are encoded.

Character means that retrieved SQL values are left as sent by your Database.

Base64 means that retrieved SQL values are Base64 encoded.

Hexadecimal means that retrieved SQL values are Hexadecimal encoded.