Archives of the TeradataForum

Message Posted: Sun, 25 Nov 2002 @ 04:42:16 GMT

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

Madhu:

You can only use a HELP TABLE command when your input file matches your table definition exactly. In this case, it does not match.

You are not thinking about how a smallint and integer data column is stored internally. It is binary data. Obviously, because you can read it and type it, it is character data.

Your file definition should be:

Define
Empno   (char(2))
,Name  (char(12))
,PhoneNo  (char(4))
file= emp11.txt;

Mike

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