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.

Migration

3 posts in General Discussion Last posting was on 2004-07-08 10:38:53.0Z
Joe Posted on 2004-07-06 10:02:18.0Z
Sender: 34ad.40ea70e1.1804289383@sybase.com
From: Joe
Newsgroups: ianywhere.public.general
Subject: Migration
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40ea78a9.3700.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Jul 2004 03:02:18 -0700
X-Trace: forums-1-dub 1089108138 10.22.241.41 (6 Jul 2004 03:02:18 -0700)
X-Original-Trace: 6 Jul 2004 03:02:18 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3239
Article PK: 6693

Hi,

I'm migrating from PB6.5 to PB9. The first have SQL-Anywhere
5.5 and the second Adaptive Server Anywhere 8.
And now I find that the value returned in SQLNRows is
different. But if I connect a PB9 application to
SQL-Anywhere5.5 the value is fine. Is this because of the
database? Where to find what the SQLNRows means in ASA8?

(In PB I do a select and then I look the SQLCA.SQLNRows
value)

Thanks,
Joe


Nick Elson Posted on 2004-07-08 03:13:21.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <40ea78a9.3700.1681692777@sybase.com>
Subject: Re: Migration
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
Message-ID: <40ecbbd1$1@forums-1-dub>
Date: 7 Jul 2004 20:13:21 -0700
X-Trace: forums-1-dub 1089256401 65.48.253.93 (7 Jul 2004 20:13:21 -0700)
X-Original-Trace: 7 Jul 2004 20:13:21 -0700, cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3246
Article PK: 6700

There is a database option called

public.row_counts

that may be set to off. Try turning that on to test if this is your
only issue.

But then again we set that to OFF because of the performance
hit otherwise. For a quick port you can modify that option so
that it is only set on for the PB connections that require it
[and only for the DW's or Dynamic SQL that require this].

Alternatively rewriting the parts of the code that requires
that, to no longer work with absolute counts is probably
the best solution. Many application have done without
it because it can often be more flexible to do so
when inserts will compromise the counts anyway.

<Joe> wrote in message news:40ea78a9.3700.1681692777@sybase.com...
> Hi,
>
> I'm migrating from PB6.5 to PB9. The first have SQL-Anywhere
> 5.5 and the second Adaptive Server Anywhere 8.
> And now I find that the value returned in SQLNRows is
> different. But if I connect a PB9 application to
> SQL-Anywhere5.5 the value is fine. Is this because of the
> database? Where to find what the SQLNRows means in ASA8?
>
> (In PB I do a select and then I look the SQLCA.SQLNRows
> value)
>
> Thanks,
> Joe


Joe Posted on 2004-07-08 10:38:53.0Z
Sender: 6804.40ed2339.1804289383@sybase.com
From: Joe
Newsgroups: ianywhere.public.general
Subject: Re: Migration
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40ed243d.6840.1681692777@sybase.com>
References: <40ecbbd1$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Jul 2004 03:38:53 -0700
X-Trace: forums-1-dub 1089283133 10.22.241.41 (8 Jul 2004 03:38:53 -0700)
X-Original-Trace: 8 Jul 2004 03:38:53 -0700, 10.22.241.41
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3247
Article PK: 6701

It worked. Thanks.

> There is a database option called
>
> public.row_counts
>
> that may be set to off. Try turning that on to test if
> this is your only issue.
>
> But then again we set that to OFF because of the
> performance hit otherwise. For a quick port you can
> modify that option so that it is only set on for the PB
> connections that require it [and only for the DW's or
> Dynamic SQL that require this].
>
> Alternatively rewriting the parts of the code that
> requires that, to no longer work with absolute counts is
> probably the best solution. Many application have done
> without it because it can often be more flexible to do so
> when inserts will compromise the counts anyway.
>
>
> <Joe> wrote in message
> > news:40ea78a9.3700.1681692777@sybase.com... Hi,
> >
> > I'm migrating from PB6.5 to PB9. The first have
> > SQL-Anywhere 5.5 and the second Adaptive Server Anywhere
> > 8. And now I find that the value returned in SQLNRows is
> > different. But if I connect a PB9 application to
> > SQL-Anywhere5.5 the value is fine. Is this because of
> > the database? Where to find what the SQLNRows means in
> ASA8? >
> > (In PB I do a select and then I look the SQLCA.SQLNRows
> > value)
> >
> > Thanks,
> > Joe
>
>