Skip to Content
avatar image
Former Member

downloading Tables from SE11 or SE16

Hello all,

please can someone advice whether i can easily download table details from SE11 or SE16?

i NEED EACH TABLES FIELDS, RELATIONSHIPS ETC.... is it possible?

if i cannot, can I view the relationship of a TABLE alongside the reference data?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 21, 2010 at 08:32 PM

    Koserk:

    Try the view DD03N in the SE16 transaction, and inform the tables that you need.

    Or, try to navigate through the SD11 and SE80 transactions.

    I hope this helps you.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2010 at 06:31 AM

    Hi,

    You cannot download the field details of a table directly. Even if you copy and paste, you really cannot make any sense out of 1000s of fields you are going to have in a module.

    SO you can use the whereused list to find out the relationships

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 21, 2010 at 12:33 PM

    Hello,

    please can someone advice whether i can easily download table details from SE11 or SE16?
    i NEED EACH TABLES FIELDS, RELATIONSHIPS ETC.... is it possible?
    if i cannot, can I view the relationship of a TABLE alongside the reference data?

    Please check out the below option for your question raised.

    1. You can use export command to export these data's directly from DB2.

    http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0008303.htm

    1. You can use SQVI option to export all the field of a table.

    Regards,

    Sarthak

    PS: If you query is resolved then please ensure to close the thread.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2010 at 08:30 PM

    Koserk:

    Try the view DD03L

    Add comment
    10|10000 characters needed characters exceeded