Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DB2 Table Layout Question
Following is the SQL I used to get what I needed -- SELECT TBCREATOR, TBNAME, NAME AS COLUMN_NAME, KEYSEQ AS SEQ_#_OF_COL_IN_PK FROM SYSIBM.SYSCOLUMNS WHERE KEYSEQ > 0 AND TBNAME = 'table_name' AND TBCREATOR = 'table_creator' ORDER BY TBCREATOR, TBNAME... -
Complex Logic Question...
I appreciate the feedback. The sample code and the answers will take me to the next step. Thanks! -
DB2 Table Layout Question
staland - that is exactly what I was looking for... thanks ... you get a star! -
DB2 Table Layout Question
I'm trying to gather DB2 table/column layout information to build a data dictionary. I'm doing this on the mainframe with SPUFI because I lack third party software like BMC or Candle. I'm okay SELECTing from SYSIBM.SYSCOLUMN & SYSIBM.SYSTABLE tables. My question is - How do I determine the... -
Complex Logic Question...
code: ------------------------------------------------- SELECT M_YEAR, COUNT(*) FROM TABLE_D D WHERE D.PRODUCT_CD = 'PP' AND D.LOCATION_CD = 'ZZ' AND D.GROUP_CD = 'GG' AND D.A-ID IN (SELECT DISTINCT C.A_ID FROM TABLE_C C WHERE C.PRODUCT_CD = 'PP' AND C.LOCATION_CD =...
