15 lines
702 B
SQL
15 lines
702 B
SQL
alter table capbatinf modify rsp_cd VARCHAR2(30) null;
|
|
alter table capbatinf modify RSP_MSG VARCHAR2(120) null;
|
|
alter table captxnjnl modify TRSP_CD VARCHAR2(30) null;
|
|
alter table captxnjnl modify TRSP_MSG VARCHAR2(500) null;
|
|
alter table captxnjnl modify RSP_CD VARCHAR2(30) null;
|
|
alter table captxnjnl modify RSP_MSG VARCHAR2(500) null;
|
|
|
|
alter table CAPSIGINF add SIG_STS VARCHAR2(2) default 'U';
|
|
alter table CAPSIGINF add QryfSeqno VARCHAR2(35);
|
|
|
|
alter table CAPSIGINF drop constraint CAPSIGINF_PK;
|
|
alter table CAPSIGINF add constraint CAPSIGINF_PK primary key (CUS_NAM,CRD_NO);
|
|
create index CAPSIGINF_NI1 on CAPSIGINF (QryfSeqno);
|
|
|
|
alter table CAPICBCPERD add TRSP_CD VARCHAR2(8) null; |