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.

ax_copyto

5 posts in Clipper Last posting was on 2008-04-16 11:08:45.0Z
ben tapuchi Posted on 2008-02-24 22:58:55.0Z
From: "ben tapuchi" <bentapuchi@gmail.com>
Newsgroups: advantage.clipper
Subject: ax_copyto
Date: Sun, 24 Feb 2008 17:58:55 -0500
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 64.115.86.186
Message-ID: <47c1f565@solutions.advantagedatabase.com>
X-Trace: 24 Feb 2008 15:53:25 -0700, 64.115.86.186
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.115.86.186
Xref: solutions.advantagedatabase.com Advantage.Clipper:4293
Article PK: 1106973

When trying to copy from a big file (1.8 GB with over 2 millions of
records ) the old line "copy to temp while etc"
takes around 40 min. as oppose to 3 sec. under clipper with out advantage.
I tried using ax_copyto, but this function doesn't have the while/for
parameters, making it useless when I need to copy only 2000 rcsd from the
table

please help
( the idea of dumping advantage after so much work was done is just
depressing


Mark Wilkins Posted on 2008-02-29 18:45:33.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <47c1f565@solutions.advantagedatabase.com>
Subject: Re: ax_copyto
Date: Fri, 29 Feb 2008 11:45:33 -0700
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <47c8517e@solutions.advantagedatabase.com>
X-Trace: 29 Feb 2008 11:39:58 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4297
Article PK: 1106976

Hi,

If you set a server-side filter (e.g., ax_SetServerAOF), then ax_CopyTo will
obey that filter.

Mark Wilkins
Advantage R&D

"ben tapuchi" <bentapuchi@gmail.com> wrote in message
news:47c1f565@solutions.advantagedatabase.com...
> When trying to copy from a big file (1.8 GB with over 2 millions of
> records ) the old line "copy to temp while etc"
> takes around 40 min. as oppose to 3 sec. under clipper with out advantage.
> I tried using ax_copyto, but this function doesn't have the while/for
> parameters, making it useless when I need to copy only 2000 rcsd from the
> table
>
> please help
> ( the idea of dumping advantage after so much work was done is just
> depressing
>


Ricardo Rodriguez Erdmenger Posted on 2008-02-27 05:56:08.0Z
From: "Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com>
Newsgroups: advantage.clipper
References: <47c1f565@solutions.advantagedatabase.com>
Subject: Re: ax_copyto
Date: Tue, 26 Feb 2008 23:56:08 -0600
Lines: 115
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 189.138.252.138
Message-ID: <47c4fa1f@solutions.advantagedatabase.com>
X-Trace: 26 Feb 2008 22:50:23 -0700, 189.138.252.138
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!189.138.252.138
Xref: solutions.advantagedatabase.com Advantage.Clipper:4295
Article PK: 1106978

Ben,

We had the same problem, so I decided to create an app in Delphi (ADS 7).
This app can be called from the Clipper app and execute a Sql and create the
temp table.

Maybe is not the most elegant way to make the old clipper programs could
survive but it works for me.

I suggest to try the Arc util, and test something like

Select *
into temp
from file
where <your_condition>

I created a directory with all my sql sentences and I read them using the
Memoread then StrTran to exchange the parameters in the SQL, and then send
it to run.

I attach some examples






"ben tapuchi" <bentapuchi@gmail.com> escribió en el mensaje
news:47c1f565@solutions.advantagedatabase.com...

> When trying to copy from a big file (1.8 GB with over 2 millions of
> records ) the old line "copy to temp while etc"
> takes around 40 min. as oppose to 3 sec. under clipper with out advantage.
> I tried using ax_copyto, but this function doesn't have the while/for
> parameters, making it useless when I need to copy only 2000 rcsd from the
> table
>
> please help
> ( the idea of dumping advantage after so much work was done is just
> depressing
>
>


Massimo Belgrano Posted on 2008-02-28 21:00:47.0Z
From: "Massimo Belgrano" <mbelgranoREMOVEME@DELTAIN.COM>
Newsgroups: advantage.clipper
References: <47c1f565@solutions.advantagedatabase.com> <47c4fa1f@solutions.advantagedatabase.com>
In-Reply-To: <47c4fa1f@solutions.advantagedatabase.com>
Subject: Re: ax_copyto
Date: Thu, 28 Feb 2008 22:00:47 +0100
Lines: 51
Organization: Delta Informatica
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 151.61.141.204
Message-ID: <47c71fb3@solutions.advantagedatabase.com>
X-Trace: 28 Feb 2008 13:55:15 -0700, 151.61.141.204
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!151.61.141.204
Xref: solutions.advantagedatabase.com Advantage.Clipper:4296
Article PK: 1106974

I suggest you use xharbour (100 clipper compatible) but capable working in
32 bitt with support 32 bit ads

"Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com> ha scritto nel
messaggio news:47c4fa1f@solutions.advantagedatabase.com...

> Ben,
>
> We had the same problem, so I decided to create an app in Delphi (ADS 7).
> This app can be called from the Clipper app and execute a Sql and create
> the temp table.
>
> Maybe is not the most elegant way to make the old clipper programs could
> survive but it works for me.
>
> I suggest to try the Arc util, and test something like
>
> Select *
> into temp
> from file
> where <your_condition>
>
> I created a directory with all my sql sentences and I read them using the
> Memoread then StrTran to exchange the parameters in the SQL, and then send
> it to run.
>
> I attach some examples
>
>
>
>
>
>
> "ben tapuchi" <bentapuchi@gmail.com> escribió en el mensaje
> news:47c1f565@solutions.advantagedatabase.com...
>> When trying to copy from a big file (1.8 GB with over 2 millions of
>> records ) the old line "copy to temp while etc"
>> takes around 40 min. as oppose to 3 sec. under clipper with out
>> advantage.
>> I tried using ax_copyto, but this function doesn't have the while/for
>> parameters, making it useless when I need to copy only 2000 rcsd from the
>> table
>>
>> please help
>> ( the idea of dumping advantage after so much work was done is just
>> depressing
>>
>>
>
>
>


Mark Jacobs Posted on 2008-04-16 11:08:45.0Z
From: "Mark Jacobs" <markj@critical.co.uk>
Newsgroups: advantage.clipper
References: <47c1f565@solutions.advantagedatabase.com>
Subject: Re: ax_copyto
Date: Wed, 16 Apr 2008 12:08:45 +0100
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 81.144.157.8
Message-ID: <4805dcf0@solutions.advantagedatabase.com>
X-Trace: 16 Apr 2008 05:03:12 -0700, 81.144.157.8
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!81.144.157.8
Xref: solutions.advantagedatabase.com Advantage.Clipper:4300
Article PK: 1106980

You could try INDEX ON RECNO() FOR condition1 WHILE condition2 ... instead.
It is probably way faster if performed on the server rather than the client.
--
Mark Jacobs
DK Computing
http://www.dkcomputing.co.uk

"ben tapuchi" <bentapuchi@gmail.com> wrote in message
news:47c1f565@solutions.advantagedatabase.com...
> When trying to copy from a big file (1.8 GB with over 2 millions of
> records ) the old line "copy to temp while etc"
> takes around 40 min. as oppose to 3 sec. under clipper with out advantage.
> I tried using ax_copyto, but this function doesn't have the while/for
> parameters, making it useless when I need to copy only 2000 rcsd from the
> table