5 pts.
 AS400 System Information Through Data Access
Hi, We do a lot of AS400 system checks on a number of servers. Is there a way of using ODBC/OLE DB to access information from an AS400 concerning such commands like WRKDSKSTS (After using the F11 key to determine which ones are active), WRKSBS, QSYSOPR Messages, etc. I am trying to download this informaiton into a DB to store this information for tracking. Any help would be appreciated. Thank you

Software/Hardware used:
ASKED: November 30, 2007  7:02 AM
UPDATED: December 20, 2007  5:10 PM

Answer Wiki:
Hi Rikrawch, if you have command line access on the AS/400 you can execute each command specified and direct the output to *PRINT, then CPYSPLF to a datafile and used ODBC to retrieve the datafiles. Kevin
Last Wiki Answer Submitted:  December 20, 2007  5:10 pm  by  kevleemor   605 pts.
All Answer Wiki Contributors:  kevleemor   605 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _