Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $conn = db2_connect ('', '', '',
- array ('i5_libl' => "ALAN",
- 'i5_naming' => DB2_I5_NAMING_ON ) )
- or die("Connection failed! ". db2_conn_errormsg());
- $sql = 'CALL SPLIB/CALL_MYPGM (?, ?)';
- $stmt = db2_prepare($conn, $sql)
- or die("<br>Prepare failed! ". db2_stmt_errormsg());
- $code = 5;
- $fname = "Frederick";
- db2_bind_param($stmt, 1, "code", DB2_PARAM_INOUT, DB2_DOUBLE, 5, 0);
- db2_bind_param($stmt, 2, "fname", DB2_PARAM_INOUT, DB2_CHAR, 10);
- print "Values of bound parameters before CALL:<br>";
- print "code: <b>{$code}</b> <br> fname: <b>{$fname}</b> <br>";
- if (db2_execute($stmt)) {
- print "<HR>Values of bound parameters after CALL:<br>";
- print "code: <b>{$code}</b> <br> fname: <b>{$fname}</b> <br>";
- }
- db2_close ( $conn );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement