Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

DBISQL options

2 posts in General Discussion Last posting was on 2002-09-06 16:01:08.0Z
Brian Posted on 2002-09-05 22:22:17.0Z
From: Brian
Date: Thu, 5 Sep 2002 18:22:17 -0400
Newsgroups: ianywhere.public.general
Subject: DBISQL options
Message-ID: <84310184B9B308E6007AE40985256C2B.007AE41B85256C2B@webforums>
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:637
Article PK: 3225

I need to suppress the system generated info when running DBISQL.
I don't want field headings or "first 500 rows" message.
Any ideas? TIA. I'm on ASA 7.0.

Using the following in my sql file as input to DBISQL =>

SET TEMPORARY OPTION HEADINGS = 'OFF';
select Result from RecProd;

I still get=>

(First 500 rows) -- don't want this

RESULT -- don't want this
--------------------------------------------------
Lamba on 07/22/2002: .514
Shift on 07/22/2002: -15.879
Slope on 07/22/2002: -17.7800
Premium Slope on 07/22/2002: -34.41
Premium Slope on 07/22/2002: -31


Robert Waywell Posted on 2002-09-06 16:01:08.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <84310184B9B308E6007AE40985256C2B.007AE41B85256C2B@webforums>
Subject: Re: DBISQL options
Date: Fri, 6 Sep 2002 12:01:08 -0400
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <gGkrACcVCHA.258@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:631
Article PK: 2654

What patch level and build number of 7.x?

If you still see the problem behaviour in 7.04 with a current ebf, then I
would recommend submitting the case.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Brian> wrote in message
news:84310184B9B308E6007AE40985256C2B.007AE41B85256C2B@webforums...
>
> I need to suppress the system generated info when running DBISQL.
> I don't want field headings or "first 500 rows" message.
> Any ideas? TIA. I'm on ASA 7.0.
>
> Using the following in my sql file as input to DBISQL =>
>
> SET TEMPORARY OPTION HEADINGS = 'OFF';
> select Result from RecProd;
>
> I still get=>
>
> (First 500 rows) -- don't want this
>
> RESULT -- don't want this
> --------------------------------------------------
> Lamba on 07/22/2002: .514
> Shift on 07/22/2002: -15.879
> Slope on 07/22/2002: -17.7800
> Premium Slope on 07/22/2002: -34.41
> Premium Slope on 07/22/2002: -31
>