Home > IT Answers > AS/400 > AS400 System Information Through Data Access
Help

Question

  Asked: Nov 30 2007   7:02 AM GMT
  Asked by: Rjkrawch

AS400 System Information Through Data Access


AS/400, WRKDSKSTS, VB, Automation, ODBC, OLE DB, WRKSBS, QSYSOPR

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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Dec 20 2007  5:10 PM GMT  by Kevleemor




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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400, Development and Database.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register