Generating SQL Scripts

Home | Previous Page | Next Page Creating DataBlade Objects Using BladeSmith > Generating Files >

Generating SQL Scripts

To generate only the SQL scripts, click the SQL node in the Generate DataBlade dialog box; then click Generate Scripts.

The property associated with the SQL node is Directory. The default directory is scripts. You can change the name of the directory the SQL scripts are saved in, but the path must be relative to the project directory.

The following table describes the generated SQL scripts.

SQL Script	Purpose
prepare.sql	Contains SQL statements that describe the DataBlade module to BladeManager.
objects.sql	Contains SQL statements that update the sysbldobjects system table with information about the DataBlade module objects that are created in a database. BladeManager uses the information in the table to register, unregister, and upgrade DataBlade modules.
test.sql	Contains the SQL statements to create all objects in the DataBlade module projects and a GRANT EXECUTE statement.

BladeSmith generates separate files for locale-specific objects such as error messages. For example, the files for the default U.S. English locale are prepare.en_us.sql and errors.en_us.1252. Only one error message file is necessary per language. The database server automatically translates between languages. For example, the errors.en_us.1252 file is sufficient for all en_us encodings; you do not need additional encodings like error.en_us.8859-1.

You can add SQL statements to the generated SQL scripts by adding an SQL file object to your project. See Adding SQL Files for more information about adding SQL statements to a DataBlade module.

Warning:

Do not edit generated SQL scripts. Use BladeSmith to make changes; then regenerate the scripts.