Hi, I'm working in Sybase 9.0.2.2451
I'm new in Sybase and I'm trying to create a dynamic where clause in a
stored procedure.
This is my procedure:

ALTER PROCEDURE "DBA"."Testing"( in iwhere VarChar(10) )

BEGIN
Select * from tableX
where columnname = 1
and columnname3 = 100
and columnname5 = 100
END

If parameter iwhere = 'Y' I want to make the last two sentences
starting with 'and' in my where clause invisible, But how do i do
that ?

I realy hope someone copuld help me.

You need to build the statement as a string and use EXECUTE IMMEDIATE.

-chris

janis wrote:

On Sun, 08 Nov 2009 03:08:17 +0100, janis <janimie (AT) gmail (DOT) com> wrote:


you don't need dynamic where for that. consider:


Select * from tableX
where columnname = 1
and ( (columnname3 = 100 and columnname5 = 100) or iwhere = 'Y')


the expression in the 3rd row evaluates to true if the parameter is Y,
regardless of the values of column 3 and 5. if the parameter is not Y,
the filters are in effect.