Search found 7 matches

by john2770
Fri Jan 15, 2016 4:53 pm
Forum: PHP Questions / Hints
Topic: Update multiple tables db2 store procedure
Replies: 2
Views: 3524

Re: Update multiple tables db2 store procedure

Is this validate to update 2 tables in a store procedure -- update the description. if errmsg = ' ' and inDescription <> '*SAME' then update prmast a set ( prdes1, prdes2 ) = ( substr(inDescription,1,35), substr(inDescription,36,35)) where a.prcucd = cucode and a.prprcd = prodCode ; end if ; -- upda...
by john2770
Mon Jan 11, 2016 8:05 pm
Forum: PHP Questions / Hints
Topic: Update multiple tables db2 store procedure
Replies: 2
Views: 3524

Update multiple tables db2 store procedure

Is there a way that i can update multiple tables in a db2 store procedure, if so how can i achieve this?
by john2770
Mon Oct 19, 2015 8:29 pm
Forum: PHP
Topic: PHPReport and Stored Procedure
Replies: 1
Views: 2200

Re: PHPReport and Stored Procedure

I troubleshooted and it came down to the 'db2_execute($stmt);' doesn't run it fails. How can i solve this problem?
by john2770
Mon Oct 19, 2015 7:22 pm
Forum: PHP
Topic: PHPReport and Stored Procedure
Replies: 1
Views: 2200

PHPReport and Stored Procedure

I'm trying to run my PHPReport script with my Stored Procedure Results, everything seems okay but i'm getting not results in my view the code is below <?php include '@ConnectDB.php' ; include './includes/PHPReport.php'; $inCucode = "GLLL01"; $inProdCode = "71MRT18818W"; $inBuyNum = "NONS01"; // Prep...
by john2770
Fri Oct 16, 2015 9:03 pm
Forum: Zend Framework
Topic: PHP report tool/library/plugin for ZendFramework 2
Replies: 0
Views: 1243

PHP report tool/library/plugin for ZendFramework 2

Hi, is there's any reporting library for ZendFramework 2 with PHP and if so what are they
by john2770
Wed Oct 07, 2015 7:18 pm
Forum: PHP Questions / Hints
Topic: PHP 'db2_prepare failed' error
Replies: 3
Views: 3743

Re: PHP 'db2_prepare failed' error

This is all it displays "error code and message?" Yes it is on the same server. Yes it is the same user connecting, this is the connection script $conn = db2_connect("*LOCAL", '', ''); if ($conn) { echo "<!- Connection succeeded. -><br>\n"; } else { echo "<!- Connection failed. -><br>\n"; }
by john2770
Wed Oct 07, 2015 5:14 pm
Forum: PHP Questions / Hints
Topic: PHP 'db2_prepare failed' error
Replies: 3
Views: 3743

PHP 'db2_prepare failed' error

I'm using PHP with IBMi that uses db2. I have store procedure that in a testProcedure.php code is below: <?php $inCuCode = "GLLL01"; $inProdCode = "71MRT18818WX"; $inBuyNum = "BUNZLS"; // Prepare Stored Procedure call // $proc = 'CALL WLKLIB.DSH3518SQ(?,?,?)'; $stmt = db2_prepare($conn, $proc) or di...