I need to read a file, the file has a table in it. From the table I need to choose all the rows for which AVG 2 value is greater than 0.050 and write them on to a separate file. Please help me with the TCL script for this.
Hi,
I am trying to run the following in my tcl script---
set ul *//;s/*$//;/^$/d;s/^/"20080401 09:43:08.770798,/;s/$/"/;s/,/","/g} | \
/bin/awk -F, {{print $1","$2","$3","$4","$5}} | \
sed '1i\
REPORT.TIMESTAMP.s,REPORT.CUSTOMER.s,REPORT.CODE.s,REPORT.A_CODE.s,REPORT.DESCRIPTION.s' \
>... (2 Replies)
Hi Seniors,
Need a help from your end. I am new to scripting and still in the learning process of scripting. I have written a script on TCL TK.
This is the script that i have written.
if { $EssEntityType == "rss_user" && $EssAction == "Insert" } {
puts $fp " Ess Action :$EssAction"
... (0 Replies)
Hello,
I write a TCL script for Expect/ Telnet.
I want to send command to the telnet server.
But I want to close after the command is sent.
Anybody know which command can flush the expect so I can sure the command is sent to the telnet server???
EX:
send "./command1\r"
close... (0 Replies)
hello everyone
i am beginner on shell scripting .and i am working on my project work on ad hoc network
i wrote a batch (.sh) to do a looping and execute a tcl script i wrote before in each iteration ..but i got this problem "
syntax error near unexpected token `('... (1 Reply)
Dear Users
I'm struck by while the following tcl script.
foreach l {
set w($l) {}
set fsum 0
foreach ftemp $f($l) {
set fsum
lappend w($l) $fsum
}
}
It shows me error as "missing operand at _@_
in expression "0.10308400000000001 + _@_* 0.4 * 1"
... (0 Replies)
Hi All,
I am searching for two string in the .log file
The strings are
Active Flop-Maps "0 0 1 0 1" 1
and
Ouput-Maps " 0 0 1 1 0" 2
It should search in the file ignoring white spaces .Tell me what is wrong with this script.
The tcl script is as follows
proc proc2 {arglist} {
... (2 Replies)
Hi All,
I have a string
re_em="NODE_NAME=ABCDEF;NODE_TYPE=ghijkl;CIRCLE=jkl;Serving_Circle=abcdefghthjk;DOMAIN_TYPE=1234;REGION=12345;ZONE=12334;SOURCE_TYPE=dhfkdkfjdjf"
I want to split this string and convert it into array so that i can easily access any value like NODE_NAME or... (2 Replies)
I have csh script and call tck command but it do nothing. can you help me?
I only can see it echo
#!/bin/csh -f
set mypath = `pwd`
echo $mypath
if ($mypath =~ *PLL*) then
echo "source ../PreBoot.qel"
else if ($mypath !~ *PLL*) then
echo "source ../hdfuse.qel"
endif
if i remove... (1 Reply)
In a tcl script I need to find a way of reading a file, and looking for a phrase ("set myvariable") and putting the word following that into a variable.
I've used a file open, and a while loop with gets to read each line from the file into a variable, and using regexp searched for the item. I'm... (1 Reply)
Hi All ,
I am having a file as stated below
File 1
chain = chan6 group = grp0 input = '/pad_pc10' output = '/pad_pb7' length = 9900
chain = chan2 group = grp0 input = '/pad_pa4' output = '/pad_pb12' length = 10000
chain = chan7 group = grp0 input = '/pad_pb2' output =... (1 Reply)
Discussion started by: kshitij
1 Replies
LEARN ABOUT REDHAT
update
UPDATE(7) SQL Commands UPDATE(7)NAME
UPDATE - update rows of a table
SYNOPSIS
UPDATE [ ONLY ] table SET col = expression [, ...]
[ FROM fromlist ]
[ WHERE condition ]
INPUTS
table The name (optionally schema-qualified) of an existing table. If ONLY is specified, only that table is updated. If ONLY is not speci-
fied, the table and all its descendant tables (if any) are updated. * can be appended to the table name to indicate that descendant
tables are to be scanned, but in the current version, this is the default behavior. (In releases before 7.1, ONLY was the default
behavior.) The default can be altered by changing the SQL_INHERITANCE configuration option.
column The name of a column in table.
expression
A valid expression or value to assign to column.
fromlist
A PostgreSQL non-standard extension to allow columns from other tables to appear in the WHERE condition.
condition
Refer to the SELECT statement for a further description of the WHERE clause.
OUTPUTS
UPDATE #
Message returned if successful. The # means the number of rows updated. If # is 0 no rows are updated.
DESCRIPTION
UPDATE changes the values of the columns specified for all rows which satisfy condition. Only the columns to be modified need appear as
columns in the statement.
Array references use the same syntax found in SELECT [select(7)]. That is, either single array elements, a range of array elements or the
entire array may be replaced with a single query.
You must have write access to the table in order to modify it, as well as read access to any table whose values are mentioned in the WHERE
condition.
By default UPDATE will update tuples in the table specified and all its sub-tables. If you wish to only update the specific table men-
tioned, you should use the ONLY clause.
USAGE
Change word Drama with Dramatic on column kind:
UPDATE films
SET kind = 'Dramatic'
WHERE kind = 'Drama';
SELECT *
FROM films
WHERE kind = 'Dramatic' OR kind = 'Drama';
code | title | did | date_prod | kind | len
-------+---------------+-----+------------+----------+-------
BL101 | The Third Man | 101 | 1949-12-23 | Dramatic | 01:44
P_302 | Becket | 103 | 1964-02-03 | Dramatic | 02:28
M_401 | War and Peace | 104 | 1967-02-12 | Dramatic | 05:57
T_601 | Yojimbo | 106 | 1961-06-16 | Dramatic | 01:50
DA101 | Das Boot | 110 | 1981-11-11 | Dramatic | 02:29
COMPATIBILITY
SQL92
SQL92 defines a different syntax for the positioned UPDATE statement:
UPDATE table SET column = expression [, ...]
WHERE CURRENT OF cursor
where cursor identifies an open cursor.
SQL - Language Statements 2002-11-22 UPDATE(7)