Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2012
    Posts
    2

    Unanswered: Project Layout for DB2

    Just finished a mobile application project, using Access Database. One Laptop has mobile application & 2nd server application.
    These 2 Laptops are on a WIFI network. Now started a project to migrate server application to DB2. Already downloaded
    IBM DB2 10.1 & Data Studio 3.1.1 Administration Client. Being 1st attempt gone thru many subject on Google search & ibm.com.
    Tried a test, and exported few tables to DB2 database as shown in attached Fig 1 .


    Come up with my concept of application databases in default instant DB2 as shown in attached layout, Fig2 DB2 Project Layout


    In view of above,
    I would like to know 1) Inherent constrain & flaws of this Project Layout. 2) Tables-TIM1 to TIM9 & TIN1 to TIN8
    How to create them, I did not think Declare Globule Temporary Table is the right way & I do not want to consume large table space where it is not required.
    Attached Thumbnails Attached Thumbnails Fig1_Test_Snapshot.jpg   Fig2_DB2 Project_Layout.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •