PASSWORD command

Creates a password definition, without a password value, that prompts users for a password while a script is running.

Syntax

PASSWORD num <prompt>

Parameters

Name	Description
num	A value from 1 to 10 that uniquely identifies the password definition.
prompt optional	A valid character expression to display in the dialog box used to prompt for the password. Enclose literal strings in quotation marks. If prompt is omitted, a default dialog box with no message is displayed.

Name

Description

num

A value from 1 to 10 that uniquely identifies the password definition.

prompt

optional

A valid character expression to display in the dialog box used to prompt for the password. Enclose literal strings in quotation marks.

If prompt is omitted, a default dialog box with no message is displayed.

Examples

Prompting for password information

You use the PASSWORD command to prompt the user for the three passwords required in a script. Once the user enters the required passwords, the script can complete the remaining processing without interruption:

PASSWORD 1 "Enter the password for the Receivables database"
PASSWORD 2 "Enter the password for the Payables database"
PASSWORD 3 "Enter the password for the Customer database"

Specifying a password when refreshing an Analytics table

You combine the PASSWORD command with the REFRESH command to update a password-protected data file:

PASSWORD 1 "Password:"
REFRESH Abc PASSWORD 1

Specifying a password to define a server table

You use the PASSWORD command with the DEFINE TABLE DB command to define a server table via AX Connector, which requires one password for the database profile, and another for the associated server profile:

DEFINE TABLE DB SOURCE Inventory_DBProfile PASSWORD 9 PASSWORD 3

Remarks

When to use PASSWORD

Use the PASSWORD command to prompt a user to enter password information before a script accesses, imports, or refreshes password-protected data.

You can create up to ten different password definitions in a script.

PASSWORD is useful if:

you want to avoid typing an actual password in a script, which the SET PASSWORD command requires
individual users need to enter distinct passwords

How passwords are stored

User-entered passwords are temporarily and securely stored in memory.

When a user types a password into the prompt dialog box, the characters are masked using asterisks (*). The password does not appear in either the script or the log.

Storing passwords for server-based analytics

The PASSWORD command is not supported in analytic scripts run in Robots, or in legacy server scripts.

You can use the PASSWORD analytic tag to prompt for a password when a user schedules an analytic script in Robots.

You can use the SET PASSWORD command to specify passwords in legacy server scripts.