I am trying to using pipe (|) with ! (not) operator to list all the other files except the latest two and I am using the following command.
$ ls -ltr *.lst|!(tail -2)
ksh: 20050211180252.lst: cannot execute
but it is trying to execute the file returned by tail -2. I am able to do that in 4... (8 Replies)
Hi ,
I have found a interesting thing about tail command:
when I tried to use 'tail -1 *' to look at every file with the current derectory, I only got one line of result of one file.
But if I use 'head -1 *', I would get multiple lines.
Is there a way to do get multiple lines with 'tail -1 *'... (3 Replies)
I was wondering how can I do this
I have file myfile.txt
wc -l is: 5 000 000
I have to remove first 1 000 000 lines from header..
I tryed with tail -4000000 myfile.txt>newfile.txt
but it does not work...
any help?? (2 Replies)
HI i have to copy the last 5000 lines form a log file and copy the same in the same file .overwriting the same log file.
ex: tail -5000 testfile1 > testfile2
cat testfile2
mv tesftfile2 testfile1
will produce the correct result.but i want to have this done in one line???? (4 Replies)
Please help with the following command
tail -f /appdata/logs/alert_audit517.txt | grep "Sep 02"
The problem I have is with the file name "alert_audit517.txt". The 3 digit number at the end of the file name changes, so I need the file name to use a wildcard. Ive tried alert_audit***.txt, but... (5 Replies)
Hi,
In my home directory, there are so many files. i tried to get the lastly created file by following command.
file=`ls -lrt MXOfiles* | tail -1`
As there are so many files, it displays
"$ : 0403-027 The parameter list is too long."
Can someone tell me how can i get the recent file... (1 Reply)
Hi does anyone know how to create a file using the tail command? My book has this file I need to create and it says to use the tail command and that it is possible but I have no idea. Thanks. (4 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Devise a chain of filters using some or all of the following programs pr, cut, cat, tail to
display a numbered... (8 Replies)
Hi,
I want to do file format using awk script, for that i wan to use 'tail'. Here is the scenario. I will be having set of files in a directory. Those files i need to write to another directory with same file name, but while writing the file to out directory, i need to write the last line as... (3 Replies)
Hi Team,
Can anyone help me here:
I have to access server logs via putty and these logs file is a trailing file (continously updating) with ERROR and WARNINGS... I need to know if I can pull this trailing file to a local drive so that I can do some higlighting on some keywords through Notepad... (13 Replies)
Discussion started by: jitensetia
13 Replies
LEARN ABOUT PHP
db2_rollback
DB2_ROLLBACK(3) 1 DB2_ROLLBACK(3)db2_rollback - Rolls back a transactionSYNOPSIS
bool db2_rollback (resource $connection)
DESCRIPTION
Rolls back an in-progress transaction on the specified connection resource and begins a new transaction. PHP applications normally default
to AUTOCOMMIT mode, so db2_rollback(3) normally has no effect unless AUTOCOMMIT has been turned off for the connection resource.
PARAMETERS
o $connection
- A valid database connection resource variable as returned from db2_connect(3) or db2_pconnect(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Rolling back a DELETE statement
In the following example, we count the number of rows in a table, turn off AUTOCOMMIT mode on a database connection, delete all of
the rows in the table and return the count of 0 to prove that the rows have been removed. We then issue db2_rollback(3) and return
the updated count of rows in the table to show that the number is the same as before we issued the DELETE statement. The return to
the original state of the table demonstrates that the roll back of the transaction succeeded.
<?php
$conn = db2_connect($database, $user, $password);
if ($conn) {
$stmt = db2_exec($conn, "SELECT count(*) FROM animals");
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
// Turn AUTOCOMMIT off
db2_autocommit($conn, DB2_AUTOCOMMIT_OFF);
// Delete all rows from ANIMALS
db2_exec($conn, "DELETE FROM animals");
$stmt = db2_exec($conn, "SELECT count(*) FROM animals");
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
// Roll back the DELETE statement
db2_rollback( $conn );
$stmt = db2_exec( $conn, "SELECT count(*) FROM animals" );
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
db2_close($conn);
}
?>
The above example will output:
7
0
7
SEE ALSO db2_autocommit(3), db2_commit(3).
PHP Documentation Group DB2_ROLLBACK(3)