Hello:
I'm trying to view a DB2 database with a large number of tables. I'm using "Data View" (by opening a database project in MS Visual Interdev. I also tried VS.NET server explorer). The problem I'm facing is that it doesn't show all of the tables. It shows them in alphabetical order and after reaching a limit, it is cropping the view. The left hand pane (Data View/Server Explorer) in the prject window you see the database name, if you collapse it, it shows the database elements like "Tables", "Views", "Stored Procs" etc with a box and "+" sign. If I collapse the "Tables" by clicking on the "+" sign, it displays list of table names. But if I scroll down, it doesn't show all of them. Looks like there is some limitation of the viewer window itself. Because it crops the other elements ("Views", "Stored Procs" etc) too and doesn't show them at all. But if I use arrow key on the keyboard to scroll down, I can see the object names changing in the properties window (which means that in the background it has all the table names) but it doesn't show them in the data view window.
I couldn't find any way arround it. I tried changing certain configuration (Tools|Options and then select "Database Tools"
. By unchecking the "Limit SQL outpot to...".
I'd appreciate any help on how to configure it to view all of the tables or how to change the alphabetical order of the view so that if show the tables in reverse order (Z to A). Beucase the tables of my interest are towards the bottom of the list.
Thank you,
Inam
I'm trying to view a DB2 database with a large number of tables. I'm using "Data View" (by opening a database project in MS Visual Interdev. I also tried VS.NET server explorer). The problem I'm facing is that it doesn't show all of the tables. It shows them in alphabetical order and after reaching a limit, it is cropping the view. The left hand pane (Data View/Server Explorer) in the prject window you see the database name, if you collapse it, it shows the database elements like "Tables", "Views", "Stored Procs" etc with a box and "+" sign. If I collapse the "Tables" by clicking on the "+" sign, it displays list of table names. But if I scroll down, it doesn't show all of them. Looks like there is some limitation of the viewer window itself. Because it crops the other elements ("Views", "Stored Procs" etc) too and doesn't show them at all. But if I use arrow key on the keyboard to scroll down, I can see the object names changing in the properties window (which means that in the background it has all the table names) but it doesn't show them in the data view window.
I couldn't find any way arround it. I tried changing certain configuration (Tools|Options and then select "Database Tools"
. By unchecking the "Limit SQL outpot to...".I'd appreciate any help on how to configure it to view all of the tables or how to change the alphabetical order of the view so that if show the tables in reverse order (Z to A). Beucase the tables of my interest are towards the bottom of the list.
Thank you,
Inam
