missing variable values

[darfader]

warning - beginner

Hi,

if I type this at the command line

echo $SQL_IN
/export/home/pac/work/tmp

the value is displayed, and if I type this

echo "ctl file is $SQL_IN/customer_code_load.ctl"
ctl file is /export/home/pac/work/tmp/customer_code_load.ctl

again, no problem, but inserting this line into a shell script, the result is different

$ customer_code.sh customer_code.dat
ctl file is /customer_code_load.ctl

what is the difference please ?


tia,

 

[PHV]

Is the SQL_IN variable exported (ie in the environment) ?

Hope This Help
PH.

 

[darfader]

not it wasn't

ty

 

[PHV]

So, try this:

$ export SQL_IN; customer_code.sh customer_code.dat

Hope This Help
PH.

 

[darfader]

Hi PH,

I tagged this onto the end of the .profile

SQL_IN=/export/home/pac/work/tmp
export SQL_IN