Can VBNet2005 query AS/400 table structure?

  • Thread starter Thread starter ngrTerry
  • Start date Start date
N

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
 
ngrTerry said:
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
Click to expand...

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
 
Back
Top