var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OS/390 varchar & COBOL
Can anyone discuss the downside to using VARCHAR in DB2 as Compared to using CHAR on the mainframe.
A few points to start ..
1) Additional processing to determine the length. - 2 extra bytes for each record, whether null or otherwise
2) Frequent updates of VARCHAR columns will lead to row overflows - performance issues
3) VARCHAR does not save space on Indexes. Indexes will be for the full length of the column. INDEX ONLY access is not possible (This is chaged in V8 - PADDED/NOT PADDED Options in CREATE INDEX)
Last edited by sathyaram_s; 02-22-06 at 17:14.
Visit the new-look IDUG Website
, register to gain access to the excellent content.