Re: request for help

Posted in 1998

Madison Pruet — Wed, 09 Dec 1998 14:39:23 -0600 — source: Informix-list mailing list archive (1991-1998)

Couldn't you do this by using stored procedures??? Abel_Johnson@doh.state.fl.us wrote: > My IIUG Member #9768 > My firewall won't allow me to access news thru IE so I need to use > cc:mail instead. > I am running Informix V7.1 under Digital UNIX on networked Alpha 1000 > Servers, using DBACCESS to write SQL. > A typical SQL would be; > SELECT team_number, case_number, count(*) > FROM fipr > WHERE birthdate between "07/01/1998" and "09/30/1998" GROUP BY 1, 2 > > ORDER BY 1, 2;> My problem is that I cannot allow users access to DBACCESS for seurity > reasons, and I have a lot of these SQL's that are to run on a > monthly/quarterly schedule with ever changing values. ViewPoint is > beyond most of them. > Is there syntax to allow dynamic updating variable data values in SQL > at runtime. E.G., to prompt the user to input a new 'birthdate' value. > You can contact me at 'Abel_Johnson@doh.state.fl.us' or > 'Abel2@hotmail.com' Thank you for any assistance you can offer.