The option to save SQL scripts

Use the following option to save SQL scripts.

-saveSQLScripts [-databaseType type -databaseVersion version -reposTool name | -reposName name] [-scriptLocation path]

Shorthand: -sss [-dt type -dv version -to name | -rn name] [-sl path]

Retrieves the SQL scripts associated with a specified tool for a given database platform. You can provide the tool and database platform as parameters or you can provide a repository name. If you provide the tool and database platform, the original scripts will be saved as registered. If you provide a repository name, the formal script parameters will be replaced with the respective repository registration properties before the scripts are saved. If you provide a script location, the files will be saved there.

Example command, using the tool and database platform as parameters:

RepositoryAdmin.bat -saveSQLScripts -dt Db2 -dv 10.5 -sto DataStage

This command saves the SQL scripts as they were originally registered without performing any parameter substitution.

Example command, using the repository and optional script location as parameters:

RepositoryAdmin.bat -saveSQLScripts -rn odb -sl C:\tmp

This command saves the SQL scripts after first substituting the formal parameters with the respective repository registration properties. The scripts are saved in C:\tmp.