When you issue the ddlgen utility in a UNIX command line environment, other users on that UNIX machine can see your ddlgen command—including its password—if they issue the ps process management command, which shows the status of processes that are running on that machine.
Adaptive Server 15.0.2 ESD #2 includes a new ddlgen -P password parameter option that lets you invoke ddlgen from a script so that the password is hidden from other users.
To do this, include the string “pwd” in the -P parameter. This acts as a pseudo-password, while you supply the actual password in the next line of the script:
ddlgen -Ulogin -Ppwd -Sserver:port -Ttype -Nname << END $PSWD END
The actual ddlgen password string is hidden in the $PSWD environment variable.
If you prefer to keep your password in a file, replace $PSWD with 'cat filename', where filename is the location of your password file. For example:
ddlgen -Ulogin -Ppwd -Sserver:port -Ttype -Nname << END 'cat filename' END
For more information about ddlgen, see the ddlgen reference pages in the Utility Guide.
