--reqnum需要max+1,reff、pbu要和reqtext中的11和448相同,reqtext的9=是长度,35=开始的有长度变化要修改这个值,1645=是额度(百万)
INSERT ezstepvote..reqresp
( reqnum ,
reqid ,
reff ,
securityid ,
pbu ,
recordtimestamp ,
ordstatus ,
remark ,
localrespnum ,
reqtext ,
resptext
)
VALUES ( 1 ,
'CFC' ,
'CFC0000001' ,
'799970' ,
'12858' ,
CONVERT(CHAR(8), GETDATE(), 112) + '-' + CONVERT(CHAR(8), GETDATE(), 8)
+ '.000' ,
'R' ,
'' ,
0 ,
'9=6735=U00911=CFC000000148=7999701645=10453=1448=12345452=158= ' ,
''
)