SQL Server Management Studio equivalent on AS400 platform

dking_wri
dking_wri used Ask the Experts™
on
What is the AS400 software equivalent to Query Analyzer (or Sql Server Management Studio for 2005). I"m new to AS400 and I"ve begun working at a company that has uses IBM as well as Microsoft. What software would I use to write queries and stored procedures against the AS400 database?

Thanks for your help,
David
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
VP Technology / Senior Consultant
Commented:
IBM green-screen tool is STRSQL.

IBM Windows tool is "Navigator", an optionally installable component of IBM Client Access.

- Gary Patterson

Author

Commented:
Thanks Gary. Do you happen to know the name of the .exe? I would like to search for it on our network and find this to be the easiest.

Thanks again,
David
Dave FordSoftware Developer / Database Administrator
Commented:

System i Navigator, IBM's native GUI, has a "Run SQL Scripts" option where you can run your SQL, create stored procedures, etc.

Alternately, if you're comfortable with the "green-screen" text-based interface, I use StrSql to do the same types of things. It's not as "pretty", but I find that its more productive. The error messages are a bit easier to decipher, and you can more easily interrogate other parts of the box that may affect your query. You're just "closer to the iron" there.

But, I have noticed that people under 30 years old usually possess an irrational fear of text-based interfaces, so if you're more comfortable with the GUI, then use it.

HTH,
DaveSlash
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Gary PattersonVP Technology / Senior Consultant

Commented:
Navigator is cwbunnav.exe.  You'll need to install it either from a folder that created in the AS/400, or from the Client Access installation media.  SOme shops load the Client Access installation media on the LAN, so you might want to check inthe location where other installation sources are in your network.

Here is a link to IBM's product page for Client Access (now System i Access - they change the name very year or so).  Links to ordering info, installation instructions, etc.

http://www-03.ibm.com/systems/i/software/access/

- Gary Patterson
Gary PattersonVP Technology / Senior Consultant

Commented:
BTW, I agree wholeheartedly with daveslash.  Green-screen STRSQL is what I use day-to-day.  Faster, easier, better than the GUI for most things.  Prompt support, command entry support, output to display, printer, or database file, persistent session logging, library list aware, less possibility for character set confusion (AS/400 generally stores data in EBCDIC, so Windows applications have to translate EBCDIC to ASCII on the fly.  Depending on system, file and field-level setting, your mileage may vary).

Nothing extra to install, update, and patch, since it is a terminal-mode application.  It works as fast remotely as locally, even over a very slow connection.  I can open half a dozen sessions if I need with no discernable impact on my PC or the AS/400, and it prompts me to save my session  each time I exit, so that I can pick right up where I left the last time.

- Gary Patterson

Author

Commented:
I've located iSeries Navigator but I'm not seeing an obvious place to run scripts. Am I just missing it? I'm attaching a screenshot of the application.

The green-screen option sounds good too. Is this a 3rd party emulator I have to install or do you think it is normally installed as part of iSeries? My IT dept keeps things locked down here so I doubt I could get it installed if it isn't already here.

Take a look at the screenshot and let me know what you think.

I appreciate all the help!
David
navigator.JPG
Dave FordSoftware Developer / Database Administrator

Commented:

Yes, it appears that your IT dept has locked you out of the "Database" tab in iSeries Navigator.

To start a green-screen session, right-click on Wrias400 and select "Display Emulator"

Author

Commented:
Thanks for your help.

David
Gary PattersonVP Technology / Senior Consultant

Commented:
Database component is missing.  Install it from Client Access install source, or contact the person in yor organization that administers centrally-managed Navigator to obtain rights.  It is possible to lock down Navigator so that only certain components are available, or to create a custom install that only contains certain components.

Just use STRSQL for now, assuming it is installed.  Log onto a terminal session, get to a command line,and type STRSQL.  You will get one of theree results:

Utility starts.  Life is good.
Command not found.  (SQL Developers Kit product is not installed on your system).
Not authorized to command.  See your AS/400 security officer to obtain rights.

- Gary Patterson

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial