Re: [WEB400] Where clause

["Richard ECUYER" <recuyer@xxxxxxx>]

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.
>
>