KDLV_RESPONSES

This table stores the prompts and responses used by the special command 'ksc_respond'. Currently, this table is seeded to only work with Patch*Applicator (adpatch and adadmin). The 'ksc_respond' can support responses to generic programs requiring interactivity, but no seeded data is supplied.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KDLV_RESPONSES

RESPONSE_ID

PARENT_RESPONSE_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

RESPONSE_ID

NOT NULL

NUMBER

System-generated identifier

PARENT_RESPONSE_ID

NULLABLE

NUMBER

Used to link multi-line prompts, including menu prompts

MODULE

NOT NULL

VARCHAR2(40)

Currently, this field is either 'ADPATCH' or 'ADADMIN_<function>'. With the VERSION value, this column identifies a unique set of responses to use during processing. In order to use Patch*Applicator, the value must begin with 'ADADMIN' or 'ADPATCH'.

VERSION

NOT NULL

VARCHAR2(40)

System-generated version for the entity. This column must not be updated manually

PROMPT_TYPE

NOT NULL

VARCHAR2(240)

Identifies the prompt type. (A command parameter, multi-line prompt, sql response, token response, value, menu item)

PROMPT

NOT NULL

VARCHAR2(240)

Prompt to search for

RESPONSE

NULLABLE

VARCHAR2(500)

Response that will be issued if the prompt is found

ENCRYPT_FLAG

NOT NULL

VARCHAR2(1)

Signifies the response should be encrypted (for example, a password)

EXIT_FLAG

NOT NULL

VARCHAR2(1)

Exit after processing this prompt

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NULLABLE

NUMBER

Identifier for the user who last updated the record

NEXT_MODULE

NULLABLE

VARCHAR2(40)

Next module to respond to (used when interacting with menus)

NEXT_VERSION

NULLABLE

VARCHAR2(40)

Next version to respond to (used when interacting with menus)

BUFFER_LINES

NULLABLE

NUMBER

Number of buffered lines to search for a menu item

EXECUTION_FLAG

NULLABLE

VARCHAR2(1)

Whether or not this is an execution (used when interacting with menus). If this value is Y, the next menu found will cause ksc_respond to load a new set of responses per the NEXT_MODULE and NEXT_VERSION values

ACTION

NULLABLE

VARCHAR2(200)

Show the action taken in conjunction with this response. Action is in addition to the normal response processing.

DEFAULT_PROMPT_TYPE

NULLABLE

VARCHAR2(240)

What form does the default prompt take

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_RESPONSES_U1

UNIQUE

1

RESPONSE_ID

Sequences

This table uses no sequences.