× 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.



SEQUEL, STRSQL, COBOL, RPG.... whatever. I can hammer left-handed if I need to.


I used (and enjoyed using) SEQUEL at my previous employer for 17 years. We don't have it here at my current job but I'm surviving just fine.


Jobs must be very plentiful in Jim IT's world. They sure weren't when I was out of work from 2012-2013. Even interviewed at a COBOL shop ;-))



Roger Harman
COMMON Certified Application Developer – ILE RPG on IBM i on Power
OCEAN User Group

http://www.ocean400.org



----------------------------------------
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 10:47:43 -0600

Better yet, walking away from a carpentry job when you learn that they'll
only let you use left-handed hammers.

:-)

The bottom line is that SEQUEL works, and it lets you fulfill user requests
far faster than you can with grunt programmers. The users don't care if
something is "elegant" under the covers.

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

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul
Nelson
Sent: Wednesday, February 18, 2015 10:43 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Is there an easy way to identify all the save files on a
system?

Isn't that like walking out of an interview when learning the shop uses
COBOL instead of RPG?

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


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim
It
Sent: Wednesday, February 18, 2015 10:33 AM
To: Midrange Systems Technical Discussion
Subject: RE: Is there an easy way to identify all the save files on a
system?

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



Vern,

While you are partially correct, that *LOCALSYS will allow SQL statements to
go to SQE, the problem is that SEQUEL attempts to translate the SEQUEL
syntax into a valid DB2 for i syntax, but the translation is messy at best
and does not utilize the latests join techniques.

Not that I don't like the product, but I have immediately walked out in the
middle of an interview when I was told that SEQUEL was their primary tool.

Jim
--
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.


--
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.


--
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.