| |
by: Stanley Sinclair |
last post by:
I have a table in V8.1.2 (Windows) which contains about 17,000
constant rows. One column contains a string of about 20 English
words. I need to find all rows which contain three words specified by
their first letters.
For example, if I am looking for rows containing Jon (or Jonathan) and
Will (or William) and Terry (or Terri or Terrance), the SQL would be:
SELECT col1 FROM MYTAB WHERE col2 LIKE '%Jon%' AND col2 LIKE '%Will%'
AND...
|
by: Stanley Sinclair |
last post by:
Bear with me. I am being very calm; took a Valium. I have waited two
weeks to write this, because every time I wrote it before the message
was, at best, nasty.
I need to use the services of NET SEARCH EXTENDER. This is the first
time in over five years of IBM (DB2) developing that I need this.
I don't know how to do it. (Db2 v8.1.2, Windows) I see that I must
deal with indexes, with cache, with other stuff.
|
by: Lan W via DBMonster.com |
last post by:
Hi,
I try to install Db2 Net Search Extender on my Db2 workgroup server edition
on windows machine. When I verify the installation from command window as
typed >nsesampla.bat sample, I received the following error:
DB2text.exe - Entry point not found. The procedure entry point sqlogmblk
could not be located in the dynamic link library DB2SYS.dll. Does anyone have
idea onhow to fix it?
Thanks very much!
|
by: Ralf Gross |
last post by:
Hi,
I'm looking for the Net Search Extender version for linux. We have a
company license for db2 and I got a white box with about
100 CDs in it. I think it's the 'development edition' (IBM DB2 Universal
DEV. ED. 8.1 Media Pack Deutsch). I successfully installed 8.1 with FP 10.
In the box I found the Net Search Extender disc for Windows and Unix
operation systems, but nothing for linux.
|
by: ignatova |
last post by:
Hello,
I have been using IBM Net Search Extender to perform full text searches
on text columns in relational tables in DB2 without any problems until
now. However it doesn't seam to function properly for text indexes
created on attributes of typed tables.
Here are the issued commands:
//create UDT
db2 CREATE TYPE CompMetadata_T AS (dummy Integer,Text CLOB(100K),
|
| |
by: 2803stan |
last post by:
I hear that DB2 V9.1 has dropped, or will soon drop Net Search
Extender.
I have occasion to require quick search for a particular word of
several columns of data, and very many rows.
What is there to replace this indexing feature?
SS
|
by: ting ting |
last post by:
I am using ASP.net 2.0 and I want to search a list of about 2,000 items in a list.
I used a listsearch extender to search item fastly. However, it is still a bit not smooth enough to search.
So I want to use a textbox for the users to type and check the listbox value by Javascript. However, it is very slow also. Can anybody help on searching and auto complete the search item more quickly??
|
by: bhagawansharma |
last post by:
hi friends
i want to use a text box for the user to type letters and query the database to get some results and populate in a list box. Is it possible to do that. like ..
using lest search extender control of ajax but i am not able to integrate textbox with lest search extender in .net .how to do that any body can suggest me.
thank & regard
bhagawan sharma
.
|
by: =?Utf-8?B?UGF1bA==?= |
last post by:
Hi I am using a list search extender and have the control it is assigned to
as a control in a template column in a gridview. Anyhow for some reason the
type to search section that normally appears right above the control is not
appearing right above the control. Although always lined up vertically it
randomly appears in different locations outside the gridview on the web page.
Any suggestions, thanks
--
Paul G
Software engineer.
|
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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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...
|
