Can someone clarify what is EXTEND USING option in the CREATE INDEX
command for, what kind of index structure it creates? Is it a new
feature introduced in FP10, or it's been around for awhile yet?
Thanks,
-Eugene
3  1788 
<ef******@gmail .com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com... Can someone clarify what is EXTEND USING option in the CREATE INDEX
command for, what kind of index structure it creates? Is it a new
feature introduced in FP10, or it's been around for awhile yet?
Thanks,
-Eugene
It is not new to FP 10 and I believe it is availble in 8.1.
This clause uses an index-extention-name. For more information, see CREATE
INDEX EXTENSION in the SQL Reference Vol 2. I think that will provide the
explanation you are looking for.
Mark A wrote: <ef******@gmail .com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com... Can someone clarify what is EXTEND USING option in the CREATE INDEX
command for, what kind of index structure it creates? Is it a new
feature introduced in FP10, or it's been around for awhile yet?
It is not new to FP 10 and I believe it is availble in 8.1.
That's available since V7.1 FP1 (or even V7.1 GA).
This clause uses an index-extention-name. For more information, see CREATE
INDEX EXTENSION in the SQL Reference Vol 2. I think that will provide the
explanation you are looking for.
Originally, this was introduced as part of the DB2 engine work for the DB2
Spatial Extender that needed a more specialized indexing method. You have
to define the indexing method, i.e. the index extension, and with the
EXTEND USING clause you say which index extension along which parameters
shall be used. Another write-up on index extensions can be found here: http://tinyurl.com/8y8yb I hope it explains how index extensions work.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
I just hit this clause when was checking with the general syntax for
CREATE INDEX command so, not having any experience with the feature
like DB2 Spatial it's serving for, just fired that curiosity question
to the group, so thank you guys for your hints.
-Eugene
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ComputerSmith |
last post by:
Hi all.
I have programmed VB6 apps before, ones that use dropdown listboxes, text
boxes, etc... normal stuff.
I was asked by a friend to write a "simple" app that I am unsure how to
proceed with. Any and all help is appreciated.
1) On start of the app, he wants a circle to appear in the middle of the
screen.
2) Clicking the circle allows the user to type 2-3 words in (on?) the
|
by: Dan Rawson |
last post by:
Is there any way to force getopt to process one option first?? I'd like to be able to pass in the name of a
configuration file for my application, then have the remaining command-line parameters over-ride the configuration file
if they are present.
For the moment, I'm restricted to 2.2 versions.
TIA . . . .
Dan
|
by: Mike Chamberlain |
last post by:
Hi all.
I'm trying to extend the Microsoft Enterprise Library Data Access
Application Block
(http://msdn.microsoft.com/library/en-us/dnpag2/html/daab.asp?frame=true)
to work with a Borland Interbase database.
To do this, I copied and renamed the source files for working with a SQL
Server database (SqlCommandWrapper.cs/SqlDatabase.cs to
InterbaseCommandWrapper.cs/InterbaseDatabase.cs). I then changed all
|
by: Random Person |
last post by:
Does anyone know how to use VBA to relink tables between two MS Access
databases? We have two databases, one with VBA code and the other with
data tables. The tables are referenced by linked tables in the database
where the code resides. If we move the database with the data tables to
a new directory, the links are no longer valid.
I tried to update the links by changing the Connect property and refreshing:
Set td = db.TableDefs(0)...
|
by: Maverick |
last post by:
If i try to create foxpro table by the following "sql" statment, the C#
compiler will only return an error "xxxx not support in non-dbc version". The
"index on" command statement return some kind of syntex error too. How can i
create a DBF table with proper indexing ability ?? The "UNIQUE" keyword has
already been proved to be failed to perform normally. Please help
string sql = "CREATE TABLE datafile (field1 C(10) PRIMARY KEY, field2...
| | |
by: jk |
last post by:
Looking through WebUIValidation.js, I discovered that the standard validators
don't cater for non-numeric date formats (e.g. dd-MMM-yyyy) which I would
like to do
To keep code to a minimum, I would like to extend the existing validator to
handle other common date formats and still be able to do both client and/or
server side validation as normal. Unfortunately, I am unable to get the
extended code to ever be called
I implemented the...
|
by: ransoma22 |
last post by:
I developing an application that receive SMS from a connected GSM
handphone, e.g Siemens M55, Nokia 6230,etc through the data cable.
The application(VB.NET) will receive the SMS automatically, process and
output to the screen in my application when a message arrived. But the
problem is how do I read the SMS message immediately when it arrived
without my handphone BeEPINg for new message ? I read up the AT
commands, but when getting down...
|
by: jacobstr |
last post by:
I've noticed Object.extend used in a few different ways and I'm having
trouble distinguishing why certain usages apply to a given situation.
On line 804 Ajax.Base is defined as follows:
Ajax.Base = function() {};
Ajax.Base.prototype = {
setOptions: function(options) { <...>
|
by: Alvin SIU |
last post by:
Hi all,
I have a table in Db2 v8 like this:
Team Name Role
------ -------- ---------------------
A Superman Leader
A Batman Member
A WonderWoman Member
B Alvin Leader
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
