Is there any way how I can run two Db2 commands from a command line? (They will be called from a PHP exec
command.)
db2 connect to ttt
(note that we need to have the connection live for the second commanddb2 UPDATE CONTACT SET EMAIL_ADDRESS = '[email protected]'
I tried this:
sudo -su db2inst1 db2 connect to ttt; db2 UPDATE CONTACT SET EMAIL_ADDRESS = '[email protected]'
The first command finishes correctly but the second one fails with the error message SQL1024N A database connection does not exist. SQLSTATE=08003
Note that I need to run this as php user. The command sudo -u db2inst1 id
as php user gives me correct output.
For your command you also could refer to the following example:
sudo sh -c 'whoami; whoami'