06-03-2011
Unable to get the Value of variable
Hi,
I have a properties file that is read by the Unix Shell Script.
The script prompt the user to enter some input feilds and then based on user input it needs to look other values from properties file
Example
abc.properties file has following properties
Dev.DB2.name=someDEVDB2
Dev.DB2.ID=someDEVID
QA.DB2.name=someQADB2
QA.DB2.ID=someQAID
The script prompt use to enter the region as Dev or QA
Based on this the script need to get the value from property file.
The region is read as
$regionName say Dev
now i need to get the value of DB2.name
i tried doing
DB2_NAME= ${regionName}.DB2.name
but this doesnot return someDEVDB2
Any help is really appreciated
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a while loop like this
cat ${filename} | while read fileline
do
...
done
I need to access a variable value $newfile inside this while loop
How will i do that?? (6 Replies)
Discussion started by: codeman007
6 Replies
2. Shell Programming and Scripting
I am unable to access the value set inside the loop from outside loop .
Thought of taking this to forum , I had seen other replies also , where a pipe takes the execution to another shell and mentioned thats the reason we do not get the variable outside loop . But I am getting an issue and I am... (1 Reply)
Discussion started by: Armaan_S
1 Replies
3. Shell Programming and Scripting
I recently installed Cygwin on my windows vista to practice on Linux\unix commands.
I am unable to do a simple task of declaring variables on the command prompt
I am trying:
$ vech=Bus
$ echo $vech
bash: vech : command not found
What am I missing? Do i need to add something to .bashrc?
... (1 Reply)
Discussion started by: erora
1 Replies
4. Shell Programming and Scripting
Hi,
I have a user defined variable _TIME1=xxx
I am using awk command for pattern matching.
cat $_LOCATION/catalina.txt | awk '/^`$_TIME1`:??:??/'
It not taking the value of $_TIME!
eg:I am using the command to get all the patter from 12:00:00 to 12:59:59
The user defined variable... (2 Replies)
Discussion started by: ahamed
2 Replies
5. UNIX for Advanced & Expert Users
Hi,
I'm using a shell wrapper to trigger a teradata sql fastexport script as follows:
#!/bin/ksh
export delm=`echo "\t"`
fexp <<!
SELECT
COALESCE(TRIM(CAST(col1 AS VARCHAR(10))),'')
||'$delm'|| COALESCE(CAST(col2 AS VARCHAR(10)),'')
||'$delm'|| COALESCE(TRIM(col3),'')
FROM TABLE;
... (11 Replies)
Discussion started by: sumoka
11 Replies
6. UNIX for Dummies Questions & Answers
Hi
Could anyone please help with Awk.
The below code prints the PID of the matching process with condition with $8 and $9
ps -ef |awk '($8~/proc/) && ($9~/rPROC2/) {print $2}'
Now i want to change the Constant PROC2 from Shell variable
PROC2 is already declared in shell variable SRVNAME... (9 Replies)
Discussion started by: rakeshkumar
9 Replies
7. Shell Programming and Scripting
Code
set -x
STATUS="0"
echo $STATUS
for i in `ls -ltr Report*|awk '{ print $9 }'`
do
if
then
flg = "`head -1 "$i" |cut -c 31-33`"
echo `head -1 "$i" |cut -c 31-33`
echo $flg
if
then
echo "having Fun"
STATUS="2"
else
echo "no Fun"
fi
fi (2 Replies)
Discussion started by: Funkeydude
2 Replies
8. Shell Programming and Scripting
Hi I have created the following shell script file with the following content.
#!/bin/csh
set VAR1="abcxyz" << EOF
EOF
echo "---------------------"
echo "VAR1 = $VAR1"
echo "---------------------"
i am not able to echo the previously set VAR1.
Can any one suggested what could be wrong?... (5 Replies)
Discussion started by: srinu_b
5 Replies
9. Shell Programming and Scripting
Hello All,
Hope you can understand my problem from the below code.
$ cat ~/.profile
PS1=`whoami`@`hostname`':$PWD
$ '
export PATH="$PATH:.:/logarchive/utility/util:/usr/sbin:"
$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:.:/usr/sbin:
$ echo $SHELL
/usr/bin/ksh
... (6 Replies)
Discussion started by: sathyaonnuix
6 Replies
10. Shell Programming and Scripting
bash-3.2$ time rm -rf /tmp/logs/server1.out I wish to check if is more than 10 secs then exit 5; else; exit 7
How can i capture the row value for real in the output shown above ?
I am also not able to redirect the output to a file.
Can you please suggest ? (7 Replies)
Discussion started by: mohtashims
7 Replies
LEARN ABOUT PHP
db2_table_privileges
DB2_TABLE_PRIVILEGES(3) 1 DB2_TABLE_PRIVILEGES(3)
db2_table_privileges - Returns a result set listing the tables and associated privileges in a database
SYNOPSIS
resource db2_table_privileges (resource $connection, [string $qualifier], [string $schema], [string $table_name])
DESCRIPTION
Returns a result set listing the tables and associated privileges in a database.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the tables. This parameter accepts a search pattern containing _ and % as wildcards.
o $table_name
- The name of the table. This parameter accepts a search pattern containing _ and % as wildcards.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the privileges for the tables that match the specified parame-
ters. The rows are composed of the following columns:
+-------------+---------------------------------------------------+
|Column name | |
| | |
| | Description |
| | |
+-------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | The catalog that contains the table. The value is |
| | NULL if this table does not have catalogs. |
| | |
|TABLE_SCHEM | |
| | |
| | Name of the schema that contains the table. |
| | |
| TABLE_NAME | |
| | |
| | Name of the table. |
| | |
| GRANTOR | |
| | |
| | Authorization ID of the user who granted the |
| | privilege. |
| | |
| GRANTEE | |
| | |
| | Authorization ID of the user to whom the privi- |
| | lege was granted. |
| | |
| PRIVILEGE | |
| | |
| | The privilege that has been granted. This can be |
| | one of ALTER, CONTROL, DELETE, INDEX, INSERT, |
| | REFERENCES, SELECT, or UPDATE. |
| | |
|IS_GRANTABLE | |
| | |
| | A string value of "YES" or "NO" indicating |
| | whether the grantee can grant the privilege to |
| | other users. |
| | |
+-------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_spe-
cial_columns(3), db2_statistics(3), db2_tables(3).
PHP Documentation Group DB2_TABLE_PRIVILEGES(3)