Sponsored Content
Top Forums Shell Programming and Scripting updating a column in a unix table for a particular row Post 70109 by thanuman on Tuesday 26th of April 2005 12:12:36 AM
Old 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

updating a column in oracle table using shell script

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

Updating table on UNIX server using SFTP

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

extracting row with max column value using awk or unix

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

Shell Script: Traverse Database Table Row by Row

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

Unix path stored as a column in table

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

awk to print first row with forth column and last row with fifth column in each file

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

Moving new row and deleting old row to another table

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

In php, Moving a new row to another table and deleting old row

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

awk to convert table-by-row to matrix table

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

Using loop command in UNIX for converting column to row

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)
All times are GMT -4. The time now is 07:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy