updating a column in a unix table for a particular row Post: 70114

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...

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

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 ...

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. 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...

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

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...

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...

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...

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 >...

LEARN ABOUT REDHAT

pppoeconf

PPPOECONF(8)						      System Manager's Manual						      PPPOECONF(8)

NAME

       pppoeconf -- configures a PPPoE (ADSL) connection

SYNOPSIS

       pppoeconf [-nox]  [iface]

DESCRIPTION

       The  pppoeconf  program	is  user-friendly  dialog based setup tool for pppd (and pppoe	    if needed). It will look for existing ethernet
       cards and look for ADSL hardware connected to one of them. You can add an interface name iface to force pppoeconf to use it. Then  it  will
       get some login info and do some minor modifications to make working settings. Note that you can use ESC key to exit program when you wan.

OPTIONS

       -nox	 Force ncurses use.

FILES

       /etc/ppp/peers/dsl-provider is pppd options file for your dsl provider.

       /etc/ppp/pap-secrets and /etc/ppp/chap-secrets are described in pppd documentation.  pppoeconf may add lines to theses files.

       /etc/ppp/ip-up.d/0clampmss and /etc/ppp/ip-down.d/0clampmss are used to clamp MSS if needed.

       /etc/network/interfaces is network interface file for your system.

SEE ALSO

       pppd(8), interfaces(5), pon(1) and pppoe(8).

AUTHOR

       This  manual  page  was originally written by Eduard Bloch (blade@debian.org) and now maintained by Gregory Colpart (reg@evolix.fr) for the
       Debian GNU/Linux system (but may be used by others).  This document is free software; you can redistribute it and/or modify  it	under  the
       terms  of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option)
       any later version.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

																      PPPOECONF(8)