Bug 4696
Cannot translate embedded SQL statement 22 February, 2021

iliyan iliev
26 May, 2020
Product: | PowerScript Migrator | Category: | PowerScript Migrator |
Version: | 2019 R2 | Build: | 2323 |
Classification: | Enhancement | Publishing: | Public |
Priority: | P3 | ||
Status: | Closed | Reason: | RECORDED AS ENHANCEMENT |

Appeon Product
22 February, 2021
#4
Logan Liu @Appeon
27 May, 2020
#3
Hi Iliyan, Thank you for reporting this enhancement request. I will transfer it to our product team for consideration. Regards, Logan
Hi Iliyan, Thank you for reporting this enhancement request. I will transfer it to our product team for consideration. Regards, Logan
armando.herrera
26 May, 2020
#2
Hi Iliyan, 1. Even though Informix is supported on PB2019-R2, is not entirely supported on the SnapObject nor SnapDevelop. 2. Embedded SQL is neither supported yet on the C# Migrator. However, I'm transferring this case as an Enhancement Request to be considered to our Engineering Team for future versions. Regards!
Hi Iliyan, 1. Even though Informix is supported on PB2019-R2, is not entirely supported on the SnapObject nor SnapDevelop. 2. Embedded SQL is neither supported yet on the C# Migrator. However, I'm transferring this case as an Enhancement Request to be considered to our Engineering Team for future versions. Regards!
armando.herrera
26 May, 2020
#1
Hi Iliyan, Thank you very much for your report. We are working on it and we will get back to you after analyzing it. We'll keep you posted! Regards!
Hi Iliyan, Thank you very much for your report. We are working on it and we will get back to you after analyzing it. We'll keep you posted! Regards!
iliyan iliev
26 May, 2020
*Phenomenon: private function long load_adres_dok (string asidf_dok, ref str_adrms adres);str_adrms ladr, empty_adr adres = empty_adr select first 1 trim(cod_ime_osi('eknm_d',eknm))||' ОБЩ.'||trim(cod_ime_obs(eknm))||' ОБЛ.'||trim(cod_ime_obl(eknm))||' '||cod_ime_ul(kod_ul)||' '||nvl(nomer,'')||' '||nvl(vhod,''), fa.sid_f, fa.fact , (select eknm_5 from eknm_d where cod_z=adres.eknm and valid='0'), (select obstina from eknm_d where cod_z=adres.eknm and valid='0') obs, (select oblast from eknm_d where cod_z=adres.eknm and valid='0') obl, cod_bulul(adres.kod_ul) bul_ul, trim(cod_ime_osi('eknm_d',eknm)), trim(cod_ime_obs(eknm)), trim(cod_ime_obl(eknm)), cod_ime_ul(kod_ul), nomer, vhod, fd.etaj, fd.apart, get_podel_eknm(eknm), trim(cod_ime_osi('podl_d',get_podel_eknm(eknm))), fa.sid_f into :ladr.text, :ladr.faddop.sid_f, :ladr.faddop.vid_adr, :ladr.adr.eknm, :ladr.adr.obs, :ladr.adr.obl, :ladr.adr.kod_ul,:ladr.adr.eknm_text, :ladr.adr.obs_text, :ladr.adr.obl_text, :ladr.adr.ul_text, :ladr.adr.nomer, :ladr.adr.vhod, :ladr.faddop.etaj, :ladr.faddop.apart, :ladr.faddop.cel_preb, :ladr.faddop.cel_text, :ladr.faddop.sid_f from fbdk fa, adres, outer (fact_pr pr, outer fad_dop fd) where fa.sid_f = :asidf_dok and fa.cod_t=17 and fa.rol_o=29 and adres.sid_o=fa.sid_o and adres.pnr_o=fa.pnr_o and pr.sid_f=fa.sid_f and pr.cod_t=64 and fd.sid_f = pr.sid_o and fd.mrk_akt='Y' using shsqlca; if shsqlca.sqlcode < 0 then is_errmess='Error in n_ezvl::load_act_data Select from adres ['+string(shsqlca.sqldbcode)+']-'+shsqlca.sqlerrtext _onerror(shsqlca.sqldbcode); return -1 end if if shsqlca.sqlcode = 100 then return 100 adres = ladr return 0 end function *Reproduce Steps: only click on name function and translate Remarks: capacity' must greater than zero. Parameter name : capacity
*Phenomenon: private function long load_adres_dok (string asidf_dok, ref str_adrms adres);str_adrms ladr, empty_adr adres = empty_adr select first 1 trim(cod_ime_osi('eknm_d',eknm))||' ОБЩ.'||trim(cod_ime_obs(eknm))||' ОБЛ.'||trim(cod_ime_obl(eknm))||' '||cod_ime_ul(kod_ul)||' '||nvl(nomer,'')||' '||nvl(vhod,''), fa.sid_f, fa.fact , (select eknm_5 from eknm_d where cod_z=adres.eknm and valid='0'), (select obstina from eknm_d where cod_z=adres.eknm and valid='0') obs, (select oblast from eknm_d where cod_z=adres.eknm and valid='0') obl, cod_bulul(adres.kod_ul) bul_ul, trim(cod_ime_osi('eknm_d',eknm)), trim(cod_ime_obs(eknm)), trim(cod_ime_obl(eknm)), cod_ime_ul(kod_ul), nomer, vhod, fd.etaj, fd.apart, get_podel_eknm(eknm), trim(cod_ime_osi('podl_d',get_podel_eknm(eknm))), fa.sid_f into :ladr.text, :ladr.faddop.sid_f, :ladr.faddop.vid_adr, :ladr.adr.eknm, :ladr.adr.obs, :ladr.adr.obl, :ladr.adr.kod_ul,:ladr.adr.eknm_text, :ladr.adr.obs_text, :ladr.adr.obl_text, :ladr.adr.ul_text, :ladr.adr.nomer, :ladr.adr.vhod, :ladr.faddop.etaj, :ladr.faddop.apart, :ladr.faddop.cel_preb, :ladr.faddop.cel_text, :ladr.faddop.sid_f from fbdk fa, adres, outer (fact_pr pr, outer fad_dop fd) where fa.sid_f = :asidf_dok and fa.cod_t=17 and fa.rol_o=29 and adres.sid_o=fa.sid_o and adres.pnr_o=fa.pnr_o and pr.sid_f=fa.sid_f and pr.cod_t=64 and fd.sid_f = pr.sid_o and fd.mrk_akt='Y' using shsqlca; if shsqlca.sqlcode < 0 then is_errmess='Error in n_ezvl::load_act_data Select from adres ['+string(shsqlca.sqldbcode)+']-'+shsqlca.sqlerrtext _onerror(shsqlca.sqldbcode); return -1 end if if shsqlca.sqlcode = 100 then return 100 adres = ladr return 0 end function *Reproduce Steps: only click on name function and translate Remarks: capacity' must greater than zero. Parameter name : capacity
OS:
Windows 10
Platform:
64-bit
Database Type:
IBM Informix
Database Version:
12.10