Re: Another IDS Feature Request

Madison Pruet said >1) I'd like to have a pre-existing statements and declared cursors so that my application can just attach to them. That's me, I said that. You of course mean pre-existing prepared statements, ready to pass values into. I provided actually syntax that would work well in here somewhere. create prepared statement employee_record(eid) as select ... where employee_id = eid ; Note the clever use of a variable instead of a question mark in case the same column value is used multiple times in the query you don't have to pass it twice. create prepared statement employee_service_record(eid,service_date) as select ... where employee_id = eid and effective_date >= service_date and termination_date > service_date ;