Archives of the TeradataForum
Message Posted: Tue, 20 Jul 2004 @ 18:19:20 GMT
| Subj: | | Re: Is there an equivalent of DUAL in Teradata |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Tuesday, July 20, 2004 13:53 -->
Hello Mad,
Your comments
| | How will you do the following using teradata fast export. | |
| | select 'columnname1'||'columnname2'; | |
I was wondering why would anyone want to use a fastexport to export a single record literals? If someone really have a requirement then the
easiest way to implement that is using a derived table with SELECT DATE.
eg: SELECT 'AA'||'BB' FROM (SELECT DATE)DT(COL);
| | select something||something from something; | |
This should work in FASTEXPORT and in FASTEXPORT or SET operation you can still use SELECT without tables , but you need to qualify
databasename and tablename.
eg: SELECT databasename.tablename.columnname1||databasename.tablename.columnname2
UNION ALL
SELECT databasename.tablename.columnname3||databasename.tablename.columnname4;
| 
