Windows Command Prompt setup for DataStage Command Line

As we know that for using Datastage Command Line in Linux system, we need to setup linux shell session likewise we need to do same for Windows if server is installed on Windows server.

Follow below steps to setup your Datastage command Line ---

DATABASE Command in TeraData

When users negotiate a successful logon to Teradata, they are automatically positioned in a default database as defined by the database administrator. When an SQL request is executed, by default, it looks in the current database for all referenced objects.

There may be times when the object is not in the current database. When this happens, the user has one of two choices to resolve this situation. One solution is to qualify the name of the object along with the name of the database in which it resides. To do this, the user simply associates the database name to the object name by connecting them with a period (.) or dot as shown below:

Magic Command to BackUp Putty Sessions

1) Open Run in Windows ( Window + R )
2) Put below command in Run

Delete All PuTTY Sessions Together

When you are swapping an old computer with a new computer, you may end-up transferring all PuTTY sessions to new computer. Once you’ve transferred all PuTTY sessions, execute “putty -cleanup” from the command line as shown below.

Putty Sessions Time Out due to Inactivity

The ssh client PuTTY can be configured to maintain a connection and not time out due to inactivity.

 

To set up a new connection with "keep alives" to maintain your connection follow the steps below:

1. Open the PuTTy application and navigate to the Options panel.
2. Select Connection
3. In the field Sending null packets to keep session active change the default value from 0 to 1800 (30 minutes)

How to save User Name in Putty Sessions

1. Clicked on Any Saved Session and Load it 
2. Click Connection > Data in the Category navigation tree.

TeraData HELP command

HELP Command in Teradata plays a important role, This is something like “DESCRIBE” command in Oracle and DB2. This will display the object details.

The HELP Command is used to display information about database objects such as
●     Databases and Users
●     Tables
●     Views
●     Macros

HELP retrieves information about these objects from the Data Dictionary. Below are the syntactical options for various forms of the HELP command: