Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Sep 2003 @ 23:34:11 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Column data width
From:   David Wellman


It depends how your application requetsed the data to be returned (seriously!).

When writing a program, you can request that Teradata return the data in one of three modes, Field, Record and Indicator. Record and Indicator modes will return a FLOAT in the client system's internal representation - which will typically be an 8-byte field. Field mode (which BTEQ uses by default) tells Teradata to convert everything to character format so a FLOAT could well be 13 bytes or longer.

As I said, BTEQ uses Field mode by default, this can be changed using the ".SET RECORD" or ".SET INDICDATA" commands. The ODBC driver uses Indicator mode.

And then of course you have to check the SQL request itself. Even if your application is running in Record mode, if you CAST the Float column to CHAR(22) it will send back a 22-byte field.

The CLI v2 manuals (one for Mainframe and one for Network clients) discusses "Response Mode" in more detail.



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