Share & Communicate your SQL with Style Kent Milligan – IBM Technology Expert Labs
The Run SQL Scripts tool provided by IBM i Access Client
Solutions (ACS) does a great job of making an SQL statement more understandable
with its color highlighting of SQL keywords and its formatting of the statement
text.
I think you would agree that it would be great if that same
highlighting and formatting could ride along with your SQL statement text to
make it clearer to your peers when sharing your SQL via email, presentations, design docs, etc. This actually is possible – assuming that you have ACS 1.1.9.2
or later installed on your workstation.
The Run SQL Scripts auto-prompting
support for host variables and parameter markers got all the fanfare when
ACS 1.1.9.2 was released, but this version of ACS also delivered Rich Text Format copy
capabilities. Without this new capability, the following figure shows how the SQL
syntax highlighting disappears when an SQL statement text is copied from Run
SQL Scripts to a word processing tool or an email.Now that the Run SQL Scripts
copy captures the rich text format (i.e., color highlighting) associated with your SQL statement, you’ll
be able to choose the highlighted Paste Option on the left as shown below to preserve the
source statement format when performing a paste operation.Once
you select the highlighted Keep Source Formatting paste option in the prior figure, the SQL will be transformed
back to the highlighted and formatted SQL statement as shown below. It’s the same stylish presentation as Run SQL
Scripts, but available in a different medium.Hopefully, it’s now clear to how newer versions of ACS enable you to
communicate and share your SQL statement text in a more comprehensible format. Read More
Eliminate the Impact of Planned Downtime on Your IBM i
Tue, Sep 19, 2023 12:00 PM CDT (7:00 PM Europe/Stockholm) Read More
Execute basic Valence Portal functions “mouse-free” rswanson
Execute basic Valence Portal functions “mouse-free”
rswanson
Mon, 08/21/2023 – 12:01
Posted on August 21, 2023
As seasoned users and developers on IBM i, many of us cut our teeth on the platform back in its hallowed green-screen days. This was an era dominated by heads-down typing, tabs, field exits and function keys. All conveniently at our fingertips.
With that interface ingrained in our history, having to physically remove a hand from our trusty keyboard, reach for a mouse and (gasp!) click on something to trigger an action can sometimes feel like an inefficient annoyance — a tangible slowdown to our rapid-fire entry of text or code.
So, in deference to those memories, and by popular request from a number of customers, we’ve recently introduced some nifty keyboard shortcuts to make it possible to quickly maneuver through the Valence Portal sans mouse.
Effective with build 6.2.20230721.0, the following keyboard shortcuts can be used after logging into the Valence desktop portal:
shift + ctrl + spacebar = show launchpad… Instantly minimizes all apps and goes back to the launchpad.
shift + ctrl + d = show app drawer … Equivalent to clicking on the drawer button in the upper left of the portal header.
shift + ctrl + q = quit the active application … Closes the application you’re currently in and returns you to the prior application, or back to the launchpad if no other applications are open; Hitting this while no applications are open will log you out of the portal.
shift + ctrl + l = lock the portal … A convenient way to quickly lock your portal session before walking away.
shift + ctrl + s = search … Quickly find and jump into another application (equivalent to clicking on the search icon in the portal header). Type the first few letters of the desired application, then hit ENTER to launch.
shift + ctrl + u = access user settings … Brings up the panel to adjust portal appearance or designate auto-start apps
shift + ctrl + left/right arrow = jump between active apps … Move from one active app to another without clicking
In the event you forget any of these shortcuts, click on the keyboard icon in the portal config window (upper right) to see a cheat sheet.
CategoryTip of the Month Read More
Mastering API Testing Profound Logic
Today’s digital landscape is ever-evolving and over the past decade, APIs have become the linchpin of modern software development. APIs allowed separate systems to communicate seamlessly, empowering businesses to innovate, scale, and deliver enhanced user experiences. Unfortunately, the road toward successful API integration is riddled with challenges that require robust testing strategies. This is where we Read More