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
Advertisements
