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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: trmweb
  • Content: Threads
  • Order by date
  1. trmweb

    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...
  2. trmweb

    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 =...

Part and Inventory Search

Back
Top