Re: Using a view to force SQL to SQE

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

_________________________________________________________________
Advertisement: 1000s of Sexy Singles online now at Lavalife - Click here
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Flavalife9%2Eninemsn%2Ecom%2Eau%2Fclickthru%2Fclickthru%2Eact%3Fid%3Dninemsn%26context%3Dan99%26locale%3Den%5FAU%26a%3D27782&_t=762229680&_r=lavalife_apr07_1000sexysingles&_m=EXT

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.