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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Shell command
adaptive server
If you are looking for firing a shell command from Interactive SQL then the command is
system <operating system command>
Eg. system date
Following are the reading from testing the above command
1. The command worked only in Interactive SQL Graphical and didn't work on Interactive SQL Character.
2. The operating system command should be in single quotes like
system 'ping 203.167.137.2'
3. system date or system time command didn't work at all. In fact I feel as date and time commands user input that is why it didn't work.
Manu
system <operating system command>
Eg. system date
Following are the reading from testing the above command
1. The command worked only in Interactive SQL Graphical and didn't work on Interactive SQL Character.
2. The operating system command should be in single quotes like
system 'ping 203.167.137.2'
3. system date or system time command didn't work at all. In fact I feel as date and time commands user input that is why it didn't work.
Manu