Archives of the TeradataForum
Message Posted: Tue, 03 Aug 2004 @ 18:02:25 GMT
<-- 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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|