Easy way to get Syntax for a command in teradata

Easy way to get Syntax for a command in teradata

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');

REPLACE MACRO DBC.GetSyntax
      (
         TheFunction (CHAR(30)),
         Command  (CHAR(30))
      )
      AS
      (
         SELECT Syntax FROM SysAdmin.HelpSyntax
         WHERE TheFunction = :TheFunction AND
               Command  = :Command
         ORDER BY LineNumber;
      );