Archives of the TeradataForum

Message Posted: Fri, 25 Jul 2003 @ 15:34:03 GMT

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

You can either miss the column out of the Insert statement, or use the keyword 'NULL' in place of the parameter marker.

Insert tbl values(:a, :b, , :c)

Insert tbl values(:a, :b, NULL, :c)

This is a 'generic' response. The actual format of the parameter markers will depend on the load tool you are using.

Mike Dempsey
Teradata Client Tools

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