Archives of the TeradataForum

Message Posted: Tue, 13 Jul 2004 @ 14:36:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Where does HELP COLUMN extract the FieldTitle column from for a view when TVFields.FieldTitle is NULL? Is this a case where the database goes to the table header or row header to get the information and not the dictionary?

I have placed some test SQL that should help explain what I am seeing. This is occurring on RELEASE V2R.05.00.00.11, VERSION 05.00.00.11 and RELEASE V2R05.00.02.09, VERSION 05.00.02.12.

     CREATE SET TABLE TEST.TITLE_TEST, NO FALLBACK,
       NO BEFORE JOURNAL,
       NO AFTER JOURNAL
     ( FIELD1 INTEGER NOT NULL TITLE 'TVFIELDS DISPLAYED' )
     UNIQUE PRIMARY INDEX PIDX (FIELD1);

     REPLACE VIEW TEST.TITLE_SAMPLE AS
         SEL FIELD1 (TITLE 'NOT IN TVFIELDS.FIELDTITLE')
         FROM TEST.TITLE_TEST;

     HELP COLUMN TEST.TITLE_SAMPLE.FIELD1;
     HELP COLUMN TEST.TITLE_TEST.FIELD1;

     SEL T.TVMNAME
       , T.TABLEKIND
       , C.*
     FROM   DBC.TVM      T
           ,dbc.TVFields C
     WHERE  T.DATABASEID   = C.DATABASEID
       AND  T.TVMID        = C.TABLEID
       AND T.TVMNAME IN ('TITLE_SAMPLE', 'TITLE_TEST')
     ORDER BY 1,C.FIELDID
     ;

--
Rob Paller
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>