Do one of the following in Workbench to open the Prompted User Variable Properties dialog box:
From the menu:
Click View > User Variables. The Variables dialog box appears.
Click Add Prompted.
From the Target pane:
Right-click a linked field and select Edit Lookup Criteria. The Edit Lookup Criteria for the selected field appears.
Click Edit Lookup Formula. The Edit Formula for the selected field appears.
Click Show User Variables.
Click Add Prompted.
Enter in Variable Name a meaningful name for the variable.
Select a Data
Type from the drop-down list. The options are: Date, DateTime,
Number, String, and Time.
Enter in Default
Value/Formula either a value or a formula to use if the user
does not enter anything when prompted, or if the value is not supplied
via a command line argument.
Optionally, enter in Help Text information about the variable.
Enter in Prompt Text the text that should appear to prompt users to enter a value. This text can be up to 256 characters.
Define Prompt
Text that displays whenever a user is prompted to enter a value
or formula.
Click OK. A message indicates if any required information is missing or if any invalid values were provided.
Click OK.
If any required information is missing or if any invalid values were provided, a message appears. Otherwise, the new variable appears under User
Variables in the Variables dialog box.
Note: If quotation marks enclose a prompted variable, the quotation marks are stripped from the variable. To pass a quoted variable, use escape characters (\") before each quotation mark. For example, to pass "Hello world" into a formula, use the following: "\"Hello world\""