Archives of the TeradataForum
Message Posted: Wed, 11 Aug 2010 @ 12:45:55 GMT
| Subj: || || TTU13 - SQL Assistant - Saving Duplicate Columns to Access |
| From: || || Threlfall, Dave |
We have upgraded from TTU8.2 to TTU13 and previously if two or more tables had been linked and therefore both contained the AGRMNT_ID field, on
exporting a select * query both AGRMNT_ID columns were exported and the duplicate column was renamed in Access to field8 , for example. Now the
data just won t export at all the only way to get around this is to individually list all field names to be exported and remove the duplicate
Is this a known problem or are there any settings in Teradata that I need to change?