11-01-2007
Thanks jim
![Thumbsup Smilie](https://www.unix.com/images/smilies/thumb.gif)
You have given reply is very usefull. again thanks to you.
Just in Below code I have change array box with [] and add new code for print the array member.
#!/usr/bin/ksh
let i=0
#set -A arr
echo "select param_value
from control_param
where pgm_name = 'EXS_PROCESS';
exit
" | sqlplus -s ${ora_user}/${ora_passwd}@${ORACLE_SID} | \
while read line
do
if [[ $i -gt 2 ]]
then
arr[$i-3]="$line"
fi
let i=$i+1
done
echo "Array Variable is Filled Up"
i=0
echo " Total no. of member ${#arr[@]} "
echo "Print the Array member"
while [ $i -lt ${#arr[@]}-1 ]
do
print ${arr[$i]}
(( i=i+1 ))
done
echo "After Array Print"
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all,
I have a file having the following formats:
ThreadFail=Web1=1234
ThreadFail=Web2=2345
ThreadFail=Web3=12
ConnectionFail=DB1=11
ConnectionFail=DB2=22
The number of lines will be different from every time . How can I parse the file and store the result to an a array inside... (6 Replies)
Discussion started by: youareapkman
6 Replies
2. Shell Programming and Scripting
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Discussion started by: gregrobinsonhd
7 Replies
3. Shell Programming and Scripting
Hello,
Can someone please advise me how to put the db2 query reult into an array?
For example, the query reults are:
string A
string B
string C
Then how do I put them into array=string A
array=string B
... (2 Replies)
Discussion started by: hanul
2 Replies
4. Shell Programming and Scripting
Hi,
I have few variable say 10
ex:-
l_pc_291334_01_0_01_00.cmp
l_pc_441133_50_0_02_00.cmp
l_pc_441133_55_0_02_00.cmp
Each variable value is coming via loop on a table.
I want to create a script that stores these value to a table or array ( But one by one not all at one time as... (4 Replies)
Discussion started by: amitkumar.b2
4 Replies
5. Shell Programming and Scripting
Hi to all,
I have this input:
<group>
<x "2">Group D</x>
<x "3">Group B</x>
<x "1">Group A</x>
</group>
<group>
<x "1">Group E</x>
<x "0">Group B</x>
<x "1">Group C</x>
</group>
<group> ... (11 Replies)
Discussion started by: Ophiuchus
11 Replies
6. Shell Programming and Scripting
Dear All,
I have been trying to do a simple task of extracting 2 fields from the file (3 rows) and store it in an array variable. I tried with:
#! /bin/bash
ch=`cut -f10 tmp.txt`
counter=0
for p in $pid
do
c=${ch}
echo "$c ..$counter"
counter=$((counter+1))... (2 Replies)
Discussion started by: ezhil01
2 Replies
7. Programming
Hi,
I wrote the below script to get the query result from a Syabase DB.
isql -s -U **** -P **** SYBASE SERVERNAME
USE ***(Database name in Sybase)
@command.sql
But im not getting the output. Can anyone help me on this (2 Replies)
Discussion started by: rohan G
2 Replies
8. Shell Programming and Scripting
Friends have the following problem:
cat $PATH_DAT/mr.txt | nawk 'BEGIN {
CantPnt=0;
NumReg=0;
FS="|"
}
{
NumReg++
CantPnt=CantPnt+int($2)
}
END{
printf... (5 Replies)
Discussion started by: tricampeon81
5 Replies
9. Shell Programming and Scripting
I can not figure out how to capture the $filename variable store by the bash.
#!/bin/bash
# oldest folder stored as variable for analysis, version log created, and quality indicators matched to run
dir=/home/cmccabe/Desktop/NGS/test
find "$dir" -maxdepth 1 -mindepth 1 -type d -printf... (5 Replies)
Discussion started by: cmccabe
5 Replies
10. Shell Programming and Scripting
I'm trying to achieve the follwoinig with no luck.
Find the directories that are greater than 50GB in size and pick the owner of the directory as I would like to send an alert notification.
du -sh * | sort -rh
139G Dir_1
84G Dir_2
15G Dir_3
ls -l Dir_1
drwx------ 2... (3 Replies)
Discussion started by: 308002184
3 Replies
LEARN ABOUT PHP
get_defined_vars
GET_DEFINED_VARS(3) 1 GET_DEFINED_VARS(3)
get_defined_vars - Returns an array of all defined variables
SYNOPSIS
array get_defined_vars (void )
DESCRIPTION
This function returns a multidimensional array containing a list of all defined variables, be them environment, server or user-defined
variables, within the scope that get_defined_vars(3) is called.
RETURN VALUES
A multidimensional array with all the variables.
EXAMPLES
Example #1
get_defined_vars(3) Example
<?php
$b = array(1, 1, 2, 3, 5, 8);
$arr = get_defined_vars();
// print $b
print_r($arr["b"]);
/* print path to the PHP interpreter (if used as a CGI)
* e.g. /usr/local/bin/php */
echo $arr["_"];
// print the command-line parameters if any
print_r($arr["argv"]);
// print all the server vars
print_r($arr["_SERVER"]);
// print all the available keys for the arrays of variables
print_r(array_keys(get_defined_vars()));
?>
SEE ALSO
isset(3), get_defined_functions(3), get_defined_constants(3).
PHP Documentation Group GET_DEFINED_VARS(3)