acclear.sh
#!/bin/sh . /home/bdss/.profile user=bdss pass=bdss db2 connect to rptdb user $user using $pass >>EFO db2 "delete from BDSS.JS201_CLDWDK where pkid > 3869503" db2 "delete from BDSS.LOG_DATA_12" exit; EOF
执行命令:sh acclear.sh
acclear.sh
#!/bin/sh . /home/bdss/.profile user=bdss pass=bdss db2 connect to rptdb user $user using $pass >>EFO db2 "delete from BDSS.JS201_CLDWDK where pkid > 3869503" db2 "delete from BDSS.LOG_DATA_12" exit; EOF
执行命令:sh acclear.sh