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 Mike Lewis 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: *

  1. new2db2

    Table Size

    Thanks, one more question. Does this provide size in bytes? Thanks again for your help.
  2. new2db2

    Create table with data from subquery

    Yeah, that was my solution as well. Thanks.
  3. new2db2

    Table Size

    Is is possbile to calcuate table size from the syscat tables? If so, how would one go about doing so? Thanks!
  4. new2db2

    Create table with data from subquery

    Hey everyone, How can I create a table with a subquery that contains the structre of the query and the data? In other DBMS systems, like Teradata, I would use something like "with data" in place of "definition only". Is this possible in DB2? Thanks in advance. The below code only creates an...
  5. new2db2

    Accpac Performance Issues

    I have recently had my Accpac system migrated to a new server (PIII Xeon 2.0GHz, 1GB RAM, Raid 5 15000 RPM SCSI, Windows 2000 Server SP3 config.) to try to address speed issues. The server only has Accpac on it! It was on a PIII 850MHz, 512MB, 10,000 RPM SCSI's along with Exchange server...

Part and Inventory Search

Back
Top