Sponsored Content
Top Forums Shell Programming and Scripting Unable to get the Value of variable Post 302527541 by WhtNxt01 on Friday 3rd of June 2011 02:01:30 PM
Old 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

unable to access a variable not local to a while loop

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

Unable to access variable outside loop

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

Unable to declare a variable in Cygwin

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

Unable to add user defined variable

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

Unable to export delimiter as variable to SQL

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

awk unable to compare the shell variable

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

Unable to assign command output to variable

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

Unable to read Environment Variable

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

Unable to set my PATH variable

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

Unable to grab output in variable

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
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)
All times are GMT -4. The time now is 01:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy