Showing results for 
Search instead for 
Did you mean: 

INFORMIX - UCCX - Select Output values of a Routine

I am trying to select output columns of a Function into a Table. Routine is executing fine as standalone but when I select its results into a Table, I get an error. I am executing the following:

select node_id C1 , resourcename C2 , callshandled C3  FROM TABLE(function sp_details_agent('2022-08-16 21:00:00','2022-08-17 20:59:59') );

Simple Execution of routine is okay i.e.

Execute function sp_details_agent('2022-08-16 21:00:00','2022-08-17 20:59:59')

// above execution gives 03 column output : node_id | resourcename | callshandled

Error is:  SQL Error (-217): Column (node_id) not found in any table in the query (or SLV is undefined).

Please advise what I am missing.

1 Reply 1

Alex Stevenson
Cisco Employee
Cisco Employee

Hi @ReportingEngineers-CC,

Is this double-quote supposed to be there?

('2022-08-16 21:00:00,"2022-08-17 20:59:59')

It seems out of place and other examples of this function I've found do not have it.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers