Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is a NULL value? What are the pros and cons of using

Answers were Sorted based on User's Feedback

What is a NULL value? What are the pros and cons of using NULLS?..

Answer / s

NULL Value indicates the absence of a value. DB2 treats
NULL as an actual value and is not equal to blank, zero or
empty string.

The default value of a CHAR data type is blanks, VARCHAR is
empty string and INT,SMALLINT,FLOAT etc is 0.
NULL is not equal to any of the above.

NULLs does not satify any condition in the SQL except when
IS NULL predicate is used. Null can be used at times when
you cannot specify a value for a column, eg middle names,
not everyone has middle names.

Is This Answer Correct ?    9 Yes 0 No

What is a NULL value? What are the pros and cons of using NULLS?..

Answer / sunil1405

A null value indicates that there is blank value in the
column field. It takes one byte of storage. Null value
requires special prog. to be handled in the app. prog

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More DB2 Interview Questions

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

i want to delete 20th million record how ?

4 Answers   IBM,

Is ibm db2 open source?

0 Answers  

How is the SUBSTR keyword used in sql?

1 Answers  

How to create db2 table in mainframe?

0 Answers  

What is ibm db2 client?

0 Answers  

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

What is a db2 cursor?

0 Answers