14 lines
1.2 KiB
SQL
14 lines
1.2 KiB
SQL
--交通银行软负载初始化SQL
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('BCOM', '001', null, null, 'url=http://192.168.64.35:7300&&timeout=30000', 'ENT_NO=8000303222&&ENT_USR_NO=00010', 'S', null, 'BCOM_CHECK_HEART', 'S', '192.168.64.35');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('BCOM', '002', null, null, 'url=http://192.168.64.36:7300&&timeout=30000', 'ENT_NO=8000303222&&ENT_USR_NO=00012', 'S', null, 'BCOM_CHECK_HEART', 'S', '192.168.64.36');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('BCOM', '003', null, null, 'url=http://192.168.64.145:7300&&timeout=30000', 'ENT_NO=8000303222&&ENT_USR_NO=00013', 'S', null, 'BCOM_CHECK_HEART', 'S', '192.168.64.145');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('BCOM', '004', null, null, 'url=http://192.168.64.146:7300&&timeout=30000', 'ENT_NO=8000303222&&ENT_USR_NO=00014', 'S', null, 'BCOM_CHECK_HEART', 'S', '192.168.64.146');
|
|
|