Skip to Main Content
ICA Idea Portal for SEI
Status Accepted
Workspace HC-DPS-EI: CPACS
Created by Jeremiah Spaulding
Created on Jul 29, 2020

An alternative command-line interface to databases instead of isql

No description provided
Description

isql is the default sybase command-line tool. It is very basic and lacks modern features. SQLWorkbench/j is an open-source database tool that provides a full-featured command-line experience. Combined with the JTDS driver it allows for communicating with the EA and UV databases as well.

I have built a version that also provides TAB-completion. See the attached powerpoint and demo for my current proof of concept.

As this is a done solution, only upkeep would need to be considered. My additions to the open source product could be submitted to be added to the codebase, thus reducing our future burden even more.

https://web.microsoftstream.com/video/3b492da3-2b94-4b79-ac95-1bce840f80cd

Requesting region USCAN
  • Joshua Smith
    Reply
    |
    Aug 7, 2020

    This would help support, service and anyone else who troubleshoots cpacs.