For Thanking someone on Unix.com you could HIT THANKS button at the left corner of each post.
For your other question in your previous post, I believe my same command should work, though I made a small change in it, try following and let me know then.
Hi all ..
As per rule i searched the forum i am not able found out ...
I want to display the year in when listing the files .. when i use ls -lt it is not displaying files with recent 6 month old ..
I know that perderabo has written a script for that if you give that link it will be... (3 Replies)
Hi,
When retrieving parameters of a file using ls command i need to print the year part . When i do ls -ltr the following output is displayed
-rwxrwxrwx 1 d_infd d_infd 1711 Jan 8 2004 wf1.class.
Here the year part is not displayed only Jan 8 is displayed.
Can any one... (9 Replies)
Hi All,
i want the last login details along with year.
i tried below command but not giving me the year of last login.
last <$Userid> | head -1
i heard that if it is current year then it wont display the year else it will display the year. is it so?
if yes then , is there any way of... (1 Reply)
Hi All,
i want the last login details along with year.
i tried below command but not giving me the year of last login.
last <$Userid> | head -1
i heard that if it is current year then it wont display the year else it will display the year. is it so?
if yes then , is there any way of... (1 Reply)
I know this script is crummy, but I was just messing around.. how do I get sed's insert command to allow variable expansion to show the filename?
#!/bin/bash
filename=`echo $0`
/usr/bin/sed '/#include/ {
i\
the filename is `$filename`
}' $1
exit 0 (8 Replies)
Hi Guys, I'm trying to identify the last logins by all the users in the system in AIX. the last command gives me the output, but there is no year displayed for it . Since there is a duplication of months i mean Apr 2010 and Apr 2009 also its giving me inaccurate data.. Is there a way I can filter... (4 Replies)
Hi,
Well my title isn't very clear I think. So to understand my goal:
I have a script "test1"
#!/bin/bash
xvkbd -text blabla
with xbindkeys, I bind F5 key in order it runs my test1 script
So when I press F5, test1 runs.
I'm under Emacs/Vi and I press F5 in order to have "blabla" be... (0 Replies)
What is the uptime command output when the server is running more than one year?
My doubt is whether it show in number of days format or number years and number of days format?
For example, Assume the server is running 400 days 3 hrs 3 min 3 secs. The output like 400 days 3:3 min or 1 year 5... (3 Replies)
hi all,
I use
date +%Y
which gives Current year.
Requirement: I want previous year to be printed. Please help me.
Note: I tried
date +%d/%m/%Y -d "-1 years" which is not working. (10 Replies)
Discussion started by: wasim999
10 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)