-- Deleting TCAMPOSCONSULTABLES... delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCOMANDOSMANTENIMIENTO'); -- Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TCOMANDOSMANTENIMIENTO'; -- Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2508001,'TCOMANDOSMANTENIMIENTO','COMANDO',5,null,null,'T','0','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(200)',200,0,'0'); insert into tCamposConsultablesId values(2508002,'TCOMANDOSMANTENIMIENTO','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2508003,'TCOMANDOSMANTENIMIENTO','CTRANSACCION',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2508004,'TCOMANDOSMANTENIMIENTO','EVENTO',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2508005,'TCOMANDOSMANTENIMIENTO','ORDEN',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(2508006,'TCOMANDOSMANTENIMIENTO','SCOMANDO',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(2508008,'TCOMANDOSMANTENIMIENTO','USACACHE',5,null,null,'T','1','0','0','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2508009,'TCOMANDOSMANTENIMIENTO','VERSIONCONTROL',5,null,null,'N','0','0','1','0','0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2508010,'TCOMANDOSMANTENIMIENTO','VERSIONTRANSACCION',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2508011,'TCOMANDOSMANTENIMIENTO','TIPOCOMANDO',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2508012,'TCOMANDOSMANTENIMIENTO','ACTIVADO',5,null,null,'T',null,'0','1','1','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2508013,'TCOMANDOSMANTENIMIENTO','CANALESEXCLUIDOS',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(40)',40,0,'0'); insert into tCamposConsultablesId values(2508014,'TCOMANDOSMANTENIMIENTO','PARAMETRO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(250)',250,0,'0'); -- Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',2508001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Paquete y clase a invocar'); insert into tCamposConsultables values('ES',2508002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del subsistema'); insert into tCamposConsultables values('ES',2508003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2508004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'El comando se ejecuta en eI inicio de la transaccion, F fin de la transaccion.'); insert into tCamposConsultables values('ES',2508005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Orden de ejecucion del comando.'); insert into tCamposConsultables values('ES',2508006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia de comando de la transaccion.'); insert into tCamposConsultables values('ES',2508008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la el registro se almacena en cache utilizado en transacciones utilizadas frecuentemente.'); insert into tCamposConsultables values('ES',2508009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic locking.'); insert into tCamposConsultables values('ES',2508010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de transaccion'); insert into tCamposConsultables values('ES',2508011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de tipo de comando, MAN o CON'); insert into tCamposConsultables values('ES',2508012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Marca si el comando de ejecucion de la transaccion esta activado o no'); insert into tCamposConsultables values('ES',2508013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Lista de canales en los que no se debe ejecutar el Comando separado por ;'); insert into tCamposConsultables values('ES',2508014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Parametros especificos al comando en tiempo de ejecucion.'); commit; -- Done.