Many ODBC files are protected by passwords. Use the Password command to prompt the user for the password so that you can import or refresh, data files that require passwords.
This command can be issued only in command mode. It is the preferred method for requesting user passwords in procedures.
When the user enters the password, the password is displayed as asterisks (*) in the dialog. The actual password is never displayed, not recorded in the Command Log and is accessible only by the Import and Refresh Commands.
The Password command is most useful in procedures so that you can obtain the necessary passwords to import or refresh ODBC database tables before analyzing them. You can store up to five passwords in a procedure file. For more information, see Set Echo.
PASSWORD n <prompt>
| | n must be a value from 1 to 5. |
| | prompt may be any valid character expression. |
Use the Password command followed by the Import or Refresh commands to import or refresh a password protected data file:
PASSWORD 1 Enter the Payroll Password:
REFRESH ORDERS PASSWORD 1
When the Password command is issued a prompt dialog appears with the specified text and a text box to enter the password.