Re: Using a view to force SQL to SQE

Well, first, the digits function does not force CQE. CCSID translation
might, but digits by itself does not. You can check this yourself with
Visual Explain in OpsNav. Run the query with Visual explain with and
without the digits function. Scroll all the way down the right hand panel
with the "Final Select" chosen and you will see which engine processed it.

On the logical, yes you can remap, but then if you point the query at the
logical, that will force CQE since the logical is not SQL based.

Vernon Hamberg wrote:

Sorry Mike, no, it won't. A view is nothing more than a container for
an SQL SELECT statement that is executed at the time you use it. It
probably contains the access plan - not access path, like a non-SQL
logical file. The cast to character is performed at runtime, not
ongoing, as it is with a regular LF.

I believe - it has been sooooooo long - that you can use an SST
keyword in an LF to convert a zoned field to character. That would do
what you want. But it won't work with packed field.

Vern

At 05:55 AM 4/17/2007, you wrote:



We have an SQL which uses the digits function to convert a field to
character format for use in a where clause. I understand that this forces
the SQL to be despatched to the CQE. Would creating a view which performs
this transformation overcome this problem? In other words create a new
column which incorporates the digits function on the original table column
and then use the view instead of the original table in the SQL?



Regards, Mike Pantzopoulos