out-of-row data

Posted in 2006

LEST MITSUI — Fri, 10 Nov 2006 15:03:38 — source: IIUG Forums & Mailing Lists

does anyone know what is meant by "out-of-row data"? The reference is in the ER doc, but I can't find a formal definition anywhere. Thanks in advance, lest

↪ replying to LEST MITSUI

Madison Pruet — Fri, 10 Nov 2006 15:13:41 — source: IIUG Forums & Mailing Lists

This consists of column data which is not physically contained in the r= ow. That would include BLOB, CLOB, BYTE, TEXT, and some UDTS. The UDT can also be called 'multi-rep'. That is the term used for vari= able lengh UDTs where they are contained in the row if small, or elsewhere (= for instance smartblobs) if large. M.P. = "LEST MITSUI" = <lester.mitsui@en = trust.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect out-of-row data [7789] = 11/10/2006 09:03 = AM = = = Please respond to = ids@iiug.org = = = does anyone know what is meant by "out-of-row data"? The reference is i= n the ER doc, but I can't find a formal definition anywhere. Thanks in advance, lest ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Madison Pruet

Lester Mitsui — Fri, 10 Nov 2006 15:25:54 — source: IIUG Forums & Mailing Lists

Thanks very much Madison. -----Original Message----- From: Madison Pruet [mailto:mpruet@us.ibm.com] Sent: November 10, 2006 10:14 AM To: lester.mitsui@entrust.com Subject: Re: out-of-row data [7790] This consists of column data which is not physically contained in the r= ow. That would include BLOB, CLOB, BYTE, TEXT, and some UDTS. The UDT can also be called 'multi-rep'. That is the term used for vari= able lengh UDTs where they are contained in the row if small, or elsewhere (= for instance smartblobs) if large. M.P. = "LEST MITSUI" = <lester.mitsui@en = trust.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect out-of-row data [7789] = 11/10/2006 09:03 = AM = = = Please respond to = ids@iiug.org = = = does anyone know what is meant by "out-of-row data"? The reference is i= n the ER doc, but I can't find a formal definition anywhere. Thanks in advance, lest ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.