List some of the most commonly used BTEQ scripts.

1.	List some of the most commonly used BTEQ scripts.
Answer» The FOLLOWING are some COMMON BTEQ scripts: LOGON: This ALLOWS you to log in to the Teradata system. ACTIVITYCOUNT: It specifies how many rows were affected by the last query performed. ERRORCODE: This returns the status code of the last query performed. DATABASE: This sets the default database. LABEL: It specifies a label for a set of SQL commands. RUN FILE: This COMMAND executes the query contained in a file. GOTO: Turns the control over to a label. LOGOFF: This terminates all sessions and logs you off from the database. IMPORT: It specifies the path to the input file and INITIATES import to the input file. EXPORT: It specifies a path to the output file and initiates export to the output file.

Answer»

The FOLLOWING are some COMMON BTEQ scripts:

LOGON: This ALLOWS you to log in to the Teradata system.
ACTIVITYCOUNT: It specifies how many rows were affected by the last query performed.
ERRORCODE: This returns the status code of the last query performed.
DATABASE: This sets the default database.
LABEL: It specifies a label for a set of SQL commands.
RUN FILE: This COMMAND executes the query contained in a file.
GOTO: Turns the control over to a label.
LOGOFF: This terminates all sessions and logs you off from the database.
IMPORT: It specifies the path to the input file and INITIATES import to the input file.
EXPORT: It specifies a path to the output file and initiates export to the output file.

Discussion