Re: Using a view to force SQL to SQE

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.