Hi Shyam, The CASE statement is documented here: http://www.jooq.org/doc/3.2/manual/sql-building/column-expressions/case-expressions/
The SQL Server specific ISNULL function can be obtained through DSL.nvl() (which is Oracle's equivalent) http://www.jooq.org/javadoc/3.2.x/org/jooq/impl/DSL.html#nvl%28org.jooq.Field,%20org.jooq.Field%29 I have registered a feature request to add DSL.isnull() as a synonym for DSL.nvl(): https://github.com/jOOQ/jOOQ/issues/2970 Cheers Lukas 2014/1/22 Sha <[email protected]> > > How to write an equalent using JOOQ code for the below SQL script. > > case when ( isnull(emp_type,0) ) = 1 then isnull(sal_value,0) else > isnull(sal_value,0) end > > Thank you. > ~Shyam > > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
