its an alternative but i am searching for a method which can pass the variable from shell script to the Sql's (have a lot of SQL's using the same variable 'current date' but doing different tasks and using a here document will make the script messy)