04-26-2005
updating a column in a unix table for a particular row
Hi,
I have the following requirement.
I have a unix table as below
progname par1 par2 par3 par4
PROG1 abc def 0012 ooo
PROG2 wed xas 0100 xxx
PROG3 kkk ppp 0004 ppp
Different programs(ex:PROG1,PROG2..) accesses this table and update par3, corresponding to this progname... (i.e, when PROG1 is running, it updates it's corresponding par3 to 0013, similarly for other programs).. How can I achive this updation of par3 column for a particular row corresponding to that program thru shell scripting in a easy way)
After program PROG1 runs, the above table should look like
progname par1 par2 par3 par4
PROG1 abc def 0013 ooo
PROG2 wed xas 0100 xxx
PROG3 kkk ppp 0004 ppp
if PROG3 runs later then the table should look like
progname par1 par2 par3 par4
PROG1 abc def 0013 ooo
PROG2 wed xas 0100 xxx
PROG3 kkk ppp 0005 ppp
Can someone helpme out how this file column updation for a particular row can be achieved easily thru shell scripting.
Thanks for any of your inputs...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
i am having a variable declared in .profile.i am changing its value in a shell script and then i am connecting to oracle and then from there i am calling a .sql called update.sql
STATUS is the variable declared in the .profile
===============================
if
sqlplus <<END... (3 Replies)
Discussion started by: sveera
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have a requirement where in I have to connect to an Unix database server using SFTP. After connecting I have to write some data to one of the tables in UNIX.
Can anyone tell me the UNIX commands to open and update database table.
Thanks,
Pallavi (1 Reply)
Discussion started by: Pallavi_gondkar
1 Replies
3. Shell Programming and Scripting
Hello,
BC106081_abc_128240811_128241377 7.96301
BC106081_abc_128240811_128241377 39.322
BC106081_cde_128240811_128241377 1.98628
BC106081_def_128240811_128241377 -2.44492
BC106081_abc_128240811_128241377 69.5504
FLJ00075_xyz_14406_16765 -0.173417
... (3 Replies)
Discussion started by: Diya123
3 Replies
4. UNIX for Dummies Questions & Answers
Hello Everyone,
My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row.
I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table.
Please help.
Thanks &... (5 Replies)
Discussion started by: ahsan.asghar
5 Replies
5. Shell Programming and Scripting
The db2 table stores the unix path as below
PARM VALUE
RootPath $SRootDir
Target $SRootDir/target
$SRootDir is set in the env variable as /home/test/root
In the shell script i read the table value and store it in a variable
pth=db2 -x "select VALUE from... (2 Replies)
Discussion started by: 2jnags
2 Replies
6. UNIX for Dummies Questions & Answers
file with this content
awk 'NR==1 {print $4} && NR==2 {print $5}' file
The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies
7. Shell Programming and Scripting
Hi, I want to move a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).
I already use this script but doesn't work as I expected.
CHECK_KEYWORD="$( mysql -uroot -p123456 smsd -N... (7 Replies)
Discussion started by: jazzyzha
7 Replies
8. Shell Programming and Scripting
Hi, I already succeed moving a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).
But it can't delete the old row. Please help me with the script.
my php script:
INSERT INTO... (2 Replies)
Discussion started by: jazzyzha
2 Replies
9. Shell Programming and Scripting
Hello,
I need some help to reformat this table-by-row to matrix?
infile:
site1 A:o,p,q,r,s,t
site1 C:y,u
site1 T:v,w
site1 -:x,z
site2 A:p,r,t,v,w,z
site2 C:u,y
site2 G:q,s
site2 -:o,x
site3 A:o,q,s,t,u,z
site3 C:y
site3 T:v,w,x
site3 -:p,routfile:
SITE o p q r s t v u w x y... (7 Replies)
Discussion started by: yifangt
7 Replies
10. Shell Programming and Scripting
Dear folks
I have 300 files which one of them are looking like:
1.SNP
0
0
1
0
I am looking for desire output:
1.SNP 0 0 1 0
I used this below command to run all of the 300 file at the same time
for file in *.SNP; do awk '{printf( "%s ", $1 );} END {printf("\n");}' $file >... (1 Reply)
Discussion started by: sajmar
1 Replies
PON(1) Debian PPPD PON(1)
NAME
pon, poff, plog - starts up, shuts down or lists the log of PPP connections
SYNOPSIS
pon [ isp-name [ options ] ]
poff [ -r ] [ -d ] [ -c ] [ -a ] [ -h ] [ isp-name ]
plog [ arguments ]
DESCRIPTION
This manual page describes the pon, plog and poff scripts, which allow users to control PPP connections.
pon
pon, invoked without arguments, runs the /etc/ppp/ppp_on_boot file, if it exists and is executable. Otherwise, a PPP connection will be
started using configuration from /etc/ppp/peers/provider. This is the default behaviour unless an isp-name argument is given.
For instance, to use ISP configuration "myisp" run:
pon myisp
pon will then use the options file /etc/ppp/peers/myisp. You can pass additional pppd options after the ISP name, too. pon can be used to
run multiple, simultaneous PPP connections.
pon takes the following command line options:
-q --quick
disconnect when ip-up finishes running. This function is only available to the root user.
poff
poff closes a PPP connection. If more than one PPP connection exists, the one named in the argument to poff will be killed, e.g.
poff myprovider2
will terminate the connection to myprovider2, and leave the PPP connections to e.g. "myprovider1" or "myprovider3" up and running.
poff takes the following command line options:
-r causes the connection to be redialed after it is dropped.
-d toggles the state of pppd's debug option.
-c causes pppd(8) to renegotiate compression.
-a stops all running ppp connections. If the argument isp-name is given it will be ignored.
-h displays help information.
-v prints the version and exits.
If no argument is given, poff will stop or signal pppd if and only if there is exactly one running. If more than one connection is
active, it will exit with an error code of 1.
plog
plog shows you the last few lines of /var/log/ppp.log. If that file doesn't exist, it shows you the last few lines of your /var/log/syslog
file, but excluding the lines not generated by pppd. This script makes use of the tail(1) command, so arguments that can be passed to
tail(1) can also be passed to plog.
Note: the plog script can only be used by root or another system administrator in group "adm", due to security reasons. Also, to have all
pppd-generated information in one logfile, that plog can show, you need the following line in your /etc/syslog.conf file:
local2.* -/var/log/ppp.log
FILES
/etc/ppp/options
PPPd system options file.
/etc/ppp/pap-secrets
System PAP passwords file.
/etc/ppp/chap-secrets
System CHAP passwords file.
/etc/ppp/peers/
Directory holding the peer options files. The default file is called provider.
/etc/chatscripts/provider
The chat script invoked from the default /etc/ppp/peers/provider.
/var/log/ppp.log
The default PPP log file.
AUTHORS
The p-commands were written by Christoph Lameter <clameter@debian.org>. Updated and revised by Philip Hands <phil@hands.com>.
This manual was written by Othmar Pasteka <othmar@tron.at>. Modified by Rob Levin <lilo@openprojects.net>, with some extensions taken from
the old p-commands manual written by John Hasler <jhasler@debian.org>.
SEE ALSO
pppd(8), chat(8), tail(1).
Debian Project July 2000 PON(1)