https://community.hpe.com/t5/operating-system-linux/shell-scripts/m-p/3791499#M99612 Remove the second prompt. variable "ssn" will still hold it's value from the first prompt through the whole script.<BR /> <BR />HTH<BR /> <BR />-- Rod Hills Fri, 19 May 2006 13:59:51 GMT Rodney Hills 2006-05-19T13:59:51Z https://community.hpe.com/t5/operating-system-linux/shell-scripts/m-p/3791498#M99611 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 Fri, 19 May 2006 13:51:15 GMT https://community.hpe.com/t5/operating-system-linux/shell-scripts/m-p/3791498#M99611 HECTOR COLUNGA 2006-05-19T13:51:15Z https://community.hpe.com/t5/operating-system-linux/shell-scripts/m-p/3791499#M99612 Remove the second prompt. variable "ssn" will still hold it's value from the first prompt through the whole script.<BR /> <BR />HTH<BR /> <BR />-- Rod Hills Fri, 19 May 2006 13:59:51 GMT https://community.hpe.com/t5/operating-system-linux/shell-scripts/m-p/3791499#M99612 Rodney Hills 2006-05-19T13:59:51Z