|
Did you add the diagnostic functions (db2_stmt_error() db2_stmtm_errmsg())
to your code? What do they say?
Mike Pavlak
Cell: (408)679-1011 Office: (708)233-5880
-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Sent: Friday, December 04, 2015 12:01 PM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Query Fails In PHP db2_exec But Is Good in System I
Navigator.
I did notice that when I created the tables in SiN...( Sounds funny )..
that it reported that the tables would not be journaled.
I have since gone into SiN and dropped the table.
I then created the table from the PHP script.
Mike Paviak suggested I change the credentials of the table. I do not
know how to do that at the moment... So I figured if I create the table
using PHP... it would have the same credentials as the PHP script.
No JOY!
I have changed single quotes to double quotes... Still NO JOY!
I am back... took a moment to get some more head bangs on my desk!
I was about to strip the outer select meant to retrieve the ID of the
record just inserted. and test again.
On 2015-12-04 11:54, Buck Calabro wrote:
On 12/4/2015 11:34 AM, Rob wrote:
if ( $oDB = db2_pconnect( '', '', '', array( 'i5_naming' =>Very often, newcomers to our platform are surprised by journaling and
DB2_I5_NAMING_OFF ) ) )
commitment control. Rather, they are surprised at the lack thereof.
It is possible that iNavigator is set to COMMIT(*NONE), but I don't
see anything like that in the PHP connexion string, so the default
would be to perform table I/O under commitment control. If
MyLibrary.zTest is not journaled, then it is impossible to perform I/O
to it under commitment control.
The typical choices are:
1) Journal the table so COMMIT and ROLLBACK work as expected.
2) Tell PHP that you want to operate with no commitment control, so
INSERT ... WITH NC
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.