Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
commandline dbaccess
- Thread starter sweetsgup
- Start date
In Unix create a command file containing the following;
dbaccess 'DBNAME' -<<!
'SQL #1';
'SQL #2';
!
If the command file you created is called mysql.sh run it as follows;
nohup mysql.sh &
This will execute SQL #1 followed by SQL #2 (against database DBNAME) and save the output in a file named nohup.out
Make sure the last ! is the first character in the first column. [sig][/sig]
dbaccess 'DBNAME' -<<!
'SQL #1';
'SQL #2';
!
If the command file you created is called mysql.sh run it as follows;
nohup mysql.sh &
This will execute SQL #1 followed by SQL #2 (against database DBNAME) and save the output in a file named nohup.out
Make sure the last ! is the first character in the first column. [sig][/sig]
- Thread starter
- #3
If I understand you correctly the answer is yes. The piece of code I supplied can be wrapped with unix shell commands. The stuff in between the !'s are for the database only - the remainder is for the shell. e.g.;
echo "`date` Selecting rows from table ABC . . ."
dbaccess 'DBNAME' -<<!
unload to abc.unl
select
*
from ABC
;
!
echo "`date` Selected rows from table ABC . . ."
I wrote the echo commands (in this case) to tell me what the sql is doing. Try it with your shell script(s). Happy Halloween!
echo "`date` Selecting rows from table ABC . . ."
dbaccess 'DBNAME' -<<!
unload to abc.unl
select
*
from ABC
;
!
echo "`date` Selected rows from table ABC . . ."
I wrote the echo commands (in this case) to tell me what the sql is doing. Try it with your shell script(s). Happy Halloween!
- Status
Similar threads
