Re: SQL queries with ADSM V3
1998-02-16 17:28:39
Hi Julie,
Both the server and client need to be at V3. I have the V3 client on my
workstation but, as you can see below, if I issue a simple select
statement to a V2 server, the client even refuses to acknowledge
'select' as a valid command.
adsm> select * from nodes
ANR2000E Unknown command - SELECT.
ANS8001I Return code 2.
Trevor
-----Original Message-----
From: Julie Phinney [SMTP:jphinney AT HUMANA DOT COM]
Sent: Tuesday, 17 February 1998 6:54
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL queries with ADSM V3
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
|
|
|