skip to main
|
skip to sidebar
Techie_FAQ
Tuesday, April 17, 2007
DB2: How does DB2 store NULL physically?
as an extra-byte prefix to the column value.
The NULL prefix is Hex '00' if value other than NULL is present in the column.
The NULL prefix is Hex 'FF' if the column has NULL value.
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2009
(5)
►
December
(1)
LISTCAT command
►
September
(1)
Sort JCL - to replace 1st 2 characters
►
July
(3)
REXX: Parsing a stream with a delimiter
Listing datasets - ISPF command
REXX builtin function - WORDPOS
►
2008
(4)
►
November
(1)
Error message in IDCAMS step
►
August
(2)
PLI- %REPLACE
PLI - ONCODE built in function
►
January
(1)
What is CATMAINT utility
▼
2007
(29)
►
December
(4)
IBM1936I S Invocation of compiler backend ended ab...
REXX - TRACE command
How do I test a ISPF panel?
ISRROUTE - ISPF command
►
November
(1)
DB2 datatype - DATE
►
October
(1)
RECFM for Print files
►
August
(4)
COND=ONLY in JCL
COND=EVEN in JCL
SQLCODE = 562
Handling NULL in the program
►
July
(5)
Packed datasets
Abend S013
SQLCODE = -204
SQLCODE = -679
SQL : Error handling : WHENEVER stmt
►
June
(1)
PLI: ENVIRONMENT(CTLASA)
►
May
(2)
SQLCODE = -401 SQLSTATE= 42818
SQLCODE = -181 SQLSTATE=22007
▼
April
(5)
SQLCODE = -180 SQLSTATE= 22007
SQLCODE = -117
SQLCODE = -102
DB2: How does DB2 store NULL physically?
Common abends
►
January
(6)
What is Unicode?
What is an encoding scheme?
What is CCSID - Coded Character Set IDentifier?
What are Code pages?
What are Code points?
SQLCODE -922
►
2006
(34)
►
November
(2)
IDCAMS - skip
To find the version
►
October
(1)
SQLCODE=-30080 / -904 - Conversation failure recov...
►
September
(1)
VERIFY in PL/1
►
August
(2)
System Abend: 0E37
System 806 Abend
►
July
(1)
SQLCODE -927
►
June
(27)
DB2: Fun with dates and times
DYNAMNBR parm
Article on DBRM/Bind
DB2 V8 Multiple DISTINCT clauses
Quiesce tablespace
About Me
Anu
This is a civil engineer plunged into Software.. Growing with IBM India since I boarded my professional life
View my complete profile
0 comments:
Post a Comment