Re: [WEB400] Where clause

["Rohan Sootarsing" <Rohan.Sootarsing@xxxxxxxxxxxxx>]

Thanks
That helped


>>> recuyer@xxxxxxx 16/05/2005 10:48:21 >>>
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.
>
>

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

______________________________________________________________________________
This email has been checked for viruses by ArmourPlate,
http://www.armourplate.com, the multi-scanner anti-virus facility from
Corpex. 


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