Regarding Update querry at JDBC Sender adapter

Dear all

need you help for this requirement

My Select statement is working fine where flag column has some time null value

below is the Select statement and ( EMP_MAXQTY_AUTH_FLAG is Flag field here & EMPLOYEE_MST is table name)

SELECT EMP_ORG_CD,EMP_CD,EMP_NAME,EMP_STATUS,EMP_MAXQTY_AUTH_FLAG FROM EMPLOYEE_MST WHERE EMP_MAXQTY_AUTH_FLAG<>'Y'or EMP_MAXQTY_AUTH_FLAG is null

but update querry is as given below

UPDATE EMPLOYEE_MST SET EMP_MAXQTY_AUTH_FLAG='Y' WHERE ((EMP_MAXQTY_AUTH_FLAG <>'Y') OR (EMP_MAXQTY_AUTH_FLAG is NULL))

Please suggest the exact query

if Flag row ahs some value any thing it is updating , but when there is NULL value ,

problem is coming

Please help.....

Regards

Priya