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.

Print statement change??

2 posts in General Discussion Last posting was on 2004-07-23 20:16:08.0Z
Eric Posted on 2004-07-23 19:14:15.0Z
Sender: 23f6.41015d9c.1804289383@sybase.com
From: Eric
Newsgroups: ianywhere.public.general
Subject: Print statement change??
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4101647f.244b.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 Jul 2004 12:18:23 -0700, 10.22.241.42
Lines: 5
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Jul 2004 12:07:22 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Jul 2004 12:14:15 -0700
X-Trace: forums-1-dub 1090610055 10.22.108.75 (23 Jul 2004 12:14:15 -0700)
X-Original-Trace: 23 Jul 2004 12:14:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3308
Article PK: 7217

Once I installed ASA 9.0.1, the print statements in my
stored procs started appearing only in my server log file,
no longer to the output window of isql. Did something
change? I was at ASA 8.0.2. Both ASA versions were running
on Windows 2000.


"Bruce Hay" Posted on 2004-07-23 20:16:08.0Z
From: "Bruce Hay" <hay at sybase dot com>
Newsgroups: ianywhere.public.general
References: <4101647f.244b.1681692777@sybase.com>
Subject: Re: Print statement change??
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: hay-xp.sybase.com
Message-ID: <41017301$1@forums-2-dub>
X-Original-Trace: 23 Jul 2004 13:20:17 -0700, hay-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Jul 2004 13:09:15 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Jul 2004 13:16:08 -0700
X-Trace: forums-1-dub 1090613768 10.22.108.75 (23 Jul 2004 13:16:08 -0700)
X-Original-Trace: 23 Jul 2004 13:16:08 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3309
Article PK: 7218

The destination of the output from PRINT statements varies depending on the
programing interface used by the client. DBISQL has changed from using
jConnect to use the iAnywhere JDBC driver, which likely explains the change.
You can tell DBISQL to use jConnect instead in the Connect dialog; however,
you might be better off changing the procedures to use MESSAGE statements,
which allow you to specify the destination.

See:
ASA SQL Reference

SQL Statements

PRINT statement [T-SQL]

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

<Eric> wrote in message news:4101647f.244b.1681692777@sybase.com...
> Once I installed ASA 9.0.1, the print statements in my
> stored procs started appearing only in my server log file,
> no longer to the output window of isql. Did something
> change? I was at ASA 8.0.2. Both ASA versions were running
> on Windows 2000.