Re: How to SET ROLE in Informix from Powerbuilder

Posted in 1996

Scott Morizot — 17 Oct 1996 12:54:41 GMT — source: Informix-list mailing list archive (1991-1998)

Phil Yandel (pjyandel@cyberconnect.com) wrote: : How do you 'SET ROLE' on an Informix database from within Powerbuilder : 5.0? I coded "SET ROLE :as_role USING SQLCA;" in my login object when : the database was Informix, but the Powerbuilder script compiler did : not recognize the "SET" verb. I don't use Informix currently (have in the past), but my gut feeling based on similar sorts of SQL statements I've used in the past is that your code needs to look something like the following: sql_command = "SET ROLE " + as_role EXECUTE IMMEDIATE :sql_command; HTH, Scott -- +++++++++++++++++++++++++++++++++++++++++++++++ | Scott Morizot -- tmorizot@infinity.ccsi.com | | "May you live in interesting times" | +++++++++++++++++++++++++++++++++++++++++++++++