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
Appeon Product 22 February, 2021
Hi Iliyan,  


Thank you for submitting the ticket.  

We now acknowledge this ticket to be an enhancement request and will record and track it internally in our enhancement management system. At the same time, we are closing the ticket here because this support system is for handling standard support services but not for maintaining enhancement requests.  

Please note that despite its "Closed" status, you are welcome to come back here and leave further comments or query the relevant development progress on this ticket.  



Amy Feng
Logan Liu @Appeon 27 May, 2020
Hi Iliyan,

Thank you for reporting this enhancement request. I will transfer it to our product team for consideration.

armando.herrera 26 May, 2020
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.   

armando.herrera 26 May, 2020
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!

iliyan iliev 26 May, 2020
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
	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

capacity' must greater than zero. Parameter name : capacity
Windows 10
Database Type:
IBM Informix
Database Version: