UC知道高手帮忙 shell编程
来源：百度知道 编辑：UC知道 时间：2024/05/25 14:47:40
update dwadm.account_loan_org_h set account_valid_date='$(WRKDATE)' where account_valid_date='20991231' and account_id in (select account_id from dwadm.account_loan_org where account_trans_date='$(WRKDATE)')
delete from account_loan_org_h where account_trans_date='$(WRKDATE)'
insert into account_loan_org_h select * from account_loan_org where account_trans_date='$(WRKDATE)'
我要把这三句话用Shell编程写出来！！高手指点
delete from account_loan_org_h where account_trans_date='$(WRKDATE)'
insert into account_loan_org_h select * from account_loan_org where account_trans_date='$(WRKDATE)'
我要把这三句话用Shell编程写出来！！高手指点
同楼上的问，什么数据库啊？另外其中的变量"WORKDATE"是环境变量还是你要输入的参数呢?假设是db2，假设"WORKDATE"是你输入的参数，可以如下：
db2 "update dwadm.account_loan_org_h set account_valid_date='$1' where account_valid_date='20991231' and account_id in (select account_id from dwadm.account_loan_org where account_trans_date='$1')";
db2 "delete from account_loan_org_h where account_trans_date='$1'";
db2 "insert into account_loan_org_h select * from account_loan_org where account_trans_date='$1'";
保存为1.sh,运行时加入参就行了啊，或者可能我理解的太简单了？
是什么数据库？也猜不准你什么意思，建议看看shell编程方面的here document吧，也许是你想要的