Database Data SQL Script


This chapter is composed of :

  1. Introduction
  2. Database Data SQL Script
    1. Database Data SQL Script Page
      1. Script Name
      2. Data Name
    2. Finish
  3. Templates
  4. Additional Resources

1. Introduction

The purpose of this chapter is to show how to generate a Data SQL Script from a Database Data DTD or an existing Database Data resource.

When forwarded to your Database, this script will be able to define data in your Database.

 

2. Database Data SQL Script

To start the Database Data SQL Script wizard, select :

File->New->Other->Database->Database Data SQL Script

or

Select an object in the Package Explorer View or the Navigator View then right-click and select :

New->Other->Database->Database Data SQL Script

This wizard has two pages :

The selection is contextual.

This means that if you select an existing Database Data DTD or an existing Database Data resource :

 

 

The New Database Data SQL Script page will preset your current Database Data resource.

 

 

Otherwise :

 

 

A new Database Data SQL Script Page will be opened without any selected Database Data resource.



 

2.1. Database Data SQL Script Page

 

 

2.1.1. Script Name

Script Name is the name of your new SQL script.

Each resource should have a unique name in the targeted selected workspace folder or project root.

This data is not related to any Meta Data information.

This name will be the file name of the generated SQL file.

Its file extension is :

This file is referenced in your current Database Connection.

 

2.1.2. Data Name

Use the Data button :

 

 

Select the appropriate Database Data file.

 

2.2. Finish

The script generation of the new Database Data SQL Script will be processed and created.

 

 

Detailed information is available in the DatabaseConsole window.

Some databases don't support Database Data SQL Script generation.

A message is displayed in the Database Data SQL Script page.

 

 

3. Templates

This wizard is Template based.

Below your Plugin Templates or MyTemplates you should see the following directory :

Torque/sql/load

 

 

These templates are Velocity based and use the Torque Model API.

 

4. Additional Resources

Here are several links provided for further Apache Velocity related information.