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.

SyntaxFromSQL problem

2 posts in Appeon (partner product) Last posting was on 2010-12-08 09:11:12.0Z
pangalz Posted on 2010-12-07 15:27:44.0Z
Sender: 7ae0.4cfe4f49.1804289383@sybase.com
From: pangalz@gmail.com
Newsgroups: sybase.public.appeon
Subject: SyntaxFromSQL problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cfe5270.7bb1.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Dec 2010 07:27:44 -0800
X-Trace: forums-1-dub 1291735664 10.22.241.41 (7 Dec 2010 07:27:44 -0800)
X-Original-Trace: 7 Dec 2010 07:27:44 -0800, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2614
Article PK: 21786

Hello!

I have a problem with the function SyntaxFromSQL in Appeon.
The problem is that the SQL sent to the function (with no
WHERE clause) is extremely slow.
I noticed that PowerBuilder SyntaxFromSQL function with the
same SQL, returns instantly. This is because it implicitly
adds the clause (WHERE 1 = 2) to return only the column
definitions.
In Appeon, I realized that it executes the SQL without
adding the clause 1 = 2, using the function with a table
containing 15 million rows, it takes 30 minutes to return!

I'm using Appeon 6.5 (Windows) and Sybase ASA 9 (Windows).

This is an Appeon bug?


Steven Posted on 2010-12-08 09:11:12.0Z
Sender: 4743.4cfd9d3f.1804289383@sybase.com
From: steven
Newsgroups: sybase.public.appeon
Subject: Re: SyntaxFromSQL problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cff4bb0.3bd2.1681692777@sybase.com>
References: <4cfe5270.7bb1.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Dec 2010 01:11:12 -0800
X-Trace: forums-1-dub 1291799472 10.22.241.41 (8 Dec 2010 01:11:12 -0800)
X-Original-Trace: 8 Dec 2010 01:11:12 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2615
Article PK: 13516

Hi,

Could you provide some scripts?

Regards,
Steven