09-21-2011
Hello Rajesh,
Where is the problem now?,, did you give a try?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Forum,
I am struggling with the for loop in shell script.
Let me explain what is needed in the script.
I have a file which will conatin some strings like
file1
place1
place2
place3
checkpoint
some other text
some more text
Now what my requirement is
the words ... (2 Replies)
Discussion started by: siri_14
2 Replies
2. Shell Programming and Scripting
I need to write a script, which takes the input a log file and create output file with acct no's line by line from selected records with text like (in red) :
18:51:18 | 217863|Acct 0110855565|RC 17608| 16 Subs| 1596 UsgRecs| 2 Secs| 430 CPUms| prmis2:26213 <MoveUsage d
aemon needs to run... (7 Replies)
Discussion started by: rkrish
7 Replies
3. Shell Programming and Scripting
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies
4. Shell Programming and Scripting
I have a txt file with contents of acct nbr's like:
22222222222
33333333333
33445566778
I need to write a script which takes each acct nbr in the file and run the query like:
select seq_nbr from event where acct_nbr='22222222222'
and the query's output should be passed to a... (0 Replies)
Discussion started by: Rajesh Putnala
0 Replies
5. Shell Programming and Scripting
Hi,
I am trying to export the data to an .ixf file.
I have read the table names from a .dat file and those table name should be passed to the select * from schema.TABLENAME query .
I am trying the below loop
while read TABLE; do
db2 EXPORT TO ~/data_export/$TABLE.ixf OF IXF MESSAGES... (5 Replies)
Discussion started by: vikyalex4
5 Replies
6. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
7. Shell Programming and Scripting
Thank you for taking the time to read my issue. I need to set up a script to run from a wagon wheel type toplogy where 1 server needs to query about 10 to 15 remote servers for duplicate values in a database table. If a duplicate value is found, send an email to me( or wall command to console).... (5 Replies)
Discussion started by: lutador72
5 Replies
8. Shell Programming and Scripting
Hi All,
I have a command which provide this output
symaccess -sid 624 show PG_E36_PG6P -type port |grep FA
FA-5G:1
FA-6G:0
FA-11G:0
FA-12G:1
I need to use the value in loop like this (5 Replies)
Discussion started by: ranjancom2000
5 Replies
9. Shell Programming and Scripting
Run a loop that will search for a file to thousand machine and know who owns the file
$ for i in abc{01..02}
> do
> echo -n $i
> ssh $i "sudo find / -name .ssh -exec ls -l {} \;|grep id"
> done
abc01-rw-------. 1 root root 1675 Nov 10 2018 id_rsa
abc01-rw-------. 1 root root 1675 Nov 14... (6 Replies)
Discussion started by: invinzin21
6 Replies
10. UNIX for Beginners Questions & Answers
I would like to call a .sql file from a .sh file in linux. The .sql file will contain queries to MySQL database.
I am able to call the .sql file by running .sh file in linux, but the sql query is not working. Below is my syntax. The select statement is throwing below error.
./sample.sql: line... (1 Reply)
Discussion started by: qytan
1 Replies
LEARN ABOUT REDHAT
ilaenv
ILAENV(l) ) ILAENV(l)
NAME
ILAENV - i called from the LAPACK routines to choose problem-dependent parameters for the local environment
SYNOPSIS
INTEGER FUNCTION ILAENV( ISPEC, NAME, OPTS, N1, N2, N3, N4 )
CHARACTER*( * ) NAME, OPTS
INTEGER ISPEC, N1, N2, N3, N4
PURPOSE
ILAENV is called from the LAPACK routines to choose problem-dependent parameters for the local environment. See ISPEC for a description of
the parameters.
This version provides a set of parameters which should give good, but not optimal, performance on many of the currently available comput-
ers. Users are encouraged to modify this subroutine to set the tuning parameters for their particular machine using the option and problem
size information in the arguments.
This routine will not function correctly if it is converted to all lower case. Converting it to all upper case is allowed.
ARGUMENTS
ISPEC (input) INTEGER
Specifies the parameter to be returned as the value of ILAENV. = 1: the optimal blocksize; if this value is 1, an unblocked algo-
rithm will give the best performance. = 2: the minimum block size for which the block routine should be used; if the usable block
size is less than this value, an unblocked routine should be used. = 3: the crossover point (in a block routine, for N less than
this value, an unblocked routine should be used) = 4: the number of shifts, used in the nonsymmetric eigenvalue routines = 5: the
minimum column dimension for blocking to be used; rectangular blocks must have dimension at least k by m, where k is given by
ILAENV(2,...) and m by ILAENV(5,...) = 6: the crossover point for the SVD (when reducing an m by n matrix to bidiagonal form, if
max(m,n)/min(m,n) exceeds this value, a QR factorization is used first to reduce the matrix to a triangular form.) = 7: the number
of processors
= 8: the crossover point for the multishift QR and QZ methods for nonsymmetric eigenvalue problems. = 9: maximum size of the sub-
problems at the bottom of the computation tree in the divide-and-conquer algorithm (used by xGELSD and xGESDD) =10: ieee NaN arith-
metic can be trusted not to trap
=11: infinity arithmetic can be trusted not to trap
NAME (input) CHARACTER*(*)
The name of the calling subroutine, in either upper case or lower case.
OPTS (input) CHARACTER*(*)
The character options to the subroutine NAME, concatenated into a single character string. For example, UPLO = 'U', TRANS = 'T',
and DIAG = 'N' for a triangular routine would be specified as OPTS = 'UTN'.
N1 (input) INTEGER
N2 (input) INTEGER N3 (input) INTEGER N4 (input) INTEGER Problem dimensions for the subroutine NAME; these may not
all be required.
>= 0: the value of the parameter specified by ISPEC < 0: if ILAENV = -k, the k-th argument had an illegal value.
FURTHER DETAILS
The following conventions have been used when calling ILAENV from the LAPACK routines:
1) OPTS is a concatenation of all of the character options to
subroutine NAME, in the same order that they appear in the
argument list for NAME, even if they are not used in determining
the value of the parameter specified by ISPEC.
2) The problem dimensions N1, N2, N3, N4 are specified in the order
that they appear in the argument list for NAME. N1 is used
first, N2 second, and so on, and unused problem dimensions are
passed a value of -1.
3) The parameter value returned by ILAENV is checked for validity in
the calling subroutine. For example, ILAENV is used to retrieve
the optimal blocksize for STRTRI as follows:
NB = ILAENV( 1, 'STRTRI', UPLO // DIAG, N, -1, -1, -1 )
IF( NB.LE.1 ) NB = MAX( 1, N )
LAPACK version 3.0 15 June 2000 ILAENV(l)