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.

How to create indexes using AIS

4 posts in Internet Server Last posting was on 2008-09-17 19:21:43.0Z
Carlos Posted on 2008-09-05 16:53:55.0Z
From: "Carlos" <cavr_arrob_adinet.com.uy>
Newsgroups: advantage.internet_server
Subject: How to create indexes using AIS
Date: Fri, 5 Sep 2008 13:53:55 -0300
Lines: 9
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; Original
X-Antivirus: avast! (VPS 080905-0, 05/09/2008), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 200.40.190.118
Message-ID: <48c1636b@solutions.advantagedatabase.com>
X-Trace: 5 Sep 2008 10:50:51 -0700, 200.40.190.118
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!200.40.190.118
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:754
Article PK: 1121008

I am testing xHarbour and ADS 8.1 over an internet conection (AIS).
When I open a DBF table, how can I be sure its index file (.CDX) exists ?
What command or function can I use to check. FILE() function don't run over
AIS.
What command or function can I use to build the index file ?

Thanks.


Jeremy Mullin Posted on 2008-09-05 19:40:31.0Z
Date: Fri, 5 Sep 2008 19:40:31 +0000 (UTC)
Message-ID: <1b468bc83831a8cadd7419dd0298@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: How to create indexes using AIS
Newsgroups: Advantage.Internet_Server
References: <48c1636b@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.114
X-Trace: 5 Sep 2008 13:34:21 -0700, 10.24.38.114
Lines: 9
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.114
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:755
Article PK: 1121009

You can try setting it as the active index order and if it returns an error
the index doesn't exist.

J.D. Mullin
Advantage R&D
Sybase iAnywhere
http://jdmullin.blogspot.com


Carlos Posted on 2008-09-06 11:46:06.0Z
From: "Carlos" <cavr_arrob_adinet.com.uy>
Newsgroups: Advantage.Internet_Server
References: <48c1636b@solutions.advantagedatabase.com> <1b468bc83831a8cadd7419dd0298@devzone.advantagedatabase.com>
Subject: Re: How to create indexes using AIS
Date: Sat, 6 Sep 2008 08:46:06 -0300
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
X-Antivirus: avast! (VPS 080905-0, 05/09/2008), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 200.40.190.118
Message-ID: <48c26cc0@solutions.advantagedatabase.com>
X-Trace: 6 Sep 2008 05:42:56 -0700, 200.40.190.118
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!200.40.190.118
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:756
Article PK: 1121010

Thanks for your answer.

Is there any way to know how many indexes or tags has a DBF table using an
SQL query ?

From ARC using an Internet Conexion it is possible to create indexes ?

Thanks.


"Jeremy Mullin" <no@email.com> escribió en el mensaje
news:1b468bc83831a8cadd7419dd0298@devzone.advantagedatabase.com...

> You can try setting it as the active index order and if it returns an
> error the index doesn't exist.
>
> J.D. Mullin
> Advantage R&D
> Sybase iAnywhere
> http://jdmullin.blogspot.com
>
>


Alex Wong (ADS) Posted on 2008-09-17 19:21:43.0Z
From: "Alex Wong \(ADS\)" <nobody@sybase.com>
Newsgroups: Advantage.Internet_Server
References: <48c1636b@solutions.advantagedatabase.com> <1b468bc83831a8cadd7419dd0298@devzone.advantagedatabase.com> <48c26cc0@solutions.advantagedatabase.com>
Subject: Re: How to create indexes using AIS
Date: Wed, 17 Sep 2008 13:21:43 -0600
Lines: 19
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.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.144
Message-ID: <48d15752@solutions.advantagedatabase.com>
X-Trace: 17 Sep 2008 13:15:30 -0700, 10.24.38.144
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.144
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:757
Article PK: 1121011


"Carlos" <cavr_arrob_adinet.com.uy> wrote in message
news:48c26cc0@solutions.advantagedatabase.com...
> Thanks for your answer.
>
> Is there any way to know how many indexes or tags has a DBF table using
> an SQL query ?

No, unless the table is part of a data dictionary.

>
> From ARC using an Internet Conexion it is possible to create indexes ?
>

The SQL CREATE INDEX ... command can be used to create indexes.

--
Alex