Thanks, Qifan. That's even better. The CQD will work in Release builds as well as Debug builds.
-----Original Message----- From: Qifan Chen [mailto:[email protected]] Sent: Tuesday, March 28, 2017 3:56 PM To: [email protected] Subject: Re: CQD to turn PCODE generation off? Hi Dave, Another method is to apply CQD PCODE_OPT_LEVEL 'off'. This will turn off PCODE completely. Thanks --Qifan ________________________________ From: Dave Birdsall <[email protected]> Sent: Tuesday, March 28, 2017 5:16:56 PM To: [email protected] Subject: RE: CQD to turn PCODE generation off? Never mind. I think I found it. (Always happens just after I write an e-mail.) At the beginning of ex_expr::pCodeGenerate (exp/ExpPCodeExpGen.cpp) I see this code: if (getenv("NO_PCODE")) return ex_expr::EXPR_OK; So the answer seems to be to set the environment variable NO_PCODE (to anything) in your Linux shell, then enter sqlci. Dave -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Tuesday, March 28, 2017 3:13 PM To: [email protected] Subject: CQD to turn PCODE generation off? Hi, If memory serves, long ago in a predecessor product there was a CQD that turned off PCODE generation, forcing execution of the ex_clause's at run-time. But grepping around in sqlcomp/nadefaults.cpp I don't see it. Does anyone know off the top of their head if such a CQD still exists? And what is it? Thanks, Dave
