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.