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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: