Posted on 2014-10-31
I have created a php page below:
$database = 'S102MCBM';
$user = 'user';
$password = 'pwd';
$conn = db2_connect($database, $user, $password);
$stmt = db2_prepare($conn, 'CALL CHKAEON(?)');
db2_bind_param($stmt, 1, 'usrprf', DB2_PARAM_INOUT);
The code works fine when I use a SQL statement and can fill in a table fine - but when I call this stored procedure above, it doesn't seem to work. So I know the connection works. I know that the program is created as a stored procedure because I call it out of an ASP.Net page ok. I am new to php and iSeries, so maybe I have set up something wrong or am overlooking something.
Does anyone have any ideas?
Thanks in advance.