04-26-2005
nawk '$1==p{$4=sprintf("%04d",$4+1)};1' p=PROG2 table > table
Hi if I use the command like above, the table is erased totally
nawk '$1==p{$4=sprintf("%04d",$4+1)};1' p=PROG2 table > table1
it writes into a new table table1.. then I need to overwrite table1 with table
But if two programs are running simultaneourly, I don't know, if this works fine.
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
LEARN ABOUT HPUX
xtparsetranslationtable
XtParseTranslationTable() XtParseTranslationTable()
Name
XtParseTranslationTable - compile a translation table into its internal representation.
Synopsis
XtTranslations XtParseTranslationTable(table)
String table;
Inputs
table Specifies the translation table to compile.
Returns
The compiled form of table.
Description
XtParseTranslationTable() compiles table into its opaque internal representation of type XtTranslations. This compiled form can then be
set as the value of a widget's XtNtranslations resource, or merged with a widget's existing translation table with XtAugmentTranslations()
or XtOverrideTranslations().
The syntax of the string representation of a translation table is documented in Appendix F.
If an empty translation table is required for any purpose, one can be obtained by calling XtParseTranslationTable() and passing an empty
string.
Usage
This function is generally only needed by application writers. When writing a widget, you specify a default translation table as a string,
which the Intrinsics automatically parse.
You only need to use this function when you want to set translation values from C code; translation tables specified in resource files are
automatically compiled by a resource converter.
It is also possible to set a translation table with the XtVaTypedArg feature of XtVaCreateWidget() and XtVaSetValues(). This allows you to
specify the translation table in string form, and have the appropriate resource converter automatically invoked to compile it.
The string table passed to XtParseTranslationTable can be freed after the call if there are no more explicit references to it.
See Also
XtAugmentTranslations(1), XtOverrideTranslations(1), XtUninstallTranslations(1).
Xt - Translations and Actions XtParseTranslationTable()