Add SQL files

Use BladeSmith to add custom SQL commands to the scripts that describe a DataBlade® module and its objects. You can include SQL commands to create tables, indexes, or SPL procedures your DataBlade module requires.

For example, if your DataBlade module uses smart large objects, you can include a statement to test for the required sbspace when you register the DataBlade module.

Use the three-character new object prefix assigned to your project in the name of every custom SQL object you create. The maximum size of an SQL file is 20 KB.

If you create any objects for your DataBlade module, add corresponding SQL DROP statements so that the objects are dropped when your DataBlade module is unregistered.

To add custom SQL, start the wizard by choosing Edit > Insert > SQL > Files. Enter SQL commands directly into the BladeSmith edit window, or import a disk file into the BladeSmith project. When you import a file, copy the contents of the file at the time you import, or import the file by reference so that its contents are copied whenever you generate SQL scripts.

The following table lists the properties you specify when you include custom SQL statements.

Table 1. Properties for including custom SQL statements
Property	Default value	Description
Descriptive name	SQLfile	A descriptive name for the custom SQL statements.
Read SQL text from file	None	Use to import SQL statements into the CREATE and DROP fields or to import by reference. See Import SQL text from a file for more information.
Custom SQL CREATE text	None	A text field in which to type SQL CREATE statements.
Custom SQL DROP text	None	A text field in which to type SQL DROP statements.
Depends on objects	None	A list of objects on which the custom SQL depends. See Object dependencies for more information.
Which objects require SQL	None	A list of objects that depend on the custom SQL. See Object dependencies for more information.

The following sections describe properties of custom SQL files.