Oh, you mean this?
http://php.net/manual/en/function.db2-last-insert-id.php
Regards,
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 2:59 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 have solved my problem by going back to an old method I used until MySQL
got smart and offered up insert_id "Returns the auto generated id used in
the last query."
I wished DB2 had something like this...
But until then... here is my solution...
if ( Connect2DB() )
{
// Create Record With Target In Agent Field
$sTarget = md5( date( 'ymdHis' ).$sIP ) ;
$rResult = RunQuery( 'INSERT INTO '.$sSchema.'zTest ( Agent ) VALUES (
\''.$sTarget.'\' );' ) ;
// Retrieve Auto Incremented ID
$rResult = RunQuery( 'SELECT ID FROM '.$sSchema.'zTest WHERE Agent =
\''.$sTarget.'\' ;' ) ;
$aRow = db2_fetch_assoc( $rResult ) ;
LogIt( 'New ID: '.$aRow[ 'ID' ] ) ;
// Update Record With Accurate Data
$rResult = RunQuery( 'UPDATE '.$sSchema.'zTest SET '.$sSets.' WHERE ID
= '.$aRow[ 'ID' ].' ;' ) ;
db2_close( $_SESSION[ 'DB' ] ) ;
}
With MySQLi this is as simple as:
$oDB->query( INSERT INTO MyTable SET Clmn='Data' ) ; $nID =
$oDB->insert_id ;
*** So does DB2 support INSERT INTO MyTable SET fld=val, fld=val
or only INSERT INTO MyTable ( Fields ) VALUES ( Values )
So I have spent almost 2 days fighting this one thing.
On 2015-12-04 12:24, Buck Calabro wrote:
On 12/4/2015 1:00 PM, Rob wrote:
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.
Unless I deeply misunderstand something, you still do not have a table
which is journaled. In order to journal a table, one needs to:
1) Issue STRJRNPF against it - see your system admins!
2) Create the table in a schema which in turn was created with the SQL
CREATE SCHEMA statement. This schema will automatically journal
tables created within it.
This may not turn out to be the issue for this particular problem, but
it is useful to know, so I'm leaving it here for the archives.
---
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.
midrange.com
