×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Stored Procedure attempt

Stored Procedure attempt

Stored Procedure attempt

(OP)
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;

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close