AS400 Stored Procedures

Posted on 2012-08-15
Medium Priority
Last Modified: 2012-08-15
I have a stored procedure that I know works, as I can call it through iSeries Client Access.  I have my outside person calling the same procedure and getting an error.  He's using a PHP interface, which I know nothing about.  

Is there any way for me to see him coming in, along with a log of some sort?
Question by:nickmbnabb
  • 3
LVL 37

Expert Comment

ID: 38297559
which error message does he get?
usually accessing an as400 requires a middle ware like db2 connect
do you know if he uses such middle ware?
LVL 18

Accepted Solution

Dave Ford earned 2000 total points
ID: 38297630
Most likely, they're making a connection through ODBC, and that should work fine. (It certainly does for me.) You CAN use middleware like DB2 Connect, but you can also connect directly via ODBC and JDBC.

On the '400-side, you could monitor for QZDASOINIT jobs (since those typically service ODBC and JDBC jobs), but I speculate that the PHP isn't even successfully making a connection.

I'm not sure how to do this in PHP, but you should be able to monitor for a connection error and diagnose the error-message from there.


Author Comment

ID: 38297643
He's said he's getting error QZ96920C6F54463000.   ???

He is connecting to our AS400 successfully accessing a view through ODBC.

Author Comment

ID: 38297888
This is the result he's seeing:

Connection = 0x2ac6eac48b00            
Server Name = [AS400-dev][length = 9 (SQL_NTS)]            
User Name = [FIRSTSCRIB][length = 10 (SQL_NTS)]            
Authentication = [********][length = 8 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

Handle Type = 3
Input Handle = 0x2ac6eac48b00
Output Handle = 0x2ac6eac655e0
Statement = 0x2ac6eac655e0            
SQL = [call ycslibr.ycso82r ('                      ','CBHU 8073200   ')][length = 65]

Author Comment

ID: 38297933
On the '400-side, you could monitor for QZDASOINIT jobs (since those typically service ODBC and JDBC jobs), but I speculate that the PHP isn't even successfully making a connection.

I did this, found him coming in.  Thanks!

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question