Init_Prompt

Specifies whether you want to be prompted during initialization.

When to specify Init_Prompt You must specify the Init_Prompt parameter before connecting to the database.

Prompt = 'value'

Parameter	Description
value	Specifies whether you want to be prompted during initialization. Values are: Not set Do not prompt. Always Always prompt for initialization information. If needed Prompt only if more information is needed. If needed (required) Prompt only if more information is needed. Do not allow the user to enter optional information. Never Do not prompt.

Parameter

Description

value

Specifies whether you want to be prompted during initialization. Values are:

Not set Do not prompt.
Always Always prompt for initialization information.
If needed Prompt only if more information is needed.
If needed (required) Prompt only if more information is needed. Do not allow the user to enter optional information.
Never Do not prompt.

Init_Prompt = 'Not set'

To specify that you want always to be prompted during initialization:

Database profile Select Always from the Prompt drop-down list on the System tab in the Database Profile Setup dialog box.

Application Type the following in code:

SQLCA.DBParm="INIT_PROMPT='DBPROMPT_PROMPT'"