Problemas al grabar campos a una DW
Publicado por Cecilia (6 intervenciones) el 17/07/2013 00:40:28
Hola, tengo un problema que no puedo resolver.
Estoy modificando una DW en PB 5.0 y le tengo que agregar 4 campos. Es una dw external, pues rescato los datos desde una llamada a BD externa. El problema es que al recuperar la data, considera los 4 campos agregados, pero al pasarlo desde la DW a variables de paso estan con valor nulo.
Nose si el problema es que tuve que modificar la DW y eso genero que no puedo rescatar los 4 campos nuevos o tengo que hacerla de nuevo.
Si la hago de nuevo como pongo invisible los campos que no quiero que salgan en la DW?
Muestro la DW modificada. Los campos adicionados empiezan con portal_xxxx.
el ultimo campo es un control ya existente en la DW.
Gracias. Espero recibir ayuda.
$PBExportHeader$dw_con_convenios_pac.srd
release 5;
datawindow(units=0 timer_interval=0 color=80269524 processing=1 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no grid.lines=0 selected.mouse=no )
header(height=73 color="536870912" )
summary(height=1 color="536870912" )
footer(height=1 color="536870912" )
detail(height=61 color="536870912" )
table(column=(type=long updatewhereclause=no name=emp_cliente dbname="emp_cliente" )
column=(type=char(3) updatewhereclause=no name=emp_convenio dbname="emp_convenio" )
column=(type=char(20) updatewhereclause=no name=emp_nombre_corto dbname="emp_nombre_corto" )
column=(type=char(20) updatewhereclause=no name=emp_direccion_pos dbname="emp_direccion_pos" )
column=(type=char(3) updatewhereclause=no name=emp_ofi_ctacte dbname="emp_ofi_ctacte" )
column=(type=char(1) updatewhereclause=no name=emp_vigencia dbname="emp_vigencia" values="SI S/NO N/" )
column=(type=datetime updatewhereclause=no name=emp_fec_manten dbname="emp_fec_manten" )
column=(type=char(1) updatewhereclause=no name=emp_val_duplic dbname="emp_val_duplic" values="SI S/NO N/" )
column=(type=char(5) updatewhereclause=no name=emp_cod_empresa dbname="emp_cod_empresa" )
column=(type=char(3) updatewhereclause=no name=emp_ofi_ctrl dbname="emp_ofi_ctrl" )
column=(type=char(12) updatewhereclause=yes name=portal_emp_ctacte_cargo dbname="portal_emp_ctacte_cargo" )
column=(type=char(1) updatewhereclause=yes name=portal_portal dbname="portal_portal" values="SI S/NO N/" )
column=(type=char(1) updatewhereclause=yes name=portal_correo dbname="portal_correo" values="SI S/NO N/" )
column=(type=char(1) updatewhereclause=yes name=portal_sms dbname="portal_sms" values="SI S/NO N/" )
column=(type=char(1) updatewhereclause=no name=control dbname="control" )
)
text(band=header alignment="0" text="Nombre Empresa"border="6" color="0" x="10" y="12" height="53" width="604" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Convenio"border="6" color="0" x="622" y="12" height="53" width="257" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Cod Emp."border="6" color="0" x="887" y="12" height="53" width="243" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Fecha Contrato"border="6" color="0" x="1139" y="12" height="53" width="403" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Tipo de Empresa"border="6" color="0" x="1550" y="12" height="53" width="485" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Vigencia"border="6" color="0" x="2044" y="12" height="53" width="247" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="0" text="Estatus Visado"border="6" color="0" x="2300" y="12" height="53" width="412" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="0" x="10" y="4" height="53" width="604" format="[general]" name=emp_nombre_corto edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=3 alignment="2" tabsequence=32766 border="0" color="0" x="622" y="4" height="53" width="257" format="[general]" name=emp_convenio edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=40 alignment="2" tabsequence=32766 border="0" color="0" x="887" y="4" height="53" width="243" format="[general]" name=emp_cod_empresa edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=26 alignment="2" tabsequence=32766 border="0" color="0" x="1139" y="4" height="53" width="403" format="[shortdate] [time]" name=emp_fecha_cont editmask.mask="dd/mm/yyyy" editmask.focusrectangle=no font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
compute(band=detail alignment="0" expression="gf_obt_desc_rubro ( emp_tipo_emp )"border="0" color="0" x="1550" y="4" height="53" width="485" format="[general]" name=rub_descripcion font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=37 alignment="2" tabsequence=32766 border="0" color="0" x="2044" y="4" height="53" width="247" format="[general]" name=emp_vigencia edit.limit=0 edit.case=any edit.autoselect=yes edit.codetable=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=46 alignment="0" tabsequence=32766 border="0" color="0" x="2300" y="4" height="53" width="412" format="[general]" name=emp_visado edit.limit=0 edit.case=any edit.autoselect=yes edit.codetable=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
Estoy modificando una DW en PB 5.0 y le tengo que agregar 4 campos. Es una dw external, pues rescato los datos desde una llamada a BD externa. El problema es que al recuperar la data, considera los 4 campos agregados, pero al pasarlo desde la DW a variables de paso estan con valor nulo.
Nose si el problema es que tuve que modificar la DW y eso genero que no puedo rescatar los 4 campos nuevos o tengo que hacerla de nuevo.
Si la hago de nuevo como pongo invisible los campos que no quiero que salgan en la DW?
Muestro la DW modificada. Los campos adicionados empiezan con portal_xxxx.
el ultimo campo es un control ya existente en la DW.
Gracias. Espero recibir ayuda.
$PBExportHeader$dw_con_convenios_pac.srd
release 5;
datawindow(units=0 timer_interval=0 color=80269524 processing=1 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no grid.lines=0 selected.mouse=no )
header(height=73 color="536870912" )
summary(height=1 color="536870912" )
footer(height=1 color="536870912" )
detail(height=61 color="536870912" )
table(column=(type=long updatewhereclause=no name=emp_cliente dbname="emp_cliente" )
column=(type=char(3) updatewhereclause=no name=emp_convenio dbname="emp_convenio" )
column=(type=char(20) updatewhereclause=no name=emp_nombre_corto dbname="emp_nombre_corto" )
column=(type=char(20) updatewhereclause=no name=emp_direccion_pos dbname="emp_direccion_pos" )
column=(type=char(3) updatewhereclause=no name=emp_ofi_ctacte dbname="emp_ofi_ctacte" )
column=(type=char(1) updatewhereclause=no name=emp_vigencia dbname="emp_vigencia" values="SI S/NO N/" )
column=(type=datetime updatewhereclause=no name=emp_fec_manten dbname="emp_fec_manten" )
column=(type=char(1) updatewhereclause=no name=emp_val_duplic dbname="emp_val_duplic" values="SI S/NO N/" )
column=(type=char(5) updatewhereclause=no name=emp_cod_empresa dbname="emp_cod_empresa" )
column=(type=char(3) updatewhereclause=no name=emp_ofi_ctrl dbname="emp_ofi_ctrl" )
column=(type=char(12) updatewhereclause=yes name=portal_emp_ctacte_cargo dbname="portal_emp_ctacte_cargo" )
column=(type=char(1) updatewhereclause=yes name=portal_portal dbname="portal_portal" values="SI S/NO N/" )
column=(type=char(1) updatewhereclause=yes name=portal_correo dbname="portal_correo" values="SI S/NO N/" )
column=(type=char(1) updatewhereclause=yes name=portal_sms dbname="portal_sms" values="SI S/NO N/" )
column=(type=char(1) updatewhereclause=no name=control dbname="control" )
)
text(band=header alignment="0" text="Nombre Empresa"border="6" color="0" x="10" y="12" height="53" width="604" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Convenio"border="6" color="0" x="622" y="12" height="53" width="257" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Cod Emp."border="6" color="0" x="887" y="12" height="53" width="243" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Fecha Contrato"border="6" color="0" x="1139" y="12" height="53" width="403" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Tipo de Empresa"border="6" color="0" x="1550" y="12" height="53" width="485" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="2" text="Vigencia"border="6" color="0" x="2044" y="12" height="53" width="247" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
text(band=header alignment="0" text="Estatus Visado"border="6" color="0" x="2300" y="12" height="53" width="412" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="80269524" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="0" x="10" y="4" height="53" width="604" format="[general]" name=emp_nombre_corto edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=3 alignment="2" tabsequence=32766 border="0" color="0" x="622" y="4" height="53" width="257" format="[general]" name=emp_convenio edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=40 alignment="2" tabsequence=32766 border="0" color="0" x="887" y="4" height="53" width="243" format="[general]" name=emp_cod_empresa edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=26 alignment="2" tabsequence=32766 border="0" color="0" x="1139" y="4" height="53" width="403" format="[shortdate] [time]" name=emp_fecha_cont editmask.mask="dd/mm/yyyy" editmask.focusrectangle=no font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
compute(band=detail alignment="0" expression="gf_obt_desc_rubro ( emp_tipo_emp )"border="0" color="0" x="1550" y="4" height="53" width="485" format="[general]" name=rub_descripcion font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=37 alignment="2" tabsequence=32766 border="0" color="0" x="2044" y="4" height="53" width="247" format="[general]" name=emp_vigencia edit.limit=0 edit.case=any edit.autoselect=yes edit.codetable=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
column(band=detail id=46 alignment="0" tabsequence=32766 border="0" color="0" x="2300" y="4" height="53" width="412" format="[general]" name=emp_visado edit.limit=0 edit.case=any edit.autoselect=yes edit.codetable=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="29687807" )
Valora esta pregunta
0