Archives of the TeradataForum
Message Posted: Tue, 18 Mar 2003 @ 21:40:07 GMT
| Subj: || || Re: Storing userid into table field |
| From: || || Jim Downey |
I use the following DDL to accomplish what you are trying to do. Note that when I first implemented this, I had the column set to
VARCHAR(8) because the userids I knew were 8 characters or less. If you inserted with a userid longer than 8 characters, the database
restarted. That's right, the database restarted.
Metadata_Loaded_By_Userid VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT USER ,