Archives of the TeradataForum

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

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

Karen,

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.

Cheers,

Dave

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