Check out the following link to see the complete port list for connecting to an IBM DB2 database instance: http://www-01.ibm.com/support/docview.wss?uid=nas8N1019667
Of particular note, you'll want the "Database Access" port and the "DRDA" port, the latter seemingly used by OLEDB drivers.
Showing posts with label DB2. Show all posts
Showing posts with label DB2. Show all posts
Friday, May 26, 2017
Getting table column metadata in IBM DB2 v7.2
So here's a useful little snippet for getting column metadata for tables in IBM DB2 7.2 :
SELECT * FROM sysibm.columns WHERE TABLE_SCHEMA = 'my_schema_name' AND TABLE_NAME = 'my_table_name'
SELECT * FROM sysibm.columns WHERE TABLE_SCHEMA = 'my_schema_name' AND TABLE_NAME = 'my_table_name'
Subscribe to:
Posts (Atom)