Hi,
I have a table in Db2 with data say
id_1 phase1
id_1 phase2
id_1 phase3
id_2 phase1
id_2 phase2
I need to concatenate the values like
id_1 phase1,phase2,phase3
id_2 phase1,phase2
I tried recursive query but in vain as the length of string to be concatenated in quite long. ... (17 Replies)
hi,
I have a requirement where in I read the values from a file using awk. The resulting data should be converted into row format from column format.
For ex: My log file login.lst contains the following
SERVER1 DB1
SERVER2 DB2
SERVER3 DB3
SERVER4 DB4
I use awk to grep only the server... (6 Replies)
Hi All,
I needd to convert values in a row to a column.
eg: Input is as: value1,value2,value3,value4,.........,value N
Required Output:
Value1
Value2
Value3
.
.
.
Value N
Please help.... (3 Replies)
I have file which as 12 columns and values like this
1,2,3,4,5
a,b,c,d,e
b,c,a,e,f
a,b,e,a,h
if you see the first column has duplicate values, I need to identify (print it to console) the duplicate value (which is 'a') and also remove duplicate values like below. I could be in two... (5 Replies)
Hello,
I have a very large file for which I would like to remove all rows for which the value of columns 2-5 is zero.
For instance I would like this file:
contig1, 0, 0, 0, 0
contig2, 1, 3, 5, 0
contig3, 0, 0, 0, 0
contig4, 0, 5, 6, 7
To become this file:
contig2, 1, 3, 5,0 ... (17 Replies)
Hello guys.
Please can you help me with this.. Thanks in advance:b:
Input file
2134 6371 N
2150 6371 M
2166 6371 S
2138 6417 N
2154 6417 M
2170 6417 S
2157 6603 N
2173 6603 M
2189 6603 S
desired uotput
6371 2134N 2150M 2166S
6417 2138N 2154M 2170S... (2 Replies)
Hi ,
I have been trying to write a awk script which will have the following Output
1. Append the last Characters of the lines matching pattern xxxxxxxxx & then a space & then Append the last Characters of the lines matching pattern yyyyyyyyy
2. the process will continue till end of file &... (10 Replies)
Hi would like to ask you guys any advise regarding my problem
I have this kind of data
file.txt
111111111,20
111111111,50
222222222,70
333333333,40
444444444,10
444444444,20
I need to get this
file1.txt
111111111,70
222222222,70
333333333,40
444444444,30
using this code I can... (6 Replies)
Dear Folks
Hello
I have a column of numbers, say:
26
79
68
I want to add one to each row value and get this desire column:
26
27
79
80
68
69 (6 Replies)
Discussion started by: sajmar
6 Replies
LEARN ABOUT OPENSOLARIS
make_socksfc
MAKE_SOCKSFC(8) System Manager's Manual MAKE_SOCKSFC(8)NAME
make_socksfc - Generates frozen configuratyion file for SOCKS clients
SYNOPSIS
make_socksfc [infile [outfile] ]
DESCRIPTION
make_socksfc reads in a plain-text configuration file for the SOCKS clients and produces a frozen configuration file as the output.
Both arguments are optional. The default for infile is /etc/socks.conf; the default for outfile is /etc/socks.fc. You may specify infile
while omitting outfile, but you cannot specify outfile without also speficying infile.
The contents of the frozen configuration file is essentially the memory image of the parsed input file. Using the frozen configuration file
can reduce the start-up delay of the SOCKS client programs since they no longer have to parse the file contents.
When the SOCKS client starts, it always looks for the frozen configuration file /etc/socks.fc first . If that file is not found, it then
tries to use the plain-text configuration file /etc/socks.conf. If you use frozen configuration, you must remember to run make_socksfc
every time after you modify the plain-text file or the SOCKS clients will continue to use the frozen file of a previous configuration.
To find out the contents of a frozen configuration file, use dump_socksfc.
FILES
/etc/socks.fc, /etc/socks.conf
SEE ALSO dump_socksfc(8), socks.conf(5), socks.fc(5)AUTHOR
Ying-Da Lee, yingda@esd.sgi.com or yingda@best.com
May 6, 1996 MAKE_SOCKSFC(8)