如何将标题行添加到通过Teradata Aster操作创建的文件中？

Question

我已经使用以下语法将Teradata Aster中的表导出到csv文件中：

\o file_name.csv
COPY table_name TO STDOUT WITH DELIMITER ',';
\o
\install file_name.csv

此代码使用从Aster表导出的数据创建一个csv。但是，它不包含标题行。数据足够大，无法通过Teradata Studio Express导出。目前，我的解决方案是在COPY后的文本编辑器中手动插入标题。我想知道是否有办法在行动中做到这一点？

Answer 1

当您首次登录ACT时，您将看到一个欢迎屏幕：

Welcome to act 06.00.00.02, the Aster nCluster Terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with act commands
       \g or terminate with semicolon to execute query
       \q to quit

您可以使用\h COPY查找COPY函数的文档。如下所示：

Command:     COPY
Description: copy data between a file and a table
Syntax:
COPY tablename [ ( column [, ...] ) ]
    FROM STDIN
    [ [ WITH ]
          [ DELIMITER [ AS ] 'delimiter' ]
          [ NULL [ AS ] 'null string' ]
          [ CSV [ QUOTE [ AS ] 'quote' ]
                [ ESCAPE [ AS ] 'escape' ] ] ]
    [ LOG ERRORS
      [ [ INTO errortablename ] [ WITH LABEL [ AS ] 'label' ] | NOWHERE ]
      [ ERRORLIMIT [ AS ] limit ]
    ]

COPY tablename [ ( column [, ...] ) ]
    TO STDOUT
    [ [ WITH ]
          [ DELIMITER [ AS ] 'delimiter' ]
          [ NULL [ AS ] 'null string' ]
          [ CSV [ QUOTE [ AS ] 'quote' ]
                [ ESCAPE [ AS ] 'escape' ] ] ]

这里没有复制标头的选项。因此，我认为您可能需要在复制后重新添加标题。