Export env_varibales from a file created by me

barkha_st · 10-04-2011, 01:32 AM

Hi,

I want to export environment variables from a .env82 file which is created by me.

contents of .env82 file are as below
SCHEMANAME=ABCD
DBNAME=DGOL02.UK.HIBM.HSBC
DSUSER=ABCD
DSPASS=Test1

.env82 file is say placed on Linux box at /opt/Scripts

I need to export these variable into my shell script to create below statement

sqlplus ABCD/Test1@DGOL02.UK.HIBM.HSBC

Can you tell me how can I do this.

colucix · 10-04-2011, 01:41 AM

You can add the export statement at the beginning of every line:

Code:

export SCHEMANAME=ABCD
export DBNAME=DGOL02.UK.HIBM.HSBC
export DSUSER=ABCD
export DSPASS=Test1

then you simply have to source this file:

Code:

. /opt/Scripts/scriptname

If you want to do this automatically every time you start a new shell, put the above statement into your $HOME/.bashrc (assuming your default shell is /bin/bash).

barkha_st · 10-04-2011, 02:42 AM

great.....its working

thanks a mil