Embedded Dynamic SQL Method 4

From: Michael <michaels_at_empower.com.au>
Date: 1998/02/12
Message-ID: <01bd3804$4e496760$9d0106c0@michaels>#1/1

Can anyone please tell me a good text book to use so that I can understand more fully the way in which embedded SQL works. In particular the SQLDA structure.

What I am trying to achive is to be able to dynamically create cursors with the calling program specifing the name, then fetching from a set cursor by passing it's name. I would like to stay away from PL/SQL if at all possible.

I have also noticed that when describing into the SQLDA structure that datatypes are set to undefined if there is an SQL function such as SUM, UNION. This is using the Method 4 database access.

Thanks
Michael Senn
Empower Business Systems Received on Thu Feb 12 1998 - 00:00:00 CST