Prompt Labels and Double Wildcards in an isql Session

In an isql session, the default prompt label is either the default wildcard :? or the value of wildcard. You can customize the prompt label by providing a one-word character string with a maximum length of 80 characters, after a wildcard.

If you specify a prompt label that is more than one word, the characters after the first word are ignored. Double wildcards such as :?:? specify that isql needs to prompt you twice for the same input. The second prompt requests you to confirm your first input. If you use a double wildcard, the second prompt label starts with Confirm.

Note: In an isql session, :? or the value of a custom wildcard is only recognized by isql as such, when it is the first "word" of a line.