HCL Workload Automation, Version 9.4

Generating the SQL files on Microsoft SQL Server

To generate the SQL files, you use the customizeSQL script which is located in:

<images_dir>\dbtools\customizeSQL.bat

Where <images_dir> is the directory where you stored the product images.

To show command usage, run:

customizeSQL -usage

The script has the following syntax:

customizeSQL.bat -propertyFile <property_file>

Where <property_file> is the absolute path of the directory where the property file is located.

If you store the properties file in the C:\tmp\ directory, run:

customizeSQL.bat \tmp\customizeWinMSSQLSql.properties

Note: The SQL files are created in the directory that you specified in the TWSTEMPDIR property of the configuration file. For more information about how to customize the property file, see Customizing the properties file for Microsoft SQL Server.