Query table structure of DB2 from linked server

• goodluck

  Say Hey Kid

  Points: 677

  More actions

  September 22, 2010 at 11:28 pm

  #227168

  Hi,

  My requirement is to view the table structure of the DB2 tables thru linked server.

  I have linked server setup to access DB2 tables.

  Is there sp_columns or desc or syscolumns in DB2 which will help me acheive this?

  Any help here would be highly appreciated.

  Thanks in advance!

• Venkataraman R

  Say Hey Kid

  Points: 694

  More actions

  September 22, 2010 at 11:39 pm

  #1226080

  Hi Grasshopper,

  Please refer to this link http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002019.htm

  You can either query system catalog Syscat.Columns or use DESCRIBE command as given in the link.

  Regards,

  Venkat