To get syntax for a command in teradata

After logging on to teradata through bteq/Sql assistant

type the following command

exec dbc.getsyntax('sql','create table');

getsyntax is a macro that accepts 2 parameters.

First parameter is the type of utility that the command belongs to.

valid values includes the following.

PMPC

BULKLOAD

DUMP

ARCHIVE

MULTILOAD

VERSION

SPL

FASTEXPORT

DATA_TYPE

HELP

SQL

FASTLOAD

TPCCONS

Second parameter the command name for which we need to find the syntax.

examples includes:

exec dbc.getsyntax('FASTLOAD','DEFINE');

exec dbc.getsyntax('MULTILOAD','.IMPORT');

exec dbc.getsyntax('SQL','UPDATE');