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 REDHAT
slaqgb
SLAQGB(l) ) SLAQGB(l)
NAME
SLAQGB - equilibrate a general M by N band matrix A with KL subdiagonals and KU superdiagonals using the row and scaling factors in the
vectors R and C
SYNOPSIS
SUBROUTINE SLAQGB( M, N, KL, KU, AB, LDAB, R, C, ROWCND, COLCND, AMAX, EQUED )
CHARACTER EQUED
INTEGER KL, KU, LDAB, M, N
REAL AMAX, COLCND, ROWCND
REAL AB( LDAB, * ), C( * ), R( * )
PURPOSE
SLAQGB equilibrates a general M by N band matrix A with KL subdiagonals and KU superdiagonals using the row and scaling factors in the vec-
tors R and C.
ARGUMENTS
M (input) INTEGER
The number of rows of the matrix A. M >= 0.
N (input) INTEGER
The number of columns of the matrix A. N >= 0.
KL (input) INTEGER
The number of subdiagonals within the band of A. KL >= 0.
KU (input) INTEGER
The number of superdiagonals within the band of A. KU >= 0.
AB (input/output) REAL array, dimension (LDAB,N)
On entry, the matrix A in band storage, in rows 1 to KL+KU+1. The j-th column of A is stored in the j-th column of the array AB as
follows: AB(ku+1+i-j,j) = A(i,j) for max(1,j-ku)<=i<=min(m,j+kl)
On exit, the equilibrated matrix, in the same storage format as A. See EQUED for the form of the equilibrated matrix.
LDAB (input) INTEGER
The leading dimension of the array AB. LDA >= KL+KU+1.
R (output) REAL array, dimension (M)
The row scale factors for A.
C (output) REAL array, dimension (N)
The column scale factors for A.
ROWCND (output) REAL
Ratio of the smallest R(i) to the largest R(i).
COLCND (output) REAL
Ratio of the smallest C(i) to the largest C(i).
AMAX (input) REAL
Absolute value of largest matrix entry.
EQUED (output) CHARACTER*1
Specifies the form of equilibration that was done. = 'N': No equilibration
= 'R': Row equilibration, i.e., A has been premultiplied by diag(R). = 'C': Column equilibration, i.e., A has been postmulti-
plied by diag(C). = 'B': Both row and column equilibration, i.e., A has been replaced by diag(R) * A * diag(C).
PARAMETERS
THRESH is a threshold value used to decide if row or column scaling should be done based on the ratio of the row or column scaling factors.
If ROWCND < THRESH, row scaling is done, and if COLCND < THRESH, column scaling is done.
LARGE and SMALL are threshold values used to decide if row scaling should be done based on the absolute size of the largest matrix element.
If AMAX > LARGE or AMAX < SMALL, row scaling is done.
LAPACK version 3.0 15 June 2000 SLAQGB(l)