Null cast db2

View All Locations. How to design your resume? Have you ever lie on your resume? Read This Tips for writing resume in slowdown What do employers look for in a resume? Interview Tips 5 ways to be authentic in an interview Tips to help you face your job interview Top 10 commonly asked BPO Interview questions 5 things you should never talk in any job interview Best job interview tips for job seekers 7 Tips to recruit the right candidates in 5 Important interview questions techies fumble most What are avoidable questions in an Interview?

Top 10 facts why you need a cover letter? Username Password. New to Wisdomjobs? Sign up. Sql Components. Next Topics » Values Clause.

Add a comment. Active Oldest Votes. For the stored procedure, I hypothesize that both will work. With the stored procedure, the declaration of the argument tells the system which type the NULL is. Jonathan Leffler Jonathan Leffler k gold badges silver badges bronze badges. Your reasoning makes sense and is good news to me. Do you know where that is documented? The obvious starting point is DB2 9. One piece with some relevant info about changes in NULL handling in 9.

Otherwise, it should be in here: SQL Reference. Thanks a lot, that's exactly what I was looking for. Especially the fact that IBM changed something with version 9. Sign up or log in Sign up using Google. Sign up using Facebook. As I suspected, there was a change in DB2 as of version 9. IBM sneaked in a broader null type support with that version, which explains why tests fail on your side, but don't fail on mine.

This is out of scope for this ticket and will be treated in Author: estromsnes I'm glad you figured that out. Looks like IBM is moving in the right direction. Maybe this should be added to the Features wiki page so that the users are aware of this? Author: estromsnes Yes, that the users are aware of the fact that Factory. Skip to content. Star 4. New issue. Jump to bottom. Milestone Version 1. Copy link. NULL value should be cast to an explicit type for Derby dialect Member Author.

They don't fail on my box Aware of what?