[comp.os.os2.programmer] OS/2 SQL Dynamic Programming

osbornk@mist.CS.ORST.EDU (Kasey S. Osborn) (07/31/90)

I'm writing an application that uses the dynamic varying-list
capabilities of the OS/2 1.2 SQL API and have a few questions:

1. Can the sqlda structure be used for updates and inserts?
2. Is there a pseudo-attribute that uniquely qualifies each tuple
   such as Ingres's TID attribute?
3. I need to call functions such as 'sqlacall' directly to
   dynamically allocate cursors.  Any tips?

I guess what I really need is a good reference on programming the
database manager.  I have H. Fosdicks book "OS/2 Database Manager,
A Developer's Guide".  It is a good reference for static SQL
programming but is inadequate for anyone wanting to manipulate the
nuts and bolts of the SQL API.  Can anyone recommend a book?

I've heard of the manual "IBM OS/2 Extended Edition Database
Manager Reference".  Can anyone recommend it?  Does anyone know
the ISBN number and price?

What I *really* want is a .HLP file like the ones you get with the
OS/2 Toolkit.  These are most excellent.  Does this file exist for
the SQL API?

Thanks for any help.