Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure attempt

Status
Not open for further replies.

kray4660

MIS
Apr 7, 2008
1,054
US
We have an informix database supplied by the vendor. I attempted to create a simple stored procedure (see code below). Unfortunately I only got an syntax error. We do not know if the user supplied by the vendor has sufficient rights to create a stored procedure. I am using TOAD to execute the code. Any suggestions?

CREATE PROCEDURE SP_TUL_TEST_Query
FOREACH
select csqname
, loggedinagents
, availableagents
, unavailableagents
, callswaiting
, case when oldestcontact = 0 then 0
else ROUND(oldestcontact / 1000,0)
end as oldestcontact
, totalcalls
, callshandled
, callsabandoned
, callsdequeued
, case when avgtalkduration = 0 then 0
else Round(avgtalkduration / 1000,0)
end as avgtalkduration
, case when avgwaitduration = 0 then 0
else ROUND(avgwaitduration / 1000,0)
end as avgwaitduration
, case when longesttalkduration = 0 then 0
else ROUND(longesttalkduration / 1000,0)
end as longesttalkduration
, case when longestwaitduration = 0 then 0
else ROUND(longestwaitduration / 1000,0)
end as longestwaitduration
, enddatetime
, workingagents
, talkingagents
, reservedagents
, startdatetime
from RtCSQsSummary;
END FOREACH
END PROCEDURE;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top