Can VBNet2005 query AS/400 table structure?

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

Re: Can VBNet2005 query AS/400 table structure?

"ngrTerry" wrote in message
news:1193651403.419443.257250@o3g2000hsb.googlegroups.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