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 [...]

Answer Question   |  December 20, 2007  7:02 AM
AS/400, Automation, ODBC, OLE DB, QSYSOPR, VB, WRKDSKSTS, WRKSBS

opening crystal report using ISeries sql error Temp table already exists
I built an sql stored procedure on the ISeries using ISeries Navigator. The procdure returns a good result set using a couple of global temporary tables from other stored procedures I call. When I try to access the stored procedure using Crystal X1, I get an obdc error telling me the temp table already exists. [...]

Answer Question   |  December 13, 2007  8:20 PM
Crystal Reports, iSeries, ODBC