select * from TABLE(PNTK.GET_VOLUME_LIC( 1 , 4 ,'АВТ')) auto
union
select * from TABLE(PNTK.GET_VOLUME_LIC( 5 , 12 ,'ЖДТ')) zhd
union
select * from TABLE(PNTK.GET_VOLUME_LIC( 12 , 17 ,'ВДТ')) vod
union
select * from TABLE(PNTK.GET_VOLUME_LIC( 1 , 17 ,'ВСЕГО')) itog

SQL1822N  От источника данных "-101" получен неожиданный код ошибки "LICENCE". 
Соответствующие текст и элементы - " SQL0101N  Слишком длинный или слиш".  
SQLSTATE=560BD

SQL1822N  От источника данных "-101" получен неожиданный код ошибки "LICENCE". Соответствующие текст и элементы - " SQL0101N  Слишком длинный или слиш".

Объяснение: 

При обращении к источнику данных
сервер объединения получил от него
неожиданный код ошибки, не имеющий
эквивалента в DB2.  

 Некоторые возможные коды ошибки: 

o    4901  Попытка открыть более  15  
    указателей 

o    4902  Размер строки превысил    
    предельно допустимый ( 32  Кб)

CREATE FUNCTION PNTK.GET_VOLUME_LIC(acts integer, acts2 integer, type varchar( 10 ))
SPECIFIC GET_VOLUME_LIC
     RETURNS TABLE (amount_6 SMALLINT,
                    amount_5 SMALLINT,
                    amount_4 SMALLINT,
			amount_3 SMALLINT,
			amount_2 SMALLINT,
			amount_1 SMALLINT,
			amount_0 SMALLINT,
			ind SMALLINT,
			type varchar( 10 )
)
     LANGUAGE SQL
     READS SQL DATA
     NO EXTERNAL ACTION
     DETERMINISTIC
     RETURN
with 
LIC as
(
select 
	*	
from
	pntk.licences l
where	
	current_date not between l.arrest_start_date and l.arrest_stop_date
	and l.is_removed =  0 
	and l.id_activity_types between GET_VOLUME_LIC.acts and GET_VOLUME_LIC.acts2
)
select 
	count(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.rnn_carriers else null end) amount_6
	,count(distinct case when year(l.issue_date) = (year(current date)- 5 )  then  l.rnn_carriers else null end) amount_5
	,count(distinct case when year(l.issue_date) = (year(current date)- 4 )  then  l.rnn_carriers else null end) amount_4
	,count(distinct case when year(l.issue_date) = (year(current date)- 3 )  then  l.rnn_carriers else null end) amount_3
	,count(distinct case when year(l.issue_date) = (year(current date)- 2 )  then  l.rnn_carriers else null end) amount_2
	,count(distinct case when year(l.issue_date) = (year(current date)- 1 )  then  l.rnn_carriers else null end) amount_1
	,count(distinct case when year(l.issue_date) = (year(current date)- 0 )  then  l.rnn_carriers else null end) amount_0
	,GET_VOLUME_LIC.acts+ 1 
	,GET_VOLUME_LIC.type
from	LIC l
where	current_date between l.begining_date and l.ending_date
UNION
select 
	count(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.id_licences else null end) amount_6
	,count(distinct case when year(l.issue_date) = (year(current date)- 5 )  then  l.id_licences else null end) amount_5
	,count(distinct case when year(l.issue_date) = (year(current date)- 4 )  then  l.id_licences else null end) amount_4
	,count(distinct case when year(l.issue_date) = (year(current date)- 3 )  then  l.id_licences else null end) amount_3
	,count(distinct case when year(l.issue_date) = (year(current date)- 2 )  then  l.id_licences else null end) amount_2
	,count(distinct case when year(l.issue_date) = (year(current date)- 1 )  then  l.id_licences else null end) amount_1
	,count(distinct case when year(l.issue_date) = (year(current date)- 0 )  then  l.id_licences else null end) amount_0
	,GET_VOLUME_LIC.acts+ 2 
	,GET_VOLUME_LIC.type
from	LIC l
where	current_date between l.begining_date and l.ending_date
UNION
select 
	count(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.id_licences else null end) amount_6
	,count(distinct case when year(l.issue_date) = (year(current date)- 5 )  then  l.id_licences else null end) amount_5
	,count(distinct case when year(l.issue_date) = (year(current date)- 4 )  then  l.id_licences else null end) amount_4
	,count(distinct case when year(l.issue_date) = (year(current date)- 3 )  then  l.id_licences else null end) amount_3
	,count(distinct case when year(l.issue_date) = (year(current date)- 2 )  then  l.id_licences else null end) amount_2
	,count(distinct case when year(l.issue_date) = (year(current date)- 1 )  then  l.id_licences else null end) amount_1
	,count(distinct case when year(l.issue_date) = (year(current date)- 0 )  then  l.id_licences else null end) amount_0
	,GET_VOLUME_LIC.acts+ 3 
	,GET_VOLUME_LIC.type
from	LIC l
UNION
select 
	sum(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.summ else  0  end) amount_6
	,sum(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.summ else  0  end) amount_5
	,sum(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.summ else  0  end) amount_4
	,sum(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.summ else  0  end) amount_3
	,sum(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.summ else  0  end) amount_2
	,sum(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.summ else  0  end) amount_1
	,sum(distinct case when year(l.issue_date) = (year(current date)- 6 )  then  l.summ else  0  end) amount_0
	,GET_VOLUME_LIC.acts+ 4 
	,GET_VOLUME_LIC.type
from	LIC l