Re: HELP! Dynamic SQL statements in SPL???

Posted in 1998

Chris Dornsife — Thu, 29 Oct 1998 08:27:19 -0800 — source: Informix-list mailing list archive (1991-1998)

Ignore the last post, the solution is to use the webexplode function in your stored procedure. You can use webexplode in any SQL statement just like the server does. define qry lvarchar; define colNames lvarchar; define ..... let qry = "<?misql sql='select $colName from $tabName where $whereClause;'>$1<?/misql>"; call webexplode(qry, 'colName=whatever&tabName=someTable&where=where+id=1') returning rv; or let rv = webexplode(qry, 'colName=whatever&tabName=someTable&where=where+id=1');