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.

DW retrieval failing - 2 tables JOIN as a Source

2 posts in Appeon (partner product) Last posting was on 2005-05-10 10:27:47.0Z
Suresh Posted on 2005-05-09 16:48:40.0Z
Sender: 7a83.427f8faf.1804289383@sybase.com
From: Suresh
Newsgroups: sybase.public.appeon
Subject: DW retrieval failing - 2 tables JOIN as a Source
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <427f9464.7ad0.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 9 May 2005 09:48:36 -0700, 10.22.241.42
Lines: 6
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 May 2005 09:48:37 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 May 2005 09:48:40 -0700
X-Trace: forums-1-dub 1115657320 10.22.108.75 (9 May 2005 09:48:40 -0700)
X-Original-Trace: 9 May 2005 09:48:40 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:830
Article PK: 20914

DW is not retrieving the data if 2 tables used as a source
(SQL Select). Do we need to change/fine tune DW SQL ?
Or Appeon2.8 is not supporting SQL select at this moment ?
We are using PB 8.0.4 Build 10656.
If it is a single table retrieval it was working fine.
Thanks in advance.


Julie Jiang Posted on 2005-05-10 10:27:47.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 218.18.114.119
References: <427f9464.7ad0.1681692777@sybase.com>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: DW retrieval failing - 2 tables JOIN as a Source
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <42808ca3$1@forums-1-dub>
Date: 10 May 2005 03:27:47 -0700
X-Trace: forums-1-dub 1115720867 64.79.161.40 (10 May 2005 03:27:47 -0700)
X-Original-Trace: 10 May 2005 03:27:47 -0700, web110.discountasp.net
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:836
Article PK: 20919

Using multiple tables as a DataWindow source is supported by Appeon. SQL select
is also supported. Please check whether the error is caused by error in the SQL
statement: execute the SQL statement of DW in PB ISQL. If the SQL cannot be
executed correctly, you need to correct the SQL in PowerBuilder.

If the error persists, please provide more information for Appeon to
investigate:
1) A test case that contains the problematic DW, and a sample database (This is
for us to reproduce the error).
2) With the log mode in AEM set to debug, get the following logs and provide
them to me: Jaguarhttprequest.log, Jaguarhttpservlet.log, LogSystem.log,
Jaguar.log.
3) The following screenshots: Application profile | DB profile config; AEM |
Transaction Object config; Properties of the connection cache (used for the
application).

Please directly send me the information to my email address.

Regards,
Julie

On 9 May 2005 09:48:40 -0700,
in sybase.public.appeon

<Suresh> wrote:
>DW is not retrieving the data if 2 tables used as a source
>(SQL Select). Do we need to change/fine tune DW SQL ?
>Or Appeon2.8 is not supporting SQL select at this moment ?
>We are using PB 8.0.4 Build 10656.
>If it is a single table retrieval it was working fine.
> Thanks in advance.