Re: SQL*Plus extraneous output

From: Joost Ouwerkerk <owrkrj_at_mailhub.sickkids.on.ca>
Date: 1997/08/08
Message-ID: <33eb1b1c.87531720@resunix.sickkids.on.ca>#1/1

SET VERIFY OFF should omit the variable substitution verification from the output -- are you sure it's in there (make sure it's BEFORE any ACCEPT statements)?

Joost Ouwerkerk
HSC Foundation
Toronto.

On Thu, 07 Aug 1997 14:58:05 -0700, Terry Bell <tbell@_NO_SPAM_kamloops.env.gov.bc.ca> wrote:

>How do I supress these old and new messages that appear before my select
>output?
>
>old 1: select %FIELDNAME from &SCHEMA&TABLENAME where %KEYFIELD =
>%KEYVALUE for update
>new 1: select MY_FIELD from MY_SCHEMA.MY_TABLE where MY_KEY = 1997020
>for update
>
>I am using the following settings:
>
> set pagesize 800
> set linesize 2100
> set feedback off
> set headsep off
> set showmode off
> set underline off
> set verify off
>
>Any ideas?
Received on Fri Aug 08 1997 - 00:00:00 CDT