Online Documentation for SQL Manager for DB2

Local scripts


Local scripts are the scripts that are stored locally and can be easily accessed from the DB Explorer.

 

To create new local script right-click the appropriate branch in the DB Explorer tree and select the New Script item. You will be asked for the script name. When the name is assigned the script appears in the DB Explorer tree.

 

Local Script - Setting script name

 

 

It is also possible to create subfolders in the Local scripts branch. Folders created there are created physically as subfolders to the folder assigned as default for local scripts in the DB Registration info | Directories.

 

To change directory where local scripts to be stored use the Select Directory... item of the Local Scripts context menu.

 

Script opens in the SQL Script where it can be edited or executed. You can also save local script as the shared one.