Mne nyzhno polychit output iz SPL
" Moy script"
create procedure "informix".OLEG1()
define total NUMERIC;
select count(*) into total from tctuserinfo b WHERE 1=1 and b.deleted =0 ;


SELECT distinct d.vendor,d.model , e.description model_type,
case when c.a=1 then "Yes" else
case when c.b=0 then "No" else
case when c.c=-1 then "Unknown" end end end
supported,total as tt,
round( ((count(*)/total)*100),3 ) percent
FROM tctimeiperhandset a, tctuserinfo b , tctmodelparameters c,
tcthandset d , tctvaluesperitem e
WHERE a.a=b.a
into temp ttt;

end procedure;

Ne komanda UNLOAD i ne OUTPUT ne pomogayut iz nytri

Spasibo

Mne kazhetsya , ya ne sovsem tochno opredelil svoy vopros.

Mne nyzhno polychit resultat select statement v output.
Obychno eto komandy : UNLOAD ili OUTPUT TO.
V moem slychae , ya ispolzyu peremennyu total , i poetomy vynyzden polzovatsay SPL. Vozmozhno est sposob , dlya togo chto by vytachit dannye v kakaoy nibyd
"textfile output"

Mne kazhetsya , ya ne sovsem tochno opredelil svoy vopros.

Mne nyzhno polychit resultat select statement v output.
Obychno eto komandy : UNLOAD ili OUTPUT TO.
V moem slychae , ya ispolzyu peremennyu total , i poetomy vynyzden polzovatsay SPL. Vozmozhno est sposob , dlya togo chto by vytachit dannye v kakaoy nibyd
"textfile output"

Ya tak tozhe sdelal, no eto ochen koryavo. Mozhet kto nibyd znaet mozhno li eto sdelat s execute immediate.???