What is a NULL value? What are the pros and cons of using
Answers were Sorted based on User's Feedback
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
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|
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.
i want to delete 20th million record how ?
Is ibm db2 open source?
How is the SUBSTR keyword used in sql?
How to create db2 table in mainframe?
What is ibm db2 client?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
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.
what is the sqlcode -501
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is a db2 cursor?