 |
 |
Archives of the TeradataForum
Message Posted: Thu, 27 Aug 2015 @ 20:58:39 GMT
| Subj: | | Re: DB2 to Teradata Convertion - CHAR with DEFAULT |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | I am converting some DB2 DDLs to Teradata equivalent. For some columns in DB2 I see the following definition - | |
| | MyColumn CHAR(n) FOR SBCS DATA WITH DEFAULT; | |
| | I searched the web and found that in such cases, for a CHAR(n) field, if only the keyword "DEFAULT" is specified (without any value
specified), DB2 fills up the field with "n" number of spaces automatically. | |
It's exactly the same syntax in Teradata (without "FOR SCBS DATA"):
MyColumn CHAR(n) WITH DEFAULT
Dieter
| |
