Can VBNet2005 query AS/400 table structure?

[ngrTerry]

I need an app which will go to a library on the AS/400 and then give
me a list of tables that are in there.

I then want fo go through the tables and retrieve the structure of
those tables.

So something like

For each Table in Library
for each field in table
get the properties of that field - ie number 5,2 = 5 digits
- 2 decimal places
Does anyone know if this can be achieved and supply any code ideas

Many thanks in advance

|Terry

[Mr. Arnold]

"ngrTerry" <ng*@tdrd.karoo.co.ukwrote in message
news:11**********************@o3g2000hsb.googlegro ups.com...

>I need an app which will go to a library on the AS/400 and then give
me a list of tables that are in there.

I then want fo go through the tables and retrieve the structure of
those tables.

So something like

For each Table in Library
for each field in table
get the properties of that field - ie number 5,2 = 5 digits
- 2 decimal places
Does anyone know if this can be achieved and supply any code ideas

I could be wrong, but I think you may want to look-up .Net BizTalk server,
which will allow the access of data on another platform such as AS400 by
..Net solutions. I don't think you can access something directly on AS400
without some kind of bridging technology like BizTalk. The key to Biztalk is
the usage of XML between the MS and IBM platforms.
..
http://en.wikipedia.org/wiki/Microsoft_BizTalk_Server