DB2 ISNULL?

• Peter P

  SSCrazy

  Points: 2777

  More actions

  March 9, 2005 at 11:15 am

  #60991

  I am connecting to an AS400 as a linked server and querying the tables using the OPENQUERY method.  However, the T-SQL ISNULL function is not available.  Is there a "DB2 equivalent" for SQL Server's IsNull() function?

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  March 9, 2005 at 11:36 am

  #546208

  NULLIF()

  Google group search on the comp.databases.ibm-db2 newsgroup will answer DB2 stuff real fast.

   

• Peter P

  SSCrazy

  Points: 2777

  More actions

  March 9, 2005 at 12:19 pm

  #546216

  Thanks!

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  March 10, 2005 at 5:27 am

  #546333

  This is also a good reference for DB2 SQL that I keep bookmarked.

  https://aurora.vcu.edu/db2help/db2s0/frame3.htm

  
  
  Mark

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  March 10, 2005 at 7:38 am

  #546367

  If I'm not mistaken, you want COALESCE as equvivalent to ISNULL, not NULLIF

  NULLIF does not do the same thing as ISNULL.

  /Kenneth