Hi, can anyone explain me how this works (how the flow goes)?
Example:
CLIENT="UNIXHELP"
The second argument passed $2="UNIX"
RESULT=`awk -F"=" '/CLIENTS=/ {len = index($2,"'${CLIENT}'");print len }' $2`
Thanks in advance. (1 Reply)
hi, :)
In a shell script i came accross the following lines
1.for i in ` find /home/oracle -name ch'
2.do
3.echo $i
4.idx=`expr index $i .`
5.done
Here iam not able to understand the porpose of the word "index" in line 4.
any help ?
cheers
RRK (3 Replies)
Hi all,
I am using Legato networker for my backups, I need to restore some data from 2001.
When doing an inventory on the tape is picks up the label but under pool it says "not in media index".
When doing: nsrck -t 01Jan2002 -L7 i get the following:
nsrck: checking index for '$client'... (2 Replies)
why do inode indices starts from 1 unlike array indexes which starts from 0
its a question from "the design of unix operating system" of maurice j bach
id be glad if i get to know the answer quickly
:) (0 Replies)
brothers why inode index starts from 1 unlike array inex which starts from 0
its a question from the design of unix operating system of maurice j.bach
i need to know the answer urgently...someone help please (1 Reply)
Hi All,
I have a file (FileNames.txt) which contains the following data in it.
$ cat FileNames.txt
MYFILE17XXX208Sep191307.csv
MYFILE19XXX208Sep192124.csv
MYFILE20XXX208Sep192418.csv
MYFILE22XXX208Sep193234.csv
MYFILE21XXX208Sep193018.csv
MYFILE24XXX208Sep194053.csv... (5 Replies)
1 2 000060000
How do i return the point in the string where the 6 is?
i.e what I want on output is
1 2 5
something like awk '{print $1 $2 index($3,6) }'
but I can't get it to work
Thanks in advance (3 Replies)
HI All,
I would like to pass a integer and get all values under this index the by using awk. Could anyone help?
Thanks :>
input:
1,2,3,4,5,6,7
1,2,3,48,5,6,7
1,2,3,4,5,6,7
e.g. i pass 4 to awk command
output:
4
48
4
Video tutorial on how to use code tags in The UNIX and Linux... (8 Replies)
Hi guys,
I have postgresql server with huge amount of data, nearly 2 billion records. each record is at most 50 bytes(4 integer fields). I need to build index on all column to do fast reporting. but indexes becomes bloat after some time. almost 80% of database size is because of its huge... (0 Replies)
Hello Gents,
Please give a help with this case
Input
10001010G1
10001010G1
10001010G1
10001010G2
10001010G3
10001012G1
10001012G1
10001012G1
10001012G1
10001014G1
10001014G1
10001014G2 (5 Replies)
Discussion started by: jiam912
5 Replies
LEARN ABOUT LINUX
begin
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)