When you type HELP Session; in Teradata, you would see a row returned with values populated for the columns “User Name”,” Account Name”,” Logon Date”,” Logon Time” and the list is quite long. Most of these values can be changed with proper rights with the SET SESSION command. Remember that here we are talking about the SET Command and not the SET operator. SET commands are used to change the session (some of the session) values only. In the other hand SET operator is used to combine answer sets from multiple SELECT statements into single answer set, which is done by running two SELECT statements in parallel. UNION, INTERSECT, MINUS and EXCEPT are all SET operators. Following are some SET session commands;

To change the current database account name use,

SET SESSION ACCOUNT= ‘ new valid account ‘ FOR REQUEST;

To change the Collation use,

SET SESSION COLLATION ASCII;

To set current date format,

SET SESSION DATEFORM INTEGERDATE;

To set current export character type,

SET SESSION EXPORT FOR UNICODE DEFAULT;

Another helpful utility in Teradata is the SHOW command. When you want to see the definition for any Database objects, show command gives the output of the CREATE statement. So any object that is created by the use of CREATE statement can be seen by the help of show command. Following are a concise list of most used SHOW commands.

To see any Index definition use,

SHOW [JOIN] INDEX <Index name>;

For macro,

SHOW MACRO <macro name>;

To see the definition of a stored procedure,

SHOW PROCEDURE <procedure name>;

To see any Table definition,

SHOW TABLE <table name>;

For trigger, SHOW TRIGGER <trigger name>;

For view, SHOW VIEW <view name>;

You can even see the detail definition of an object with the following show query command

SHOW SELECT * FROM <object name>;

Our Random Articles

More Links