Aliases in unix are used to make it easier to run commands that are long or hard to remember.  Below is an example of how to create an alias to run DB2 SQL

alias db2='function _db2(){ echo "Running $1"; system -i "call QSYS/QZDFMDB2 parm('\''$1'\'')"; };_db2'
db2 "SELECT * FROM MYLIB.MYTABLE"
#Get fancy and search the data
db2 "SELECT * FROM MYLIB.MYTABLE" | grep "Smith"
#Alternatively you can run it through qsh – https://kadler.github.io/2018/05/29/calling-qsh-utilities-from-pase.html

WARNING! – This is just an experiment and you might want to add some security to this to make sure that sql injection and other things don’t occur.

Shout out to @tweetjbh https://twitter.com/tweetjbh for the ideas!