Hi,

pls suggest me how to pass varible in a select query;
i.e
set output = select count(CaseNo) from casedata where DEPTID= variable_name;

i am writing this query in a function.

Regards

Amit Singal

----- Original Message -----
From: "sonika " <db2udbdba-ezmlmshield-x338828.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, July 28, 2005 3:16 PM
Subject: How to reduce Logical I/O


>
>
> Hi Great DBA's
>
>
>
> Please tell me how can I reduce Logical I/O
>
>
>
> The role of arraysize & clustering factor
>
>
>
> Thanks & Regards
>
>
>
> Sonika Choudhary
>
>
>
> Times Internet Limited.
>
> MPD Tower, Sector Road Zone-VI,
>
> DLF Phase-V,Opp DLF Golf Course,
>
> Gurgaon-122002,Haryana
>
> Tel. No.-0124-5187000/100/200,Extn-2355
>
> Mobil-9891378817.
>
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>



DB2 & UDB email list listserv db2-l LazyDBA home page