ISQL vs. Ops Nav

[Guest.Visitor]

One of the highlights of ISQL is the ability to prompt for field names. I see nothing like this in Ops Nav. Am I missing something?

[Guest.Visitor]

I too would like to know what the use of OPS Nav SQL is... I use ISQL for quick chores and syntax when putting together a stmt for VBA. Naturally I have to take out the 400 specific syntax. What would be useful is to be able to use OPS nav to build and test SQL stmts to be placed in your PC side code. I also use MS Query to build stmts.

[Guest.Visitor]

Ron, To use SQL from Ops Nav, you will need the Express version. You will also want one of the latest releases. Once you have CA Express set up, start Ops Nav and right-click on the database tab. It will bring up selections, including Run SQL Statements. Select that and point it at your system. You will probably want to go to the connection drop down menu and change the naming to *SYS from *SQL. If you do not you will have to use '.' instead of '/' in your statements. Another way to build SQL is to use the SQL wizard that comes with WebSphere Development Tools. To get to this start WebSphere Studio and go to the tools drop down menu. Select SQL Wizard. The first screen takes a long time to come up after you specify your connection. David Morris

[Guest.Visitor]

FYI - I don't have CA Express loaded and run SQL via OPS NAV. Parts of Websphere are free/included. Is the wizard part of this group? If so is it dependant on CA Express? We are evaluating whether to use Websphere or something else, and haven't purchased/committed yet. How do you get to it if it's a freebie. Tx