hi all

i am new to db2 environment. I am currently working on oracle9i I like to know couple of things how to get info from db2 like

what is describle command alternative in db2 ---- to know the structure of the table and its datatypes which we use in oracle.

how to set editor i want the syntax and in which window to execute it.

plz help for these.


bye
ramakrishna

Here is the link to DB2 technical library for V8, V7 and other documents..

http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

hope this helps.

dollar

You should also visit www7b.boulder.ibm.com/dmdd

Cheers
Sathyaram

another way to get help once you are in DB2 command window is:

db2 ? string

where string could be something like import or export or connect or list etc...

dollar

ramakrishana.


for describe structue

db2 describe table creator.tablename

db2 ? load
db2 ? export
db2 ? import

which version db2 are U using

for more info refer below link

for DB2 UDB V8

http://www-306.ibm.com/cgi-bin/db2ww...bs.d2w/en_main


for DB2 UDB V7.x

http://www-306.ibm.com/cgi-bin/db2ww...bs.d2w/en_main


let me know , if any questions


Lekharaju Ennam

hi ,

thanx for the solution u provided for describing a table. I am using db2 v8 . I also want to know how to set editor as notepad which environment variable i need to work and in which window i need to do it .

who is the super user in db2
bye
ramakrishna

if u install db2 documentation correctly, db2 help can be accessed by db2help on UNIX systems , this will provide a web browser with html help for all document and manuals

u still can use db2 ? xxxx

or download DB2 PDF manauls form ibm web site its free

the db2inst1 is the super user in db2, this can be defined when u create the instance or install db2

In Oracle SQL you talk to SQLPLUS processor which interphases your sql to the server; you can set up an editor to edit the current command in sqlplus. In db2, each sql is an OperatingSystem command. If you want, write a bunch of sql commands, all ending in ';' in a notepad
called xyz.txt; then db2 -tf xyz.txt will read from this file(like @xyz.sql in oracle)using -o option you can spool etc. Type db2 "? options" or db2 "? help" to get more details. " is needed in some UNIX environments for certain commands. You can edit xyz.txt and rerun it.

there are many ways to issue commads to db2

1. using db2 CLP
from command line > db2
u will get text interface (like ORACLE sqlplus) then issue whatever u wanna

2. using system call for single command
from command line > db2 " bla bla bla "

3. using system call with files
group all commands u wanna in a file xx.xx
db2 -stf xx.xx

4. using programs
embeded sql in any prog. lang.

5. using DB2 GUI tools like command center