HPE Community
Operating System - Linux
1752570 Members
5281 Online
108788 Solutions
New Discussion

Shell Scripts

 
HECTOR COLUNGA
Occasional Contributor

‎05-19-2006 06:51 AM

‎05-19-2006 06:51 AM

Shell Scripts

I have a shell script emnedded with several SQL scripts. How can I pass a value to all of the SQL scripts requiring the same value? The attachment shows two SQL scripts embedded in a shell script. The social security number of a customer is requested twice. How can I pass this value to both SQL scripts by typing the number only once
0 Kudos
Reply
1 REPLY 1
Rodney Hills
Honored Contributor

‎05-19-2006 06:59 AM

‎05-19-2006 06:59 AM

Re: Shell Scripts

Remove the second prompt. variable "ssn" will still hold it's value from the first prompt through the whole script.

HTH

-- Rod Hills
There be dragons...
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.