scripts and stored procedures
scripts and stored procedures
(OP)
hi, thanks a lot richman for helping me with my doubt, i have another question, pls bear with me :) i was wondering if i can package some script files as well as .sql files together in a single commandfile and execute it? or do they have to be in seperate commandfiles?
RE: scripts and stored procedures
Regards
RE: scripts and stored procedures
Thanks a lot for replying.
RE: scripts and stored procedures
I don't exactly know what you are asking. Given that I will say (again in Unix) that you can have one command file that executes SQL in separate file(s). For example;
Note: DBNAME is your database name
echo "`date` This executes sql_file_1"
dbaccess DBNAME sql_file_1.sql
echo "`date` This executed sql_file_1"
.
.
echo "`date` This executes sql_file_2"
dbaccess DBNAME sql_file_2.sql
echo "`date` This executed sql_file_2"
and so on . . .
This is one command file executing 2 sql files residing outside of it.
Hope this helps!
RE: scripts and stored procedures