ADSM-L

SQL queries with ADSM V3

1998-02-16 14:54:26
Subject: SQL queries with ADSM V3
From: Julie Phinney <jphinney AT HUMANA DOT COM>
Date: Mon, 16 Feb 1998 13:54:26 -0600
I understand that one of the plusses of V3 ADSM is the ability to do
SQL-type queries against the database.  I hope it will make my reports run
faster and more efficiently, especially the outrageous ones, like Query
Contents.
I have a V2 server that runs on MVS.  I have a V3 Win 95 client.  Is it the
server that has to be V3 in order  to do these SQL-type queries?

Does this only work on small platform type ADSM servers, like NT or AIX
(will I be able to do SQL queries against my ADSM-MVS database?)

Can I use Lotus Approach or Microsoft Access to query the ADSM MVS
database?
(I'm not familiar with either of those tools right now)

If  Approach and Access are just places to store and then manipulate data
once it's been extracted, what tool do you use to do the extraction?

 I'm not familiar with ODBC or SQL at all.  I currently use OS/2 REXX to
query the ADSM database and generate daily reports.  I'm in the process of
converting my daily reports from OS/2 REXX to  TSO and SAS.   Thanks for
any insight..
Julie
<Prev in Thread] Current Thread [Next in Thread>