Archives of the TeradataForum
Message Posted: Fri, 25 Jul 2003 @ 15:20:07 GMT
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,
0 as mou_offpeak, <---don't want a zero but want a null...what is the syntax for a null?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|