×
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.
Greg,
That is part of the IBM Data-Studio. To get the latest, download IBM Data-Studio:
https://www.ibm.com/products/ibm-data-studio
The only part of it that I like, is that you can easily run stored-procedures test. And you can easily see stored-procedure properties. It is sort of good to explore objects inside of schemas.
IBM Data Studio SQL interface is terrible! It is a BIG JOKE. Too complicated. Not worth trying it out! Has not been updated in 4-years! You have to set up a project, before you can write SQL. Very clunky interface. My advice, DO NOT BOTHER WITH IT!
Other than that, I like to use SquirrelSQL.org, I have it set to remember my last 9,999 sql statements. Very handy for a forgetful person like myself! DBeaver is also excellent. Love DBeavers code assist on the field names.
And of courses IBM ACS 1.1.8.6 the latest release is also very good. Released on December 7, 2020. You can prompt for both the LONG & Short names! Very nice! Supposed to have some good updates for performance.
-Ken Killian-
-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Thursday, December 10, 2020 1:50 PM
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Date Format in SQL
Not to confuse things for the OP...
But I have two perspectives in RDi (not sure where these are from):
<Run SQL> and
<IBM SQL and Routine Development>
I don't like either as well as Run SQL Scripts in ACS
midrange.com
