Reg calling unix script in DB

November 15, 2011 at 01:02:47
Specs: Windows XP
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;


See More: Reg calling unix script in DB

November 16, 2011 at 07:21:12
How about sharing what database you are using and also post your unix script??

Report •
Related Solutions

Ask Question