How can I su
from root
to db2inst1
and invoke a SQL script all in 1 line? I am thinking about something like this:
su db2inst1 | db2 CONNECT TO myDatabase USER db2inst1 USING mypw; db2 -c -i -w -td@ -f /tmp/deploy/sql/My.sql | exit;
Any ideas?