Results 1 to 9 of 9

Thread: db2 help

  1. #1
    Join Date
    Jan 2004
    Location
    hyderabad
    Posts
    10

    Unanswered: db2 help

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    456
    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

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You should also visit www7b.boulder.ibm.com/dmdd

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Sep 2002
    Posts
    456

    Re: db2 help

    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
    Originally posted by ramakrishna
    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

  5. #5
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    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

  6. #6
    Join Date
    Jan 2004
    Location
    hyderabad
    Posts
    10

    how to set editor

    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

  7. #7
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Re: how to set editor

    Originally posted by ramakrishna
    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
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  8. #8
    Join Date
    Sep 2003
    Posts
    237
    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.
    mota

  9. #9
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61
    Originally posted by dbamota
    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
    Last edited by hanyheggy; 02-11-04 at 12:18.
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •