I have no experience with AIX, but it seems you have a very ancient awk that doesn't understand BEGIN.
I find that difficult to believe since the first version of awk supported BEGIN and END (they had very specific requirements on placement with regard to other rules, but they were supported).
It's hard to say, because the original post didn't include code tags, but it looks like there is no space between the BEGIN and the opening curly brace. While I wouldn't expect that to cause an issue, that's the only thing that seems like it might be trouble. Try adding a space:
There is also no need for the end block if it's empty.
Here is the command I want to run:
for pkg in `pkginfo | grep -i VRTS | awk '{print $2}'`; do showrev -p | grep $pkg; done | awk '{print $2 "\t" $7}' | uniq
It returns the package info in a form such as:
113210-03 VRTSfspro
112392-06 VRTSvmman
113596-03 VRTSvmpro... (1 Reply)
Hi Everyone,
I am required to write an AWK script that can be run from any directory.
This script finds subscription rates for each subscriber at an interval of 10 mins. I want that just by copy pasting the whole script in shell prompt and giving the input arguments, script must work. Currenty... (4 Replies)
I have the following sample script to run a script the jobs with the same
priority(in this case field3) in parallel; wait for the jobs to finish
and run the next set of jobs in parallel.When all the lines are read
exit the script.
I have the following script which is doing evrything I want... (1 Reply)
Hi All,
I'm new here.
i was wondering if anyone could shed a light on the problem i am having.
I use a system for distributing broadband amongst users of for example a hotel, the system was designed by someone in the US and it is based on redhat 2.4 (i know its old) and the system uses... (3 Replies)
Hi All,
I am trying to understand why my system is running at very high. This system is almost out of memory. See below.
swapon -s
Filename Type Size Used Priority
/dev/mapper/VolGroup00-LogVol02 partition 8388600 8235088 -1... (2 Replies)
I have a script that runs on an AIX 5.3.10.0. It runs perfectly on days that are double digit numbers, but from the 1st to the 9th of the month it runs but does not report anything.
The command in the script is as follows:
awk -v d=$(date '+%b%d') '/user:warn/ && /has shutdown/ && ($1$2 ==... (2 Replies)
Hi guys I have a problem with one module of my script. It's awk script running in pbs file - It's working when I make a call from pbs to separate awk only file like this but when I try to execute this code in pbs file it fails
awk 'BEGIN { max = -1000; min = 1000 }
{
{$4 == "TCO"}
... (2 Replies)
Hi,
I am trying to run a cronjob. But while doing so I am getting the following error message :-
can't open yourfile in /var/spool/cron/crontabs directory.
No such file or directory
How can I resolve this issue ?
Please help.
Thanks
Please view this code tag video for... (14 Replies)
Hello to all,
May be some expert could help me.
I have the below awk script that works correctly in Cygwin:
awk -F\" 'FNR==NR && FNR>1 {gsub(",","",$5); N=$5;next}
$10 in N && FNR>1 {
Y=$8
Z=(N==$8)?"Yes:"No";
}
END{
for(k in N) {print k,Y,N,Z?Z:"Not_Found"}
}' file2 file1But when I... (11 Replies)
Discussion started by: Ophiuchus
11 Replies
LEARN ABOUT DEBIAN
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)