Access to DB2 other than SQL

Giorgio De Nunzio

Access to DB2 other than SQL
Hi. I am quite new to DB2. Somebody asked me if there exist some way, other
from SQL, to access DB2 databases from a C program (in MVS): the idea is to
get a faster access by directly calling parts of the DB2 subsystem instead
of using SQL queries.
Anybody can answer?
Thanks

Giorgio De Nunzio
[login to unmask email],it



Dr. Giorgio De Nunzio
Gruppo di Calcolo del
Dipartimento di Scienza dei Materiali
Universita' di Lecce
via Arnesano
73100 Lecce (Italy)
tel. +39 0832 320545
fax +39 0832 320548
[login to unmask email]

Ken Koleto

Re: Access to DB2 other than SQL
(in response to Giorgio De Nunzio)
Giorgio,
SQL is the only way to access DB2 data using DB2. If there were other ways
to so, the data integrity, recoverability and security controls and
processes would be compromised and therefore the value of DB2 would be
lost. Incidentally, if you haven't implemented adequate security measures
appropriate to the platform on which you are running your DB2, you risk
similar exposures.

Sorry,
Ken

Chris Blaicher

Re: Access to DB2 other than SQL
(in response to Ken Koleto)
Giorgio,

I do not know of any user-friendly way to access DB2 data without using SQL.
Obviously the OEM's such as ourselves have ways of doing it, but they are
not designed, nor intended, for general use.

I do not know why you would want to do it in any case. DB2 applications
when properly designed and optimized can be very efficient. If you need
more speed, then you probably need to tune the application or the DB2
subsystem, or both.

Chris Blaicher
BMC Software, Inc.
Austin Research Labs
[login to unmask email]

-----Original Message-----
From: Giorgio De Nunzio [mailto:[login to unmask email]
Sent: Wednesday, October 06, 1999 3:38 AM
To: [login to unmask email]
Subject: Access to DB2 other than SQL


Hi. I am quite new to DB2. Somebody asked me if there exist some way, other
from SQL, to access DB2 databases from a C program (in MVS): the idea is to
get a faster access by directly calling parts of the DB2 subsystem instead
of using SQL queries.
Anybody can answer?
Thanks

Giorgio De Nunzio
[login to unmask email],it



Dr. Giorgio De Nunzio
Gruppo di Calcolo del
Dipartimento di Scienza dei Materiali
Universita' di Lecce
via Arnesano
73100 Lecce (Italy)
tel. +39 0832 320545
fax +39 0832 320548
[login to unmask email]

Giorgio De Nunzio

Re: Access to DB2 other than SQL
(in response to Chris Blaicher)
Hi Ken and Chris, and thanks for your kind replies. My idea was to maximize
the access speed by a more direct access, but I am now convinced (by your
answers and by comments received from other DB2 gurus) that this is not a
good way to follow.
Thank you very much for your advices.
Giorgio

Marcus Davage

Re: Access to DB2 other than SQL
(in response to Giorgio De Nunzio)
I have heared of an intrepid programmer who, armed with the diagnosis guide
and notes from the DB2 internals course, wrote an assembler program to
access the underlying linear VSAM data set of a DB2 tablespace. His reason
was curiosity rather than performance. Of course, should IBM wish to change
the page layout in a new release, the program becomes invalid.

Marcus

-----Original Message-----
From: Giorgio De Nunzio [mailto:[login to unmask email]
Sent: 08 October 1999 11:14
To: [login to unmask email]
Subject: Re: Access to DB2 other than SQL


Hi Ken and Chris, and thanks for your kind replies. My idea was to maximize
the access speed by a more direct access, but I am now convinced (by your
answers and by comments received from other DB2 gurus) that this is not a
good way to follow.
Thank you very much for your advices.
Giorgio

---------------------------------------------------------------------------
This Email is intended for the exclusive use of the addressee only.
If you are not the intended recipient, you should not use the
contents nor disclose them to any other person and you should
immediately notify the sender and delete the Email.

Lloyds TSB Bank plc is registered in England and Wales no. 2065.
Registered office: 71 Lombard Street, London, EC3P 3BS.

Lloyds TSB Scotland plc is registered in Scotland no. 95237.
Registered office: Henry Duncan House, 120 George Street,
Edinburgh, EH2 4LH.
---------------------------------------------------------------------------