Archives of the TeradataForum

Message Posted: Fri, 25 Jul 2003 @ 15:20:07 GMT

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

We have a SAS dataset that we are inserting into teradata that does not contain several columns defined on the table. What is the syntax to hard code that column as a null? I don't want the column to be a zero like this:

table ddl for column:

mou_offpeak INTEGER DEFAULT NULL COMPRESS 0,

insert sql:

0 as mou_offpeak, <---don't want a zero but want a null...what is the syntax for a null?

Thanks,

Bruce

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