Results 1 to 4 of 4

Thread: db2look

  1. #1
    Join Date
    Jun 2004
    Posts
    32

    Unanswered: db2look

    db2look command ?
    How do I use this ?

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    db2look is used to extract the DDL and other informations.it has many options , read it in

    IBM® DB2® Universal Database
    Command Reference


    regards,

    Mujeeb

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    You can also use:
    db2look ?
    on DB2 Command Window to see the help.

    Grofaty

  4. #4
    Join Date
    Dec 2003
    Posts
    78
    from command line processor, to get the ddl of a table, issue the following command, modifying the parameters in capslock.(username and password is the one you use connecting to the database)

    >db2look -d YOUR_DATABASENAME -t YOUR_TABLENAME -a -e -l -x -c -o ddl.out -i YOUR_USERNAME -w YOUR_PASSWORD

Posting Permissions

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