× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



first, you can return only needed columns (not *) for the where clause :

Where fildalpha = 'XYZ'
or where filedNum = 12345

what is your problem with the where clause ?

----- Original Message ----- 
From: "Rohan Sootarsing" <Rohan.Sootarsing@xxxxxxxxxxxxx>
To: <web400@xxxxxxxxxxxx>
Sent: Monday, May 16, 2005 11:40 AM
Subject: [WEB400] Where clause


> Hi there I am querying the as400 for data into an asp application i can
> return all records but as there are 64,000 of them this is a bit server
> hungry. I tried doing a where clause but this didnt seem to work can
> anyone give me some tips this is my current query
>
> select * from ctx4nthg ",connDB2
>
> Thanks in advance
> Rohan
>
>
>
____________________________________________________________________________
__
> This message has been checked for viruses by Corpex
> using the ArmourPlate Virus Scanning Service. To find out
> how to protect your company visit http://www.armourplate.com
> or call Corpex on +44 (0)207 430 8000.
> -- 
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.
>
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.