06-23-2015
thanks Aia for pointing this out. the getline should present in the BEGIN block...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
thanks for your help. I wrote this script :
# ! /bin/sh
file=snapshot.txt
cat $file | while read line ;
do
{
myvariable=`grep "Nombre de ROLLBACK internes" |sed 's/.*.=//'`
echo $myvariable
}
done
It looks in a file "snapshot.txt" for the lines containing "Nombre de ROLLBACK... (3 Replies)
Discussion started by: big123456
3 Replies
2. UNIX for Dummies Questions & Answers
Hi ,
I have 5 columns total and am wanting to search lines in columns 3-5 and basically grep -v patterns that match 'BBB_0123' 'BVG_0895' 'BSD_0987'
Does anyone know how to do this? I tried combining grep -v with grep -e but, it didn't work.
Thanks! (5 Replies)
Discussion started by: greptastic
5 Replies
3. Shell Programming and Scripting
Hello Everyone
In my shell script, I am retrieving the cluster ID and node number of an LPAR using the following command -
lsclcfg -l
This command's output looks as follows -
CLUSTER_NAME CLUSTER_ID NODE_NR
sch1h004 6104567 3
I want to store only the... (3 Replies)
Discussion started by: gates1580
3 Replies
4. Shell Programming and Scripting
Hello everyone:
I have ran into this a few times now where my skills are just not up to snuff when it comes to Unix. So, I came here to find some beard stroking Unix wizard to help me.
Basically, I am using OS X 10.5 in large scale at work and sometimes I have to run some custom reports. ... (5 Replies)
Discussion started by: tlarkin
5 Replies
5. Shell Programming and Scripting
hi , i am very new to perl . scriptting.. pllease can any one help me ...pleaseeeeeee
i ll have a file which look likes
123 |something |567
456 |welcome |789
457 |inboxpost |790
.
.
123 |something |567
i have to execute all the lines in the file except the first and the... (14 Replies)
Discussion started by: vishwakar
14 Replies
6. Shell Programming and Scripting
Hi,
I use find command to list all the files in a directory and its sub-directories, but the problem is to exclude certain directories during search. Can i give the directory names in command line to skip them and search rest of the directories?
For example i have directories:
test
../test1... (1 Reply)
Discussion started by: nmattam
1 Replies
7. Shell Programming and Scripting
hi,
how can i exclude blank line along with #, in the below command.
crontab -l|grep -v "^#" |wc -l
thx (3 Replies)
Discussion started by: bang_dba
3 Replies
8. Shell Programming and Scripting
Hi everyone,
I've really searched for a solution to this and this is what I found so far:
I need to sort a command output (here represented as a "cat file" command) and from the second down to the second-last line based on the second row and then print ALL the output with the specified section... (7 Replies)
Discussion started by: dentex
7 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a log file and want to search "0.48976360737438795" with excluding new line character.
Currently i am using the following command:
cat LogFile.log | tr -d '\n' | grep '0.48976360737438795'
This command giving me the response if file size is small but if i am using a big file... (11 Replies)
Discussion started by: ankit jain
11 Replies
10. UNIX for Dummies Questions & Answers
Hello,
I have 3 columns like shown below:
1 1800 1900
2 1765 1900
3 1654 2054
4 1326 1499
5 1540 1765
I want only those rows where column 2 and column 3's values don't fall within 1800-1900 both inclusive.
My output should only be:
4 1326 1499
5 1540 1765
Is there a quick awk... (3 Replies)
Discussion started by: Gussifinknottle
3 Replies
BEGIN(7) SQL Commands BEGIN(7)
NAME
BEGIN - start a transaction block
SYNOPSIS
BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY
DESCRIPTION
BEGIN initiates a transaction block, that is, all statements after a BEGIN command will be executed in a single transaction until an
explicit COMMIT [commit(7)] or ROLLBACK [rollback(7)] is given. By default (without BEGIN), PostgreSQL executes transactions in ``autocom-
mit'' mode, that is, each statement is executed in its own transaction and a commit is implicitly performed at the end of the statement (if
execution was successful, otherwise a rollback is done).
Statements are executed more quickly in a transaction block, because transaction start/commit requires significant CPU and disk activity.
Execution of multiple statements inside a transaction is also useful to ensure consistency when making several related changes: other ses-
sions will be unable to see the intermediate states wherein not all the related updates have been done.
If the isolation level or read/write mode is specified, the new transaction has those characteristics, as if SET TRANSACTION [set_transac-
tion(7)] was executed.
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
Refer to SET TRANSACTION [set_transaction(7)] for information on the meaning of the other parameters to this statement.
NOTES
START TRANSACTION [start_transaction(7)] has the same functionality as BEGIN.
Use COMMIT [commit(7)] or ROLLBACK [rollback(7)] to terminate a transaction block.
Issuing BEGIN when already inside a transaction block will provoke a warning message. The state of the transaction is not affected. To
nest transactions within a transaction block, use savepoints (see SAVEPOINT [savepoint(7)]).
For reasons of backwards compatibility, the commas between successive transaction_modes can be omitted.
EXAMPLES
To begin a transaction block:
BEGIN;
COMPATIBILITY
BEGIN is a PostgreSQL language extension. It is equivalent to the SQL-standard command START TRANSACTION [start_transaction(7)], whose ref-
erence page contains additional compatibility information.
Incidentally, the BEGIN key word is used for a different purpose in embedded SQL. You are advised to be careful about the transaction
semantics when porting database applications.
SEE ALSO
COMMIT [commit(7)], ROLLBACK [rollback(7)], START TRANSACTION [start_transaction(7)], SAVEPOINT [savepoint(7)]
SQL - Language Statements 2010-05-14 BEGIN(7)