Home > IT Answers > AS/400 > AS400 System Information Through Data Access
Rjkrawch
5 pts.
 AS400 System Information Through Data Access
AS/400, Automation, ODBC, OLE DB, QSYSOPR, VB, WRKDSKSTS, WRKSBS
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
RELATED QUESTIONS
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.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _