Parameters and BTEQ

Tools
New Member

Parameters and BTEQ

Hi folks:
I'm trying to make a simple unix script shell to define a variable and execute a bteq command. For example:
#!/bin/sh
homeDir=/home/OprBCI/FAA/MigracProc
bteq < arch.btq > arch.out
## End of shell
The question is: How I can pass the "homeDir" variable to bteq process in "arch.btq"?

I need to make the shell in this format because I need to avoid to include the bteq file into the shell, for example:
#!/bin/sh
homeDir=/home/OprBCI/FAA/MigracProc
bteq << !EOF
.... (here I can use $homeDir easily)
!EOF
## End of shell

Thank you very much for your help.