× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Jim

You have to use the *LOCALSYS server for SEQUEL to use SQE - if you have lots of views built over time, they are not likely to be set for that server.

If you want to use IBM i syntax, set the SYNTAX parameter to server when SERVER is *LOCALSYS.

Start your enhanced understanding of this at http://www.helpsystems.com/sequel/how-to-convert-queries-from-query400

Regards
Vern

On 2/18/2015 8:15 AM, Jim It wrote:
From: nelsonp@xxxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Is there an easy way to identify all the save files on a system?
Date: Wed, 18 Feb 2015 07:28:23 -0600

The strongest selling point is the thousands of existing queries that can be
run through the CVTQRY routine in SEQUEL and then optimized to use the SQE.

The business analysts responsible for data mining are doing this all
themselves with no assistance from the offshore programmers (none of whom
would pass muster in your shop).

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx

Are SEQUEL salesmen truly stating this to be a fact?

I can positively assure you that is most likely not the case. We have thousands and thousands of SEQUEL views and very, very few use and go through SQE.


Even worse is when you try to force SEQUEL to use a valid DB2 for i SQL statement and it pukes all over itself because SEQUEL doesn't understand native syntax.

Jim


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.