sql and informix

Article View: borland.public.vdbase.data.sql

Article #794

Back to borland.public.vdbase.data.sql Previous Next

#794

From: zainal ag
Date: Tue, 21 Jul 1998 00:00

8 lines
788 bytes

i am using vdb 5.5 to extract data from informix database, the problem
come when i am using wildcard ie 'like' to get the name from informix.

select * from :informix:ptmed where ptname like 'ALI%'

 this will cause the searching look like never ended for a big database

is a way to limit the search to like 100 record.

Technical Details

Message-ID: <35B3EBA1.35FF@medic.ukm.my>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,8cfa117df13ff39,start
X-Google-Attributes: gidff5a1,public
From: zainal ag <zag@medic.ukm.my>
Subject: sql and informix
Date: 1998/07/21
Message-ID: <35B3EBA1.35FF@medic.ukm.my>
X-Deja-AN: 373352799
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: HUKM
Mime-Version: 1.0
Reply-To: zag@medic.ukm.my
Newsgroups: borland.public.vdbase.data.sql