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.