Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Aug 2004 @ 18:02:25 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Character set information
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, August 03, 2004 10:14 -->

How do we get the character set information for each column with out querying dbc.columns?



I request the prepinfo parcel for the following query

     "Sel t1.col1 , t2.col2
        from table1 t1, table2  t2".

The prepinfo parcel will have the following information for each column in resultant set. Will I be able to get in this parcel info?

     DataType:      2 bytes SmallInt
     DataLen:       2 bytes SmallInt
     ColumnName:    2 to 32 bytes VarChar
     ColumnFormat:  2 to 32 bytes VarChar     what information is available here???
     ColumnTitle:   2 to 62 bytes VarChar

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023