Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: OS/390 varchar & COBOL

    Can anyone discuss the downside to using VARCHAR in DB2 as Compared to using CHAR on the mainframe.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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 18:14.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •