Xref: utzoo comp.os.os2.programmer:20 comp.databases:6614
Path: utzoo!attcan!uunet!wuarchive!mit-eddie!rutgers!orstcs!mist.CS.ORST.EDU!osbornk
From: osbornk@mist.CS.ORST.EDU (Kasey S. Osborn)
Newsgroups: comp.os.os2.programmer,comp.databases
Subject: OS/2 SQL Dynamic Programming
Summary: OS/2 SQL info wanted
Message-ID: <19582@orstcs.CS.ORST.EDU>
Date: 30 Jul 90 18:23:49 GMT
Sender: usenet@orstcs.CS.ORST.EDU
Organization: Computer Science Department, Oregon State Univ.
Lines: 24

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.