Hello,
I have 2 files. File1 has data I wrote, and File2 is a file created by an application. I would like to insert the data from File1 into File2, but it has to be inserted at a certain location on File2.
I know I need to search for
"</jsp-param>
</jsp-descriptor>"
But I don't know... (4 Replies)
hi,
am new to unix can any one help me to insert data to afile to a specified
column.
ie to an output file with csv format i should insert some data to 2,3,4 fileds and the data in those fields should move to next fields
eg:
output file
asd,12,12,12,12,1,2,1,1,1,1,1... (10 Replies)
Hi All,
I enhanced a perl script that creates a table with xyz_yyyymm and insert data from xyz table before truncate xyz.I have tested it successfully in dev but when i ran it on production new table xyz_yyyymm created but did not insert any records from xyz.(No errors were thrown)The perl... (1 Reply)
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Hi all,
i have data like this
joe : 1 :a
bob : 2 :b
sue : 3 :c
foo : 4 :d
at column 2 i want to insert TOP to the top column and at column 3 i want to insert BOTTOM to the bottom column. and the result will... (12 Replies)
Hello everybody,
My problem is inserting gaussian noise to a file containing data, that is, add every single noise to the number after every 6 character.
here is my data
0910 1 2048 32.38 40 20.88 28 35.53 9.62 0.00
MSDMP0 1.790MSDMS1 2.840KCTXP2 4.400KRCMP0 4.600BOZMP0 5.640BOZMS2... (26 Replies)
Hi Am Using Unix ksh...
I have file name called FILE1
Have a content in a FILE as
11/01/2012
12/07/2012
--
--
I have used one variable
DATE=12/11/2012
I wants to insert DATE variable value at last line in a file
I need Output as cat FILE1
11/01/2012
12/07/2012
-- (2 Replies)
Hi folks
I have a script I wrote that basically parses a bunch of config and xml files works out were to add in the new content then spits out the data into a new file.
It all works - apart from the xml and config file format in the new file
with XML files the original XML (that ends up in... (2 Replies)
Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
if it is finding some data based on pattern 'test' then insert else if has no data based on the pattern 'test' then exit successfully
cat file | grep test > file2 (3 Replies)
Discussion started by: jagu
3 Replies
LEARN ABOUT PHP
db2_last_insert_id
DB2_LAST_INSERT_ID(3) 1 DB2_LAST_INSERT_ID(3)db2_last_insert_id - Returns the auto generated ID of the last insert query that successfully executed on this connectionSYNOPSIS
string db2_last_insert_id (resource $resource)
DESCRIPTION
Returns the auto generated ID of the last insert query that successfully executed on this connection.
The result of this function is not affected by any of the following:
o A single row INSERT statement with a VALUES clause for a table without an identity column.
o A multiple row INSERT statement with a VALUES clause.
o An INSERT statement with a fullselect.
o A ROLLBACK TO SAVEPOINT statement.
PARAMETERS
o $resource
- A valid connection resource as returned from db2_connect(3) or db2_pconnect(3). The value of this parameter cannot be a state-
ment resource or result set resource.
RETURN VALUES
Returns the auto generated ID of last insert query that successfully executed on this connection.
EXAMPLES
Example #1
A db2_last_insert_id(3) example
The following example shows how to return the auto generated ID of last insert query that successfully executed on this connection.
<?php
$database = "SAMPLE";
$user = "db2inst1";
$password = "ibmdb2";
$conn = db2_connect($database, $user, $password);
if($conn) {
$createTable = "CREATE TABLE lastInsertID
(id integer GENERATED BY DEFAULT AS IDENTITY, name varchar(20))";
$insertTable = "INSERT INTO lastInsertID (name) VALUES ('Temp Name')";
$stmt = @db2_exec($conn, $createTable);
/* Checking for single row inserted. */
$stmt = db2_exec($conn, $insertTable);
$ret = db2_last_insert_id($conn);
if($ret) {
echo "Last Insert ID is : " . $ret . "
";
} else {
echo "No Last insert ID.
";
}
db2_close($conn);
}
else {
echo "Connection failed.";
}
?>
The above example will output:
Last Insert ID is : 1
PHP Documentation Group DB2_LAST_INSERT_ID(3)