|We are using below syntax to call one unix script in DB.|
$EXEC/Unix_script_name1 dbname user.
for example :
script_name : Unix_script_name1
inside this we are dropping one temp table and creating new table with same name.
Once we called this unix script by using ($EXEC/Unix_script_name1 dbname user) it doesn't showing any error in DB and the script was running succesfully.
once i have cheked with temp_table name by using below sql in DB its showing there is no tables in that name. can you tell me wether calling unix_script is correct or not.
Select * from temp_table_name;