BTEQ TERADATA

As new software DBMS in Indonesia, some of user of course still not familiar with this database, in method, script, or phisical model.

In here I will tell some common statement that frequently used :

– Show table / view / database definition

> help table/view/database name_of_object;

 

There are others tips & trick that in some case will be usefull :

  • BTEQ export

How to remove special character in export result (such as ^O,^M, etc)

give ‘ .SET INDICDATA OFF ‘ in beginning of export script

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: