Hi Pravin,

Actually from the XML file I am able to extract values for below variables:

Code:

$src_database=Oracle
$src_datatype=number
$tgt_datatype=double

What I want now is to check if number = double is fine?
This translation I can read from config file only. Hope I'm clear now. Sorry for the confusion my initial post created.

-dips

---------- Post updated 2011-04-15 at 12:15 PM ---------- Previous update was 2011-04-14 at 02:23 PM ----------

Hi,

I'm able to read a section of file by changing the format of the file a little

Changed config file:

Code:

 
$cat temp.cfg
landing_dir=XXXX
scripts_dir=XXXX
....
 
<Oracle>
number|double;integer  
blob|binary
varchar2|string
varchar|string
number(p,s)|decimal
timestamp|date/time
<Oracle>
 
<Sybase>
bigint|bigint
datetime|date/time
money|decimal
smallint|small integer
....
<Sybase>

To read only "Oracle" section from the file (searched forum)

Code:

 
awk '/\<Oracle\>/{p=0}p;/\<Oracle\>/{p=1}' temp.cfg

In my script I'll have variables holding source & target datatypes as below:

Code:

$src_datatype=number
$tgt_datatype=double

Scenario 1
Now as $src_datatype variable is "number" then I want to read only

Code:

 
number|double;integer

this line from the temp.cfg

and check whether $tgt_datatype is either of them i.e. "double" or "interger"?

Scenario 2
If $src_datatype variable is "number(p,s)" then I want to read only

Code:

 
number(p,s)|decimal

this line from temp.cfg

and check whether $tgt_datatype is "decimal" ?

I tried

Code:

 
awk '/\<Oracle\>/{p=0}p;/\<Oracle\>/{p=1}' temp.cfg | grep -w "$src_datatype"

but it selects two lines

Code:

 
number|double;integer
number(p,s)|decimal

Please advice on how to proceed further. Thanks for your time.

-dips