Show TOC

Function documentationUser Prompts Locate this document in the navigation structure

 

This command generates customized dialog boxes. This allows you to query a user for the following types of information:

  • The file to load

  • The data to export

  • The target application for the selected data

When multiple PROMPT commands are entered in the same script, all prompts are combined into one dialog box. This rule applies to all PROMPT commands that ask for the selection of a file, a delimiter, or text. This rule does not apply to the COPYMOVE and SELECT prompts, which are presented to the user individually.

All file selection prompts return the name of the selected file with the complete path. The system assumes all members for this dimension (the system does not insert a range for this dimension in the returned SQL statement) in the following cases:

  • In a SELECT prompt, the user leaves any field blank

  • For a given dimension in a COPYMOVE prompt, both the source and destination fields are blank

The syntax for the PROMPT command is:

PROMPT([prompt type], [variable name], [second variable name], [parameters,…])

The currently supported types of PROMPT commands are:

  • CHECKBOXGROUP

  • CHECKBOXNO

  • CHECKBOXYES

  • CONVERSION

  • COPYMOVE

  • COPYMOVEINPUT

  • DELIMITER

  • INFILE

  • INFILES

  • LOGICFILE

  • MESSAGE

  • OUTFILE

  • RADIOBUTTON

  • SELECT

  • SELECTINPUT

  • SELECTIONFILE

  • TEXT

  • TRANSFORMATION