spool DatosCamposParcial.log                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
set Define "!"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
set feedback off                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
set define off                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
prompt Deleting TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TFORMATOXML');                                                                                                                                                                                                                                                                                                                                                                                           
prompt Deleting TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
delete from tCamposConsultablesId where tablabase='TFORMATOXML';                                                                                                                                                                                                                                                                                                                                                                                                                                                    
prompt Loading TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(121001,'TFORMATOXML','CIDIOMA',5,null,null,'T','1','1','0',null,'1','1',31,'1',null,null,'0','VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                                       
insert into tCamposConsultablesId values(121002,'TFORMATOXML','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'1','1',47,'1',null,null,'0','VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                                   
insert into tCamposConsultablesId values(121003,'TFORMATOXML','CTRANSACCION',5,null,null,'T','1','1','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                                
insert into tCamposConsultablesId values(121004,'TFORMATOXML','FDESDE',5,null,null,'S','0','0','0','','1','1',null,'1',null,null,'0','TIMESTAMP',11,6,'0');                                                                                                                                                                                                                                                                                                                                                         
insert into tCamposConsultablesId values(121005,'TFORMATOXML','FHASTA',5,null,null,'S','0','1','0','','1','1',null,'1',null,null,'0','TIMESTAMP',11,6,'0');                                                                                                                                                                                                                                                                                                                                                         
insert into tCamposConsultablesId values(121006,'TFORMATOXML','FORMATOXML',5,null,null,'T','0','0','0',null,'1','1',null,'1',null,null,'0','CLOB(4000)',4000,0,'0');                                                                                                                                                                                                                                                                                                                                                
insert into tCamposConsultablesId values(121007,'TFORMATOXML','VERSIONTRANSACCION',5,null,null,'T','1','1','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(121008,'TFORMATOXML','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','1',null,'1',null,null,null,'NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(121009,'TFORMATOXML','FUENTEXML',5,null,null,'T','0','0','1',null,'1','1',null,'1',null,null,null,'CLOB(4000)',4000,0,'0');                                                                                                                                                                                                                                                                                                                                                
insert into tCamposConsultablesId values(121010,'TFORMATOXML','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','1',null,'1',null,null,null,'NUMBER(22)',22,0,'0');                                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(121011,'TFORMATOXML','TIPOFORMATO',5,null,null,'T',null,'0','0','com.FitBank.xml.For,'1','1',null,'1',null,null,null,'VARCHAR2(50)',50,0,'0');                                                                                                                                                                                                                                                                                                                             
prompt Loading TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',121001,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 idioma');                                                                                                                                                                                                                                                                                              
insert into tCamposConsultables values('ES',121002,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',121003,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',121004,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'),'Fecha desde la que esta vigente el formato XML');                                                                                                                                                                                                                                                                 
insert into tCamposConsultables values('ES',121005,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'),'Fecha hasta la que esta vigente el formato XML');                                                                                                                                                                                                                                                                 
insert into tCamposConsultables values('ES',121006,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'),'Formato XML para los mensajes');                                                                                                                                                                                                                                                                                  
insert into tCamposConsultables values('ES',121007,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 la transaccion');                                                                                                                                                                                                                                                                                      
insert into tCamposConsultables values('ES',121008,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 persona de la compania');                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',121009,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'),'Archivo del que se compila el formulario para los mensajes');                                                                                                                                                                                                                                                     
insert into tCamposConsultables values('ES',121010,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',121011,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'),'Tipo de formato del formulario especificado como default com.FitBank.xml.Formas.Formulario');                                                                                                                                                                                                                     
commit;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
set Define "&"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
set feedback on                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
prompt Done.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
spool off