I can't find my original reference -- I thought there was some provided
code
that I edited. (Note comments in my code for cex2 -- example2)

---- I found it ! look at the group SAMPLEDB.SYS -- all CEX? files are C
samples !!!

But for now, I have kept in my shelf
   ALLBASE/SQL Advance Application Programming Guide (36216-90100) 1994
   ALLBASE/SQL Release F.0 Application Programming Bulletin for MPE/iX
(36216-90062) 1992
which has some example code, not necessarily complete.

Here is the command file I use to compile my C: SQLPPC.CMD

PARM srcfile, dbefile="", pgmfile, msgfile=$stdlist
COMMENT SQLPPC taken from HPSQLUDC.PUB.SYS from PPC
   setvar _savefence hpmsgfence
   setvar hpmsgfence 2
   continue
   purge !msgfile
   purge sqlout
   purge sqlmod
   purge sqlvar
   purge sqltype
   purge sqlextn
   setvar hpmsgfence _savefence
   deletevar _savefence
   file sqlin  = !srcfile
   file sqlmsg = !msgfile;rec=-80,16,f,ascii
   file sqlout;   disc=10000,32;rec=-80,16,f,ascii
   file sqlmod;   disc=1023,10,1;rec=250,,f,binary
   file sqlvar;   disc=2048,32;rec=-80,16,f,ascii
   file sqltype;  disc=2048,32;rec=-80,16,f,ascii
   file sqlextn;  disc=2048,32;rec=-80,16,f,ascii
   continue
   run psqlc.pub.sys;info="!dbefile (dynamic ANSI)"
   if jcw <= warn  then
      continue
      ccxllk sqlout,!pgmfile,$null
   endif
   reset sqlin
   reset sqlmsg
   reset sqlout
   reset sqlmod
   reset sqlvar
   reset sqltype
   reset sqlextn

When using my example, do not provide a DBE (hence the info=(dynamic
ANSI))"
You will have to change IMAGE database info for your own database.

My example prompts for the DBE, opens, selects, then closes it.
Available on request.

+=====================================
 Keven Miller   KC7LYD
 [log in to unmask]   (Salt Lake City, Utah, USA)
+=====================================