I need help :)
I have two input files and I'd like to generate a report based on the two.
filea:
hostname,account1,password
,account2,password
hostname,account1,password
hostname,account1,password
,account1,password
,account2,password
repeating hostnames are blank
fileb:
hosta... (7 Replies)
Hi,
I have several block of text that I need to select, however this text may be spread over several lines and contains the '{' and '}' within it.
For e.g.,
ABC=100{
DEF = 200
{
GHI,
JKL
}
}
#2nd Block
123
{
456{78,910}}
}I am trying to figure out how to remove... (2 Replies)
Hi,
I have a requirement to select only a specific pattern from a flat file and delete its occurance.
For eg.
If my file contains :
<A1>1234</A1>
<A2>5678</A2>
<ABC>1234</ABC>
<A3>0987</A3>
Then, i want to delete <ABC>1234</ABC> from the file and have the contents as :-... (7 Replies)
Hi there, I have a text file with several colums separated by "|;#" I need to search the file extracting all columns starting with the value of "1" or "2" saving in a separate file just the first 7 columns of each row maching the criteria, with replacement of the saparators in the nearly created... (4 Replies)
Hi,
Following is my file output
247 Sleep 25439 NULL
259 Sleep 25460 NULL
277 Sleep 15274 NULL
361 Sleep 2 NULL
362 Sleep 202 NULL
I want to select only first column to other file
How can... (2 Replies)
Hi
I want to select older file if multiple files exist with same name.
eg:There are five files in UNIX folder
Sample1_20091231
Sample1_20100110
Sample1_20100115
Sample2_20100115
Sample3_20100115
However in file list i.e FileName.DAT I have data like
Sample1
Sample2
Sample3
I am... (5 Replies)
Hello:
I am new to shell script programming. Now I would like to select specific records block from a file. For example, current file "xyz.txt" is containing 1million records and want to select the block of records from line number 50000 to 100000 and save into a file. Can anyone suggest me how... (3 Replies)
Hi ,
I want to select data from a file .the datas in a file will be in both upper and lower case. can able to select particular data using awk.
file is like
Ram Selva 24332 UNIXTEAM
Karthi Siva 43322 UNIXTEAM
In read if i enter selva as lowercase its not displaying result. (9 Replies)
Hello,
I use UBUNTU 12.04.
I want to write a short program using awk to select some lines in a file based on a second file.
My first file has this format with about 400,000 lines and 47 fields:
SNP1 1 12.1
SNP2 1 13.2
SNP3 1 45.2
SNP4 1 23.4
My second file has this format:
SNP2
SNP3... (1 Reply)
i have a file tabel.out which contain table name in this format.
xyz
abc
qwe
Plz help me writing one script which actually takes tablename from file table.out file one by one and then select count (*) from $tablename limit 10; and print error in output file if any tabel is not... (4 Replies)
Discussion started by: netdbaind
4 Replies
LEARN ABOUT SUSE
start_transaction
START TRANSACTION(7) SQL Commands START TRANSACTION(7)NAME
START TRANSACTION - start a transaction block
SYNOPSIS
START TRANSACTION [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY
DESCRIPTION
This command begins a new transaction block. If the isolation level or read/write mode is specified, the new transaction has those charac-
teristics, as if SET TRANSACTION [set_transaction(7)] was executed. This is the same as the BEGIN [begin(7)] command.
PARAMETERS
Refer to SET TRANSACTION [set_transaction(7)] for information on the meaning of the parameters to this statement.
COMPATIBILITY
In the standard, it is not necessary to issue START TRANSACTION to start a transaction block: any SQL command implicitly begins a block.
PostgreSQL's behavior can be seen as implicitly issuing a COMMIT after each command that does not follow START TRANSACTION (or BEGIN), and
it is therefore often called ``autocommit''. Other relational database systems might offer an autocommit feature as a convenience.
The SQL standard requires commas between successive transaction_modes, but for historical reasons PostgreSQL allows the commas to be omit-
ted.
See also the compatibility section of SET TRANSACTION [set_transaction(7)].
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)], SAVEPOINT [savepoint(7)], SET TRANSACTION [set_transaction(7)]
SQL - Language Statements 2010-05-14 START TRANSACTION(7)