Unit SDCsb

*****************************************************} { } { SQLDirect Component Library } { for Delphi & Delphi 2 } { ( SQLBase Ver.6 ) } { Copyright (c) 1995,98 by Yuri Sheino } { } { Author: Yuri Sheino } { e-mail: sheino@cit.org.by } { WWW: www.cit.org.by/users/sheino } { www.cit.org.by/users/sheino/sqldir.htm } { } { Free to use and redistribute with applications. } { You can not: } { - distribute library source code without } { permission from author; } { - distribute modified versions of the Library, } { in whole or in part; } { - rent or lease the Library. } { No warranty is given by the author, expressed } { or implied. } { } {

Classes

Functions

SqlArf - Sql FUNCTION PROTOTYPES } {$IFDEF WIN32} (******************************** for Win32

************************** for Win32
SqlBbr -
SqlBdb -
SqlBef -
SqlBer -
SqlBkp -
SqlBld -
SqlBlf -
SqlBlk -
SqlBln -
SqlBna -
SqlBnd -
SqlBnn -
SqlBnu -
SqlBss -
SqlCan -
SqlCbv -
SqlCdr -
SqlCex -
SqlClf -
SqlCmt -
SqlCnc -
SqlCnr -
SqlCom -
SqlCon -
SqlCpy -
SqlCre -
SqlCrf -
SqlCrs -
SqlCsv -
SqlCty -
SqlDbn -
SqlDed -
SqlDel -
SqlDes -
SqlDid -
SqlDii -
SqlDin -
SqlDir -
SqlDis -
SqlDon -
SqlDox -
SqlDrc -
SqlDro -
SqlDrr -
SqlDrs -
SqlDsc -
SqlDst -
SqlDsv -
SqlEbk -
SqlEfb -
SqlElo -
SqlEnr -
SqlErf - function SqlEpo(Cur: SQLTCUR; epo: SQLTEPO PTR): SqlTApi; stdcall;

function SqlEpo; external SqlApi_DLL name 'sqlepo';
SqlErr -
SqlErs -
SqlEtx -
SqlExe -
SqlExp -
SqlFbk -
SqlFer -
SqlFet -
SqlFgt -
SqlFpt -
SqlGbi - function SqlFqn(Cur: SQLTCUR; field: SQLTFLD; nameptr: SQLTDAP; namelen: SQLTDAL PTR): SqlTApi; stdcall;

function SqlFqn; external SqlApi_DLL name 'sqlfqn';
SqlGet - function SqlGdi(Cur: SQLTCUR; gdi: SQLTPGD): SqlTApi; stdcall;

function SqlGdi; external SqlApi_DLL name 'sqlgdi';
SqlGfi -
SqlGls -
SqlGnl -
SqlGnr -
SqlGsi -
SqlIdb -
SqlIms -
SqlInd -
SqlIni -
SqlIns -
SqlLab -
SqlLdp -
SqlLsk -
SqlMcl -
SqlMdl -
SqlMop -
SqlMrd -
SqlMsk -
SqlMwr -
SqlNbv -
SqlNii -
SqlNrr -
SqlNsi -
SqlOms -
SqlPrs -
SqlRbf -
SqlRbk -
SqlRcd -
SqlRdb -
SqlRdc -
SqlRel -
SqlRes -
SqlRet -
SqlRlf -
SqlRlo -
SqlRof -
SqlRow -
SqlRrd -
SqlRrs -
SqlRsi -
SqlRss -
SqlSab -
SqlSap -
SqlScl -
SqlScn -
SqlScp -
SqlSdn -
SqlSds -
SqlSdx -
SqlSet -
SqlSil -
SqlSlp -
SqlSpr -
SqlSrf -
SqlSrs -
SqlSsb -
SqlSss -
SqlSta -
SqlStm -
SqlSto -
SqlStr -
SqlSxt -
SqlTec - function SqlSys(Cur: SQLTCUR; sys: SQLTSYS PTR): SqlTAPI; stdcall;

function SqlSys; external SqlApi_DLL name 'sqlsys';
SqlTem -
SqlTio -
SqlUnl -
SqlUrs -
SqlWdc -
SqlWlo -
SqlXad -
SqlXcn -
SqlXda -
SqlXdp -
SqlXdv -
SqlXer -
SqlXml -
SqlXnp -
SqlXpd -
SqlXsb -

Types

byte1
byte2
byte4
SqlTApi
SqlTARC
SqlTBIR
SqlTBirPtr
SqlTBNL
SqlTBNN
SqlTBNP
SqlTBOO
SqlTCDL
SqlTCdlPtr
SqlTCHL
SqlTChlPtr
SqlTCHO
SqlTCHP
SqlTCLL
SqlTCTY
SqlTCUR
SqlTCurPtr
SqlTDAL
SqlTDalPtr
SqlTDAP
SqlTDAY
SqlTDDL
SqlTDdlPtr
SqlTDDT
SqlTDdtPtr
SqlTDEDL
SqlTDIS
SqlTDPT
SqlTDPV
SqlTEPO
SqlTFAT
SqlTFLD
SqlTFLG
SqlTFLH
SqlTFlhPtr
SqlTFMD
SqlTFNL
SqlTFNP
SqlTFSC
SqlTFscPtr
SqlTILV
SqlTLBL
SqlTLBP
SqlTLNG
SqlTLngPtr
SqlTLSI
SQLTLSIPtr
SqlTMSZ
SqlTNBV
SqlTNbvPtr
SqlTNCU
SqlTNML
SqlTNmlPtr
SqlTNMP
SqlTNPG
SqlTNSI
SqlTNsiPtr
SqlTNUL
SqlTPCX
SqlTPDL
SqlTPDT
SqlTPfp
SqlTPGN
SqlTPID
SqlTPNM
SqlTPnmPtr
SqlTPRE
SqlTPrePtr
SqlTPTY
SqlTRBF
SqlTRbfPtr
SqlTRCD
SqlTRcdPtr
SqlTRCF
SqlTRFM
SqlTROW
SqlTRowPtr
SqlTSCA
SqlTScaPtr
SqlTSLC
SqlTSTC
SqlTSVH
SqlTSVN
SqlTTIV
SqlTWNC
SqlTWSI
SqlTXER
SqlTXerPtr
ubyte1
ubyte1p
ubyte2
ubyte4

Constants

FetchDel
FetchEof
FetchOk
FetchUpd
FetRDnd
FetRDnn
FetRDtn
FetRNof
FetRNul
FetRSin
FetRTru
SQLB204
SQLBALB
SQLBAPP
SQLBAS4
SQLBDAL
SQLBDB2
SQLBDB4
SQLBDBA
SQLBDBC
SQLBDBM
SQLBEDA
SQLBFUJ
SQLBIGW
SQLBING
SQLBIOD
SQLBIOL
SQLBIOS
SQLBMIM
SQLBNOL
SQLBNSE
SQLBNTW
SQLBODB
SQLBOL6
SQLBOR7
SQLBORA
SQLBRDB
SQLBS10
SQLBSDS
SQLBSE6
SQLBSES
SQLBSHR
SQLBSQB
SQLBSQL
SQLBSUP
SQLBSYB
SQLBTDM
SQLBUDS
SqlDBoo
SqlDChr
SqlDDat
SqlDDte
SqlDDtm
SqlDHdl
SqlDLon
SqlDNum
SqlDTim
SqlEBin
SqlEBoo
SqlEChr
SqlEDat
SqlEDec
SqlEDou
SqlEFlo
SqlEGph
SqlEInt
SqlELbi
SqlELch
SqlELgp
SqlELon
SqlELvr
SqlEMon
SqlESma
SqlETim
SqlETms
SqlEVar
SqlEVbi
SqlEVgp
SQLFICS
SQLFIRL
SQLFIRO
SQLFIRR
SQLILCS
SQLILRL
SQLILRO
SQLILRR
SQLMAUF
SQLMAWS
SQLMBNL
SQLMBSL
SQLMCG0
SQLMCG1
SQLMCKF
SQLMCLL
SQLMCLN
SQLMCLP
SQLMCMT
SQLMCNM
SQLMCOH
SQLMCST
SQLMCTL
SQLMDBA
SQLMDFN
SQLMDMO
SQLMDNM
SQLMDVL
SQLMERR
SQLMETX
SQLMEXS
SQLMFNL
SQLMFQN
SQLMFRD
SQLMGCM
SQLMGTI
SQLMICO
SQLMICU
SQLMIDB
SQLMILK
SQLMINL
SQLMIPG
SQLMIPR
SQLMITM
SQLMITR
SQLMJTB
SQLMLFE
SQLMLFS
SQLMLID
SQLMMID
SQLMNBF
SQLMNCO
SQLMNPF
SQLMOSR
SQLMOUL
SQLMPAG
SQLMPAL
SQLMPFS
SQLMPKL
SQLMPNM
SQLMPRE
SQLMPSS
SQLMPTL
SQLMPWD
SQLMRBB
SQLMRCB
SQLMRET
SQLMRFH
SQLMROB
SQLMSES
SQLMSID
SQLMSLI
SQLMSNM
SQLMSRL
SQLMSVN
SQLMTFS
SQLMTHM
SQLMTMO
SQLMTSS
SQLMUCO
SQLMUSR
SQLMVER
SQLMXER
SQLMXLF
SQLNPTR
SQLP2PP
SQLPAID
SQLPAIO
SQLPALG
SQLPANL
SQLPAPT
SQLPAUT
SQLPAWS
SQLPBLK
SQLPBRN
SQLPBRS
SqlPBuf
SQLPCAC
SQLPCAP
SQLPCCK
SQLPCGR
SQLPCHS
SQLPCIS
SQLPCLG
SQLPCLI
SQLPCLN
SQLPCMP
SQLPCPG
SQLPCPT
SQLPCSD
SQLPCSR
SQLPCSV
SQLPCTF
SQLPCTI
SQLPCTL
SQLPCTS
SQLPCTY
SQLPCUN
SQLPCVC
SQLPCXP
SqlPDat
SQLPDB2
SQLPDBD
SQLPDBM
SQLPDBN
SQLPDBS
SQLPDDB
SQLPDDR
SQLPDIO
SQLPDIS
SQLPDLK
SQLPDMO
SqlPDou
SQLPDPW
SqlPDte
SQLPDTL
SqlPDtm
SQLPDTR
SQLPDUS
SqlPEbc
SQLPEMT
SQLPERF
SQLPEXE
SQLPEXP
SQLPEXS
SQLPFAT
SqlPFlt
SQLPFNM
SQLPFPT
SQLPFRS
SQLPFT
SQLPGBC
SQLPGCD
SQLPGCM
SQLPGRS
SQLPHEP
SQLPHFS
SQLPIMB
SQLPINT
SQLPISO
SQLPLAT
SqlPLbi
SQLPLBM
SQLPLCK
SQLPLDR
SQLPLDV
SQLPLFF
SQLPLFS
SQLPLGF
SQLPLOC
SqlPLon
SQLPLRD
SQLPLSS
SqlPLvr
SQLPMID
SQLPMUL
SqlPNbu
SQLPNCK
SQLPNCT
SQLPNDB
SQLPNID
SQLPNIE
SQLPNLB
SQLPNLG
SQLPNPB
SQLPNPF
SqlPNst
SqlPNum
SQLPOBL
SQLPOCL
SQLPOFF
SQLPOMB
SQLPOOJ
SQLPOPL
SQLPOSR
SQLPOVR
SQLPPAR
SQLPPCX
SQLPPDB
SQLPPLF
SQLPPLV
SQLPPRF
SQLPPSW
SQLPPTH
SQLPPWD
SQLPREC
SQLPREF
SQLPRES
SQLPRFE
SQLPRID
SQLPROD
SQLPROM
SQLPROT
SQLPRTO
SQLPRUN
SqlPSch
SQLPSCL
SQLPSCR
SQLPSIL
SqlPSin
SqlPSlo
SQLPSMN
SqlPSpd
SQLPSPF
SqlPSsh
SQLPSTA
SQLPSTC
SQLPSTF
SqlPStr
SQLPSVN
SQLPSWR
SQLPTCO
SQLPTFN
SQLPTHM
SqlPTim
SQLPTMO
SQLPTMS
SQLPTMZ
SQLPTPD
SQLPTRC
SQLPTRF
SQLPTSL
SQLPTSS
SQLPTST
SQLPTTP
SqlPUch
SQLPUED
SQLPUID
SqlPUin
SqlPUlo
SqlPUpd
SqlPUsh
SQLPUSR
SQLPVER
SQLPWFC
SQLPWKA
SQLPWKL
SQLPWTO
SqlSCda
SqlSCde
SqlSCti
SqlSDat
SqlSDte
SqlSFem
SqlSFes
SqlSNum
SqlSRid
SqlSTex
SqlSTim
SqlTACM
SqlTACO
SqlTADA
SqlTADB
SqlTAFK
SqlTAPK
SqlTAPW
SqlTARU
SqlTASG
SqlTAUD
SqlTBGT
SqlTCBT
SqlTCCT
SqlTCDA
SqlTCDB
SqlTCET
SqlTCFL
SqlTCHN
SqlTCIN
SqlTCKI
SqlTCKT
SqlTCMT
SqlTCOM
SqlTCOT
SqlTCPT
SqlTCRA
SqlTCRD
SqlTCRO
SqlTCRT
SqlTCRX
SqlTCSD
SqlTCSG
SqlTCST
SqlTCSY
SqlTCTB
SqlTCTD
SqlTCVW
SqlTCXN
SqlTDCO
SqlTDDA
SqlTDDB
SqlTDED
SqlTDEL
SqlTDFK
SqlTDFL
SqlTDIN
SqlTDPK
SqlTDRU
SqlTDSG
SqlTDSY
SqlTDTB
SqlTDVW
SqlTENT
SqlTFRN
SqlTGEP
SqlTGRC
SqlTGRD
SqlTGRP
SqlTGRR
SqlTIND
SqlTINS
SqlTLAB
SqlTLDP
SqlTMCO
SqlTMRU
SqlTOPL
SqlTPOS
SqlTPRO
SqlTPRT
SqlTRBK
SqlTRBS
SqlTRCO
SqlTRCT
SqlTREC
SqlTRED
SqlTREE
SqlTREP
SqlTRER
SqlTRPT
SqlTRTB
SqlTRXN
SqlTSCL
SqlTSDS
SqlTSEL
SqlTSTF
SqlTSTN
SqlTSTP
SqlTSTR
SqlTSVP
SqlTTGC
SqlTTGD
SqlTUDS
SqlTUNL
SqlTUPD
SqlTVNC
SqlTVND
SqlTWAI
SqlTXDL
SqlTXDU

Variables


Functions


function SqlArf(Cur: SQLTCUR; fnp: SQLTFNP; fnl: SQLTFNL; cho: SQLTCHO): SqlTAPI;

Sql FUNCTION PROTOTYPES } {$IFDEF WIN32} (******************************** for Win32

************************** for Win32


function SqlBbr(Cur: SQLTCUR; errno: SQLTXERPTR; errbuf: SQLTDAP; buflen: SQLTDALPTR; errrow: SQLTBIRPTR; rbf: SQLTRBFPTR; errseq: SQLTBIR): SqlTAPI;


function SqlBdb(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; bkpdir: SQLTFNP; bkpdirl: SQLTFNL; local: SQLTBOO; over: SQLTBOO): SqlTAPI;


function SqlBef(Cur: SQLTCUR): SqlTAPI;


function SqlBer(Cur: SQLTCUR; rcd: SQLTRCDPTR; errrow: SQLTBIRPTR; rbf: SQLTRBFPTR; errseq: SQLTBIR): SqlTAPI;


function SqlBkp(Cur: SQLTCUR; defalt: SQLTBOO; overwrt: SQLTBOO; bkfname: SQLTFNP; bkflen: SQLTFNL): SqlTAPI;


function SqlBld(Cur: SQLTCUR; bnp: SQLTBNP; bnl: SQLTBNL): SqlTAPI;


function SqlBlf(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; bkpdir: SQLTFNP; bkpdirl: SQLTFNL; local: SQLTBOO; over: SQLTBOO): SqlTAPI;


function SqlBlk(Cur: SQLTCUR; blkflg: SQLTFLG): SqlTAPI;


function SqlBln(Cur: SQLTCUR; bnn: SQLTBNN): SqlTAPI;


function SqlBna(Cur: SQLTCUR; bnp: SQLTBNP; bnl: SQLTBNL; dap: SQLTDAP; dal: SQLTDAL; sca: SQLTSCA; pdt: SQLTPDT; nli: SQLTNUL): SqlTAPI;


function SqlBnd(Cur: SQLTCUR; bnp: SQLTBNP; bnl: SQLTBNL; dap: SQLTDAP; dal: SQLTDAL; sca: SQLTSCA; pdt: SQLTPDT): SqlTAPI;


function SqlBnn(Cur: SQLTCUR; bnn: SQLTBNN; dap: SQLTDAP; dal: SQLTDAL; sca: SQLTSCA; pdt: SQLTPDT): SqlTAPI;


function SqlBnu(Cur: SQLTCUR; bnn: SQLTBNN; dap: SQLTDAP; dal: SQLTDAL; sca: SQLTSCA; pdt: SQLTPDT; nli: SQLTNUL): SqlTAPI;


function SqlBss(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; bkpdir: SQLTFNP; bkpdirl: SQLTFNL; local: SQLTBOO; over: SQLTBOO): SqlTAPI;


function SqlCan(Cur: SqlTCUR): SqlTAPI;


function SqlCbv(Cur: SqlTCUR): SqlTAPI;


function SqlCdr(sHandle: SQLTSVH; Cur: SqlTCUR): SqlTAPI;


function SqlCex(Cur: SqlTCUR; pData: SqlTDAP; lData: SqlTDAL): SqlTAPI;


function SqlClf(Cur: SqlTSVH; LogFile: SqlTDAP; StartFlag: SqlTFMD): SqlTAPI;


function SqlCmt(Cur: SqlTCur): SqlTAPI;


function SqlCnc(Cur: SqlTCurPtr; pDbname: SqlTDAP; lDbName: SqlTDAL): SqlTAPI;


function SqlCnr(var Cur: SqlTCUR; pDbname: SqlTDAP; lDbName: SqlTDAL): SqlTAPI;


function SqlCom(Cur: SqlTCUR; pCmd: SqlTDAP; lCmd: SqlTDAL): SqlTAPI;


function SqlCon(var Cur: SqlTCUR; pDbName: SqlTDAP; lDbname: SqlTDAL; CurSiz: SqlTWSI; Pages: SqlTNPG; Recovr: SqlTRCF; OutSize: SqlTDAL; InSize: SqlTDAL): SqlTAPI;


function SqlCpy(fcur: SQLTCUR; selp: SQLTDAP; sell: SQLTDAL; tcur: SQLTCUR; isrtp: SQLTDAP; isrtl: SQLTDAL): SqlTApi;


function SqlCre(shandle: SQLTSVH; dbnamp: SQLTDAP; dbnaml: SQLTDAL): SqlTApi;


function SqlCrf(shandle: SQLTSVH; dbnam: SQLTDAP; dbnaml: SQLTDAL): SqlTApi;


function SqlCrs(cur: SQLTCUR; rsp: SQLTDAP; rsl: SQLTDAL): SqlTApi;


function SqlCsv(var shandlep: SQLTSVH; serverid: SQLTDAP; password: SQLTDAP): SqlTApi;


function SqlCty(cur: SQLTCUR; var cty: SQLTCTY): SqlTApi;


function SqlDbn(serverid: SQLTDAP; buffer: SQLTDAP; length: SQLTDAL): SqlTApi;


function SqlDed(shandle: SQLTSVH; dbnamp: SQLTDAP; dbnaml: SQLTDAL): SqlTApi;


function SqlDel(shandle: SQLTSVH; dbnamp: SQLTDAP; dbnaml: SQLTDAL): SqlTApi;


function SqlDes(cur: SQLTCUR; slc: SQLTSLC; ddt: SQLTDDTPtr; ddl: SQLTDDLPtr; chp: SQLTCHP; chlp: SQLTCHLPtr; prep: SQLTPREPtr; scap: SQLTSCAPtr): SqlTApi;


function SqlDid(dbname: SQLTDAP; dbnamel: SQLTDAL): SqlTApi;


function SqlDii(Cur: SQLTCUR; ivn: SQLTSLC; inp: SQLTDAP; inlp: SQLTCHLPtr): SqlTApi;


function SqlDin(dbnamp: SQLTDAP; dbnaml: SQLTDAL): SqlTApi;


function SqlDir(srvno: SQLTSVN; buffer: SQLTDAP; length: SQLTDAL): SqlTApi;


function SqlDis(cur: SQLTCUR): SqlTApi;


function SqlDon: SqlTApi;


function SqlDox(shandle: SQLTSVH; dirnamep: SQLTDAP; fattr: SQLTFAT): SqlTApi;


function SqlDrc(cur: SQLTSVH): SqlTApi;


function SqlDro(shandle: SQLTSVH; dirname: SQLTDAP): SqlTApi;


function SqlDrr(shandle: SQLTSVH; filename: SQLTDAP): SqlTApi;


function SqlDrs(cur: SQLTCUR; rsp: SQLTDAP; rsl: SQLTDAL): SqlTApi;


function SqlDsc(Cur: SQLTCUR; slc: SQLTSLC; edt: SQLTDDTPtr; edl: SQLTDDLPtr; chp: SQLTCHP; chlp: SQLTCHLPtr; prep: SQLTPREPtr; scap: SQLTSCAPtr): SqlTApi;


function SqlDst(cur: SQLTCUR; cnp: SQLTDAP; cnl: SQLTDAL): SqlTApi;


function SqlDsv(shandle: SQLTSVH): SqlTApi;


function SqlEbk(Cur: SQLTCUR): SqlTApi;


function SqlEfb(Cur: SQLTCUR): SqlTApi;


function SqlElo(Cur: SQLTCUR): SqlTApi;


function SqlEnr(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL): SqlTApi;


function SqlErf(Cur: SQLTCUR): SqlTApi;

function SqlEpo(Cur: SQLTCUR; epo: SQLTEPO PTR): SqlTApi; stdcall;

function SqlEpo; external SqlApi_DLL name 'sqlepo';


function SqlErr(error: SQLTRCD; msg: SQLTDAP): SqlTApi;


function SqlErs(Cur: SQLTCUR): SqlTApi;


function SqlEtx(error: SQLTRCD; msgtyp: SQLTPTY; bfp: SQLTDAP; bfl: SQLTDAL; var txtlen: SQLTDAL): SqlTApi;


function SqlExe(Cur: SQLTCUR): SqlTApi;


function SqlExp(Cur: SQLTCUR; buffer: SQLTDAP; length: SQLTDAL): SqlTApi;


function SqlFbk(Cur: SQLTCUR): SqlTApi;


function SqlFer(error: SQLTRCD; msg: SQLTDAP): SqlTApi;


function SqlFet(Cur: SQLTCUR): SqlTApi;


function SqlFgt(Cur: SQLTSVH; srvfile: SQLTDAP; lcfile: SQLTDAP): SqlTApi;


function SqlFpt(Cur: SQLTSVH; srvfile: SQLTDAP; lclfile: SQLTDAP): SqlTApi;


function SqlGbi(Cur: SQLTCUR; pcur: SQLTCURPtr; ppnm: SQLTPNMPtr): SqlTApi;

function SqlFqn(Cur: SQLTCUR; field: SQLTFLD; nameptr: SQLTDAP; namelen: SQLTDAL PTR): SqlTApi; stdcall;

function SqlFqn; external SqlApi_DLL name 'sqlfqn';


function SqlGet(Cur: SQLTCUR; parm: SQLTPTY; p: SQLTDAP; l: SQLTDALPtr): SqlTApi;

function SqlGdi(Cur: SQLTCUR; gdi: SQLTPGD): SqlTApi; stdcall;

function SqlGdi; external SqlApi_DLL name 'sqlgdi';


function SqlGfi(Cur: SQLTCUR; slc: SQLTSLC; cvl: SQLTCDLPtr; fsc: SQLTFSCPtr): SqlTApi;


function SqlGls(Cur: SQLTCUR; slc: SQLTSLC; size: SqlTLsiPtr): SqlTApi;


function SqlGnl(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; lognum: SQLTLNGPtr): SqlTApi;


function SqlGnr(Cur: SQLTCUR; tbnam: SQLTDAP; tbnaml: SQLTDAL; rows: SQLTROWPtr): SqlTApi;


function SqlGsi(shandle: SQLTSVH; infoflags: SQLTFLG; buffer: SQLTDAP; buflen: SQLTDAL; rbuflen: SQLTDALPtr): SqlTApi;


function SqlIdb(Cur: SQLTCUR): SqlTAPI;


function SqlIms(Cur: SQLTCUR; InSize: SQLTDAL): SqlTAPI;


function SqlInd(sHandle: SQLTSVH; pDbName: SQLTDAP; lDbName: SQLTDAL): SqlTAPI;


function SqlIni(CallBack: SQLTPFP): SqlTAPI;


function SqlIns(SrvNo: SQLTSVN; DbName: SQLTDAP; lDbName: SQLTDAL; CreateFlag: SQLTFLG; OverWrite: SQLTFLG): SqlTAPI;


function SqlLab(Cur: SQLTCUR; slc: SQLTSLC; lbp: SQLTCHP; lblp: SQLTCHLPTR): SqlTAPI;


function SqlLdp(Cur: SQLTCUR; cmdp: SQLTDAP; cmdl: SQLTDAL): SqlTAPI;


function SqlLsk(Cur: SQLTCUR; slc: SQLTSLC; pos: SQLTLSI): SqlTAPI;


function SqlMcl(shandle: SQLTSVH; fd: SQLTFLH): SqlTAPI;


function SqlMdl(shandle: SQLTSVH; filename: SQLTDAP): SqlTAPI;


function SqlMop(shandle: SQLTSVH; fdp: SQLTFLHPTR; filename: SQLTDAP; openmode: SQLTFMD): SqlTAPI;


function SqlMrd(shandle: SQLTSVH; fd: SQLTFLH; buffer: SQLTDAP; len: SQLTDAL; rlen: SQLTDALPTR): SqlTAPI;


function SqlMsk(shandle: SQLTSVH; fd: SQLTFLH; offset: SQLTLNG; whence: SQLTWNC; roffset: SQLTLNGPTR): SqlTAPI;


function SqlMwr(shandle: SQLTSVH; fd: SQLTFLH; buffer: SQLTDAP; len: SQLTDAL; rlen: SQLTDALPTR): SqlTAPI;


function SqlNbv(Cur: SQLTCUR; nbv: SQLTNBVPTR): SqlTAPI;


function SqlNii(Cur: SQLTCUR; nii: SQLTNSIPTR): SqlTAPI;


function SqlNrr(Cur: SQLTCUR; rcountp: SQLTROWPTR): SqlTAPI;


function SqlNsi(Cur: SQLTCUR; nsi: SQLTNSIPTR): SqlTAPI;


function SqlOms(Cur: SQLTCUR; outsize: SQLTDAL): SqlTAPI;


function SqlPrs(Cur: SQLTCUR; row: SQLTROW): SqlTAPI;


function SqlRbf(Cur: SQLTCUR; rbf: SQLTRBFPTR): SqlTAPI;


function SqlRbk(Cur: SQLTCUR): SqlTAPI;


function SqlRcd(Cur: SQLTCUR; rcd: SQLTRCDPTR): SqlTAPI;


function SqlRdb(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; bkpdir: SQLTFNP; bkpdirl: SQLTFNL; local: SQLTBOO; over: SQLTBOO): SqlTAPI;


function SqlRdc(Cur: SQLTCUR; bufp: SQLTDAP; buf: SQLTDAL; readl: SQLTDALPTR): SqlTAPI;


function SqlRel(Cur: SQLTCUR): SqlTAPI;


function SqlRes(CurPtr: SQLTCURPTR; bkfname: SQLTFNP; bkfnlen: SQLTFNL; bkfserv: SQLTSVN; overwrt: SQLTBOO; dbname: SQLTDAP; dbnlen: SQLTDAL; dbserv: SQLTSVN): SqlTAPI;


function SqlRet(Cur: SQLTCUR; cnp: SQLTDAP; cnl: SQLTDAL): SqlTAPI;


function SqlRlf(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; bkpdir: SQLTFNP; bkpdirl: SQLTFNL; local: SQLTBOO; over: SQLTBOO): SqlTAPI;


function SqlRlo(Cur: SQLTCUR; slc: SQLTSLC; bufp: SQLTDAP; bufl: SQLTDAL; readl: SQLTDALPTR): SqlTAPI;


function SqlRof(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; mode: SQLTRFM; datetime: SQLTDAP; datetimel: SQLTDAL): SqlTAPI;


function SqlRow(Cur: SQLTCUR; row: SQLTROWPTR): SqlTAPI;


function SqlRrd(Cur: SQLTCUR): SqlTAPI;


function SqlRrs(Cur: SQLTCUR; rsp: SQLTDAP;rsl: SQLTDAL): SqlTAPI;


function SqlRsi(shandle: SQLTSVH): SqlTAPI;


function SqlRss(shandle: SQLTSVH; dbname: SQLTDAP; dbnamel: SQLTDAL; bkpdir: SQLTFNP; bkpdirl: SQLTFNL; local: SQLTBOO; over: SQLTBOO): SqlTAPI;


function SqlSab(shandle: SQLTSVH; pnum: SQLTPNM): SqlTAPI;


function SqlSap(srvno: SQLTSVN; password: SQLTDAP; pnum: SQLTPNM): SqlTAPI;


function SqlScl(Cur: SQLTCUR; namp: SQLTDAP; naml: SQLTDAL): SqlTAPI;


function SqlScn(Cur: SQLTCUR; namp: SQLTDAP; naml: SQLTDAL): SqlTAPI;


function SqlScp(Pages: SQLTNPG): SqlTAPI;


function SqlSdn(dbnamp: SQLTDAP; dbnaml: SQLTDAL): SqlTAPI;


function SqlSds(shandle: SQLTSVH; shutdownflg: SQLTFLG): SqlTAPI;


function SqlSdx(shandle: SQLTSVH; dbnamp: SQLTDAP; dbnaml: SQLTDAL; shutdownflg: SQLTFLG): SqlTAPI;


function SqlSet(Cur: SQLTCUR; parm: SQLTPTY; p: SQLTDAP; i: SQLTDAL): SqlTAPI;


function SqlSil(Cur: SQLTCUR; isolation: SQLTILV): SqlTAPI;


function SqlSlp(Cur: SQLTCUR; lpt: SQLTNPG; lpm: SQLTNPG): SqlTAPI;


function SqlSpr(Cur: SQLTCUR): SqlTAPI;


function SqlSrf(Cur: SQLTCUR; fnp: SQLTDAP; fnl: SQLTDAL): SqlTAPI;


function SqlSrs(Cur: SQLTCUR): SqlTAPI;


function SqlSsb(Cur: SQLTCUR; slc: SQLTSLC; pdt: SQLTPDT; pbp: Pointer; pdl: SQLTPDL; sca: SQLTSCA; pcv: SqlTCdlPtr; pfc: SqlTFscPtr): SqlTAPI;


function SqlSss(Cur: SQLTCUR; size: SQLTDAL): SqlTAPI;


function SqlSta(Cur: SQLTCUR; var srv: SQLTSTC; svw: SQLTSTC; var spr: SQLTSTC; var spw: SQLTSTC): SqlTAPI;


function SqlStm(shandle: SQLTSVH): SqlTAPI;


function SqlSto(Cur: SQLTCUR; cnp: SQLTDAP; cnl: SQLTDAL; ctp: SQLTDAP; ctl: SQLTDAL): SqlTAPI;


function SqlStr(Cur: SQLTCUR): SqlTAPI;


function SqlSxt(srvno: SQLTSVN; password: SQLTDAP): SqlTAPI;


function SqlTec(rcd: SQLTRCD; np: SQLTRCDPTR): SqlTAPI;

function SqlSys(Cur: SQLTCUR; sys: SQLTSYS PTR): SqlTAPI; stdcall;

function SqlSys; external SqlApi_DLL name 'sqlsys';


function SqlTem(Cur: SQLTCUR; xer: SQLTXERPTR; msgtyp: SQLTPTY; bfp: SQLTDAP; bfl: SQLTDAL; txtlen: SQLTDALPTR): SqlTAPI;


function SqlTio(Cur: SQLTCUR; timeout: SQLTTIV): SqlTAPI;


function SqlUnl(Cur: SQLTCUR; cmdp: SQLTDAP; cmdl: SQLTDAL): SqlTAPI;


function SqlUrs(Cur: SQLTCUR): SqlTAPI;


function SqlWdc(Cur: SQLTCUR; bufp: SQLTDAP; bufl: SQLTDAL): SqlTAPI;


function SqlWlo(Cur: SQLTCUR; bufp: SQLTDAP; bufl: SQLTDAL): SqlTAPI;


function SqlXad(op: SQLTNMP; np1: SQLTNMP; nl1: SQLTNML; np2: SQLTNMP; nl2: SQLTNML): SqlTAPI;


function SqlXcn(op: SQLTNMP; ip: SQLTDAP; il: SQLTDAL): SqlTAPI;


function SqlXda(op: SQLTNMP; dp: SQLTNMP; dl: SQLTNML; days: SQLTDAY): SqlTAPI;


function SqlXdp(op: SQLTDAP; ol: SQLTDAL; ip: SQLTNMP; il: SQLTNML; pp: SQLTDAP; pl: SQLTDAL): SqlTAPI;


function SqlXdv(op: SQLTNMP; np1: SQLTNMP; nl1: SQLTNML; np2: SQLTNMP; nl2: SQLTNML): SqlTAPI;


function SqlXer(Cur: SQLTCUR; ErrNo: SQLTXERPTR; ErrBuf: SQLTDAP; BufLen: SQLTDALPTR): SqlTAPI;


function SqlXml(op: SQLTNMP; np1: SQLTNMP; nl1: SQLTNML; np2: SQLTNMP; nl2: SQLTNML): SqlTAPI;


function SqlXnp(Outp: SQLTDAP; OutL: SQLTDAL; isnp: SQLTNMP; isnl: SQLTNML; PicP: SQLTDAP; PicL: SQLTDAL): SqlTAPI;


function SqlXpd(op: SQLTNMP; olp: SQLTNMLPTR; ip: SQLTDAP; pp: SQLTDAP; pl: SQLTDAL): SqlTAPI;


function SqlXsb(op: SQLTNMP; np1: SQLTNMP; nl1: SQLTNML; np2: SQLTNMP; nl2: SQLTNML): SqlTAPI;


Types


byte1		= ShortInt
minimum thread mode value
byte2		= SmallInt

byte4		= LongInt

SqlTApi = Word

SqlTARC = ubyte1

SqlTBIR = ubyte2
work size
SqlTBirPtr	= ^SqlTBir
client process id
SqlTBNL = ubyte1
remote connection architecture
SqlTBNN = ubyte1
bind name length
SqlTBNP = ubyte1p
bind number
SqlTBOO = ubyte1
null indicator
SqlTCDL = ubyte1
boolean data type
SqlTCdlPtr	= ^SqlTCdl

SqlTCHL = ubyte1
column data length
SqlTChlPtr	= ^SqlTChl

SqlTCHO = ubyte1
column header length
SqlTCHP = ubyte1p
check option
SqlTCLL = ubyte2
column header pointer
SqlTCTY = ubyte1
column data length(long)
SqlTCUR = ubyte2
command type
SqlTCurPtr	= ^SqlTCur

SqlTDAL = ubyte2
cursor number
SqlTDalPtr	= ^SqlTDal

SqlTDAP = ubyte1p
data length
SqlTDAY = byte2
data pointer
SqlTDDL = ubyte1
number of days
SqlTDdlPtr	= ^SqlTDdl

SqlTDDT = ubyte1
database data length
SqlTDdtPtr	= ^SqlTDdt

SqlTDEDL = ubyte2
database data type
SqlTDIS = ubyte1p
bulk insert error row number
SqlTDPT = ubyte2
database extended data length
SqlTDPV = ubyte4
database parameter type
SqlTEPO = ubyte2
database parameter value ??????
SqlTFAT = ubyte2
error position
SqlTFLD = ubyte2
file attribute
SqlTFLG = byte2
SELECT statement field number
SqlTFLH = ubyte4
flag field
SqlTFlhPtr    = ^SqlTFlh

SqlTFMD = byte2
file handle UINT32 ????????
SqlTFNL = ubyte2
file mode
SqlTFNP = ubyte1p
file name length
SqlTFSC = ubyte1
file name pointer
SqlTFscPtr	= ^SqlTFsc

SqlTILV = ubyte1p
fetch status code
SqlTLBL = ubyte1
isolation level string
SqlTLBP = ubyte1p
label information length
SqlTLNG = byte4
label infromation pointer
SqlTLngPtr	= ^SqlTLng

SqlTLSI = ubyte4
long size
SQLTLSIPtr	= ^SQLTLSI

SqlTMSZ = ubyte2
unsigned long size ????????
SqlTNBV = ubyte1
message size
SqlTNbvPtr 	= ^SqlTNbv

SqlTNCU = ubyte2
number of bind variables
SqlTNML = ubyte1
number of cursors
SqlTNmlPtr	= ^SqlTNml

SqlTNMP = ubyte1p
number length
SqlTNPG = ubyte2
number pointer
SqlTNSI = ubyte1
number of pages
SqlTNsiPtr  	= ^SqlTNsi

SqlTNUL = byte2
bind name pointer
SqlTPCX = ubyte1
number of select items
SqlTPDL = ubyte1
preserve context flag
SqlTPDT = ubyte1
program data length
SqlTPfp = TFarProc

SqlTPGN = ubyte4
program data type
SqlTPID = ubyte4
extended error #
SqlTPNM = ubyte2
page number
SqlTPnmPtr	= ^SqlTPnm

SqlTPRE = ubyte1
process number
SqlTPrePtr	= ^SqlTPre

SqlTPTY = ubyte2
precision
SqlTRBF = ubyte1
set/get parameter type
SqlTRbfPtr	= ^SqlTRbf

SqlTRCD = byte2
roll back flag
SqlTRcdPtr	= ^SqlTRcd

SqlTRCF = ubyte1
return codes
SqlTRFM = ubyte2
recovery flag
SqlTROW = byte4
rollforward mode
SqlTRowPtr	= ^SqlTRow

SqlTSCA = ubyte1
number of rows
SqlTScaPtr	= ^SqlTSca

SqlTSLC = ubyte1
scale
SqlTSTC = ubyte2
select list column
SqlTSVH = ubyte2
statistics counter
SqlTSVN = ubyte2
server handle
SqlTTIV = byte2
server number
SqlTWNC = byte2
wait timeout value
SqlTWSI = ubyte2
whence
SqlTXER = byte4
Describe info indicator
SqlTXerPtr	= ^SqlTXer

ubyte1	= Byte

ubyte1p	= Pointer

ubyte2	= Word

ubyte4	= LongInt

Constants

FetchDel = 3

FetchEof = 1

FetchOk = 0

FetchUpd = 2

FetRDnd = 6

data type not supported

FetRDnn = 3

signed number fetched

FetRDtn = 5

numeric overflow

FetRNof = 4

data is not numeric

FetRNul = 7

data is not in date format

FetRSin = 2

data truncated

FetRTru = 1

FETCH RETURN CODES

SQLB204 = 21

Cincom SUPRA

SQLBALB = 10

Teradata DBC Machines

SQLBAPP = 99

Informix On-Line NLS version 6

SQLBAS4 = 7

Netware SQL

SQLBDAL = 22

CCA Model 204

SQLBDB2 = 2

SQLBASE

SQLBDB4 = 18

DBase

SQLBDBA = 17

SQL Access

SQLBDBC = 9

Sybase SQL Server

SQLBDBM = 3

DB2

SQLBEDA = 25

Informix On-Line

SQLBFUJ = 19

SNI DDB4

SQLBIGW = 5

Oracle

SQLBING = 15

SNI SESAM

SQLBIOD = 30

Ingres OpenSQL

SQLBIOL = 24

Teradata ShareBase

SQLBIOS = 29

Oracle version 7

SQLBMIM = 27

SNI UDS

SQLBNOL = 36

Informix SE NLS version 6

SQLBNSE = 35

Informix On-Line version 6

SQLBNTW = 6

Informix

SQLBODB = 31

Ingres OpenSQL with date support

SQLBOL6 = 34

Informix SE version 6

SQLBOR7 = 28

Nocom Mimer

SQLBORA = 4

IBM OS/2 Database Manager

SQLBRDB = 11

HP Allbase

SQLBS10 = 32

ODBC Router

SQLBSDS = 13

Tandem's Nonstop SQL

SQLBSE6 = 33

SYBASE System 10

SQLBSES = 14

IBM SQL/DS

SQLBSHR = 23

Apple DAL interface

SQLBSQB = 1

time colon only *) { defines for database brands

SQLBSQL = 16

Ingres

SQLBSUP = 20

Fujitsu RDBII

SQLBSYB = 8

IBM AS/400 SQL/400

SQLBTDM = 12

DEC's RDB

SQLBUDS = 26

EDA/SQL

SqlDBoo = 8

sql handle data type

SqlDChr = 1

data is null *) { DATABASE DATA TYPES

SqlDDat = 3

numeric data type

SqlDDte = 5

long data type

SqlDDtm = 8

boolean data type

SqlDHdl = 7

time (only) data type

SqlDLon = 4

date-time data type

SqlDNum = 2

character data type

SqlDTim = 6

date (only) data type

SqlEBin = 16

LONG VAR GRAPHIC

SqlEBoo = 19

LONG BINARY

SqlEChr = 4

FLOAT

SqlEDat = 8

DECIMAL

SqlEDec = 7

LONGVAR

SqlEDou = 12

MONEY

SqlEFlo = 3

SMALLINT

SqlEGph = 13

DOUBLE

SqlEInt = 1

data type maximum *) { EXTERNAL DATA TYPES

SqlELbi = 18

VAR BINARY

SqlELch = 20

BOOLEAN

SqlELgp = 15

VAR GRAPHIC

SqlELon = 6

VARCHAR

SqlELvr = 21

CHAR > 254

SqlEMon = 11

TIMESTAMP

SqlESma = 2

INTEGER

SqlETim = 9

DATE

SqlETms = 10

TIME

SqlEVar = 5

CHAR

SqlEVbi = 17

BINARY

SqlEVgp = 14

GRAPHIC

SQLFICS = #02

Repeatable Read isolation flag

SQLFIRL = #08

Read-Only isolation flag

SQLFIRO = #04

Cursor Stability isolation flag

SQLFIRR = #01

Release Locks isolation *) { defines for isolation level flags

SQLILCS = 'CS'

Repeatable Read isolation

SQLILRL = 'RL'

Read-Only isolation

SQLILRO = 'RO'

Cursor Stability isolation

SQLILRR = 'RR'

unlock database *) { defines for isolation level string

SQLMAUF = 32

max global transaction-id length

SQLMAWS = 255

max OS sample rate

SQLMBNL = 18

Release Locks isolation flag *) { MAXIMUM SIZES

SQLMBSL = 32000

bind name length

SQLMCG0 = 1

max length identificatin strings *) { MINIMUMS

SQLMCG1 = 32767

max length Backend string literal

SQLMCKF = 16

cache group pages

SQLMCLL = 255

concatenated key fields

SQLMCLN = 12

clientlimit

SQLMCLP = 128

maximum client name size

SQLMCMT = 99

commmand line parameter length

SQLMCNM = 18

max command types

SQLMCOH = 255

max referential constraint name

SQLMCST = 400

column heading string

SQLMCTL = 43200

maximum password length

SQLMDBA = 10

max connect string length

SQLMDFN = 25

number of databases accessed

SQLMDMO = 750

process status string

SQLMDNM = 8

maximum DB size for demos (Kbytes)

SQLMDVL = 254

database name

SQLMERR = 255

data value length

SQLMETX = 3000

error message length

SQLMEXS = 1024

cache group pages

SQLMFNL = 128

error text length

SQLMFQN = 3

filename length

SQLMFRD = 40

number of fields in fully qualified column name

SQLMGCM = 32767

maximum size of foreign result set directory

SQLMGTI = 250

max primary key length

SQLMICO = 255

maximum group commit count

SQLMICU = 255

installed cache page owners

SQLMIDB = 255

installed cursors

SQLMILK = 32767

installed databases

SQLMINL = 2000

installed locks

SQLMIPG = 32767

input length

SQLMIPR = 800

installed pages

SQLMITM = 1

minimum pages (cache)

SQLMITR = 800

installed processes

SQLMJTB = 17

installed transactions

SQLMLFE = 100000

partitioned file extension size

SQLMLFS = 100000

minimum log file extension size

SQLMLID = 32

joined tables

SQLMMID = 32

max OS Averaging window size

SQLMNBF = 60000

long identifiers

SQLMNCO = 254

network buffer size

SQLMNPF = 3

number of user columns available

SQLMOSR = 255

max protocol name length

SQLMOUL = 1000

NETPREFIX size

SQLMPAG = 15

minimum log file size

SQLMPAL = 255

output length

SQLMPFS = 21

max path string length

SQLMPKL = 254

maximum thread mode value

SQLMPNM = 8

max concurrent audit files

SQLMPRE = 15

max platform string length

SQLMPSS = 25

database file name

SQLMPTL = 4

maximum decimal precision

SQLMPWD = 128

maximum print level

SQLMRBB = 8192

max query timelimit (12 hours)

SQLMRCB = 20480

maximum rollback log buffer

SQLMRET = 1000

maximum recovery log buffer

SQLMRFH = 4

retry count

SQLMROB = 8192

maximum # remote file handles

SQLMSES = 16

max size of restore output buffer

SQLMSID = 8

number of sessions

SQLMSLI = 255

short identifiers

SQLMSNM = 8

max number of select list exprs.

SQLMSRL = 32

server name

SQLMSVN = 199

max length of SQL reserved word

SQLMTFS = 10

maximum server names

SQLMTHM = 2

max log file size

SQLMTMO = 200

maximum temporary file size

SQLMTSS = 256

maximum timeout

SQLMUCO = 253

number of columns per row

SQLMUSR = 128

text string space size

SQLMVER = 8

maximum username length

SQLMXER = 255

max version string (nn.nn.nn)

SQLMXLF = 4194304

Extended error message length

SQLNPTR = nil

table extent size *) { NULL POINTER

SQLP2PP = 3030

distributed transaction status

SQLPAID = 3039

mail id

SQLPAIO = 39

cache group

SQLPALG = 5002

print level

SQLPANL = 40

asyncio

SQLPAPT = 1011

command time limit

SQLPAUT = 3006

load version (ex. "3.6.22")

SQLPAWS = 1013

OS sample rate

SQLPBLK = 3015

referential integrity checking

SQLPBRN = 1003

CACHE size in Kbytes

SQLPBRS = 4001

first attribute

SqlPBuf = 1

maximum data type *) { PROGRAM DATA TYPES

SQLPCAC = 1002

HEAP size for TSR executables

SQLPCAP = 4007

last attribute

SQLPCCK = 36

commit server

SQLPCGR = 38

characterset

SQLPCHS = 3020

Compress messages sent to server

SQLPCIS = 3042

user application id

SQLPCLG = 43

set SQLTrace flags

SQLPCLI = 3031

2-phase protocol (SQL2STD, etc.) *) { defined for Load/Unload parsed parameters - cursor specific

SQLPCLN = 3024

Error Message Tokens

SQLPCMP = 3019

When to return Describe info

SQLPCPG = 8

dbdir

SQLPCPT = 10

null indicator error

SQLPCSD = 32

country

SQLPCSR = 33

commit server daemon

SQLPCSV = 1027

enable stats gathering

SQLPCTF = 3037

Tracefile for stored procedures

SQLPCTI = 2005

log file size in Kbytes

SQLPCTL = 1010

number of deadlocks

SQLPCTS = 37

client check

SQLPCTY = 31

default write

SQLPCUN = 3047

Return on First Error-bulk insert

SQLPCVC = 2021

show main db

SQLPCXP = 3027

explain query plan

SqlPDat = 12

SQLBASE internal numeric format

SQLPDB2 = 3013

current password

SQLPDBD = 7

db mode - see below

SQLPDBM = 6

local result set directory

SQLPDBN = 2001

trace for 2PC *) { Database specific parameters } { ----------------------------

SQLPDBS = 2022

catalog version counter

SQLPDDB = 1

VARCHAR > 254 *) { SET and GET PARAMETER TYPES } { Global parameters } { ------------------

SQLPDDR = 2002

database name

SQLPDIO = 28

error file

SQLPDIS = 3018

LONG data allowed in FERS

SQLPDLK = 1009

group commit delay ticks

SQLPDMO = 4003

multi-user

SqlPDou = 10

float

SQLPDPW = 3

default user name

SqlPDte = 15

signed packed decimal

SQLPDTL = 2019

log file offset

SqlPDtm = 24

char\long varchar > 254

SQLPDTR = 12

temp dir

SQLPDUS = 2

default database name

SqlPEbc = 21

numeric buffer

SQLPEMT = 3023

ROWID

SQLPERF = 27

interrupt

SQLPEXE = 2012

recovery

SQLPEXP = 3026

last compiled SQL statement

SQLPEXS = 2015

read-only database (0 or 1)

SQLPFAT = 4000

Optimize First Fetch *) { Static attributes } { --------------------------

SqlPFlt = 9

long

SQLPFNM = 3032

ON CLIENT option

SQLPFPT = 4005

local version of database

SQLPFRS = 3004

preserve context (0 or 1)

SQLPFT = 3010

restriction mode (0 or 1)

SQLPGBC = 4

default password

SQLPGCD = 1008

group commit count

SQLPGCM = 1007

partitioned database

SQLPGRS = 41

apply net log

SQLPHEP = 1001

set commit-order logging *) { Server specific parameters } { --------------------------

SQLPHFS = 2010

read-only transactions (0, 1, 2)

SQLPIMB = 3043

client identification strings

SQLPINT = 25

locks

SQLPISO = 3001

update external dictionary *) { Cursor specific parameters } { --------------------------

SQLPLAT = 4006

1st participant

SqlPLbi = 23

long text string

SQLPLBM = 2006

checkpoint time interval in mins

SQLPLCK = 22

net check

SQLPLDR = 2003

database directory

SQLPLDV = 3005

front end result sets

SQLPLFF = 3017

optimized bulk-execute mode

SQLPLFS = 2004

log directory

SQLPLGF = 2018

NEWDB

SQLPLOC = 4004

demonstration version

SqlPLon = 22

EBCDIC buffer format

SQLPLRD = 5

global cursor value

SQLPLSS = 3025

client name

SqlPLvr = 24

long binary buffer

SQLPMID = 3038

control file flag

SQLPMUL = 4002

back end result sets

SqlPNbu = 20

numeric string

SQLPNCK = 20

net check type

SQLPNCT = 19

net log

SQLPNDB = 2017

partitioned database (0 or 1)

SQLPNID = 3040

adapter id

SQLPNIE = 9

code page information

SQLPNLB = 2013

name of executable

SQLPNLG = 18

net prefix

SQLPNPB = 3011

fetch through

SQLPNPF = 17

oracle outer join

SqlPNst = 19

short

SqlPNum = 11

double

SQLPOBL = 3016

bulk-execute mode

SQLPOCL = 3028

cost of execution plan

SQLPOFF = 3048

Current cursor user name

SQLPOMB = 3044

input message buffer size

SQLPOOJ = 16

server password

SQLPOPL = 3021

chained cmd has SELECT (0 or 1)

SQLPOSR = 1012

process timer activated

SQLPOVR = 3033

load/unload file name

SQLPPAR = 2016

database file extension size

SQLPPCX = 3003

lock wait timeout in seconds

SQLPPDB = 1006

server profiling

SQLPPLF = 2007

log backup mode? (0 or 1)

SQLPPLV = 5001

runtime version *) { Server specific parameters } { ----------------------------

SQLPPRF = 1005

release version (ex. "4.0.J")

SQLPPSW = 15

distributed transaction mode

SQLPPTH = 5004

time stamp

SQLPPWD = 3012

no pre-build in RL mode

SQLPREC = 2011

history file size in Kbytes

SQLPREF = 3014

DB2 compatibility mode

SQLPRES = 3009

scroll mode (0 or 1)

SQLPRFE = 3046

which fetchable command

SQLPRID = 3022

optimizer level

SQLPROD = 2014

next log to backup

SQLPROM = 1025

server name

SQLPROT = 2009

transaction span limit

SQLPRTO = 3007

autocommit

SQLPRUN = 4009

server capability level

SqlPSch = 4

unsigned char

SQLPSCL = 4008

API capability level

SQLPSCR = 3008

rollback trans on lock timeout

SQLPSIL = 1021

sortcache size in kilobytes

SqlPSin = 6

unsigned int

SqlPSlo = 8

unsigned long

SQLPSMN = 2020

command timelimit

SqlPSpd = 14

unsigend packed decimal

SQLPSPF = 1022

silent mode

SqlPSsh = 18

unsigned short

SQLPSTA = 1026

read-only mode (0 or 1)

SQLPSTC = 1020

thread mode

SQLPSTF = 42

get reentracy state

SqlPStr = 2

buffer

SQLPSVN = 1024

server prefix

SQLPSWR = 29

direct I/O

SQLPTCO = 5006

time zone

SQLPTFN = 3034

file OVERWRITE flag

SQLPTHM = 1019

thread stack size

SqlPTim = 16

date only format

SQLPTMO = 1017

Number of users

SQLPTMS = 5003

activity log

SQLPTMZ = 5005

path name seperator

SQLPTPD = 11

connect pass thru to backend

SQLPTRC = 3035

A Temporary file name

SQLPTRF = 3036

Trace stored procedures

SQLPTSL = 2008

Pre-allocate log files? (0 or 1)

SQLPTSS = 1018

time out

SQLPTST = 3029

optimizercostlevel

SQLPTTP = 1028

commit server

SqlPUch = 3

string (zero terminated)

SQLPUED = 2023

database block size

SQLPUID = 3041

network id

SqlPUin = 5

char

SqlPUlo = 7

int

SqlPUpd = 13

SQLBASE internal datetime format

SqlPUsh = 17

time only format

SQLPUSR = 1016

Work Space allocation

SQLPVER = 1004

brand of database

SQLPWFC = 3045

output message buffer size

SQLPWKA = 1015

Work Limit

SQLPWKL = 1014

OS Averaging window size

SQLPWTO = 3002

isolation level (SQLILRR etc..)

SqlSCda = 26

date-time program buffer size

SqlSCde = 10

date (only) program buffer size

SqlSCti = 15

time (only) program buffer size

SqlSDat = SQLSNUM

numeric program buffer size

SqlSDte = SQLSDAT

character date-time size

SqlSFem = 100

character time (only) size

SqlSFes = 20

file extension size (multi-user)

SqlSNum = 12

SQLHost App Services *) { SIZES

SqlSRid = 40

character date (only) size

SqlSTex = 5

file extension size (single-user)

SqlSTim = SQLSDAT

size of ROWID

SqlTACM = 97

stop audit

SqlTACO = 11

rollback

SqlTADA = 46

create dbarea

SqlTADB = 52

create database

SqlTAFK = 42

add primary key

SqlTAPK = 41

foreign DBMS commands

SqlTAPW = 32

row count

SqlTARU = 57

de-install database *) { END OF SERVER COMMAND TYPES

SqlTASG = 49

create stogroup

SqlTAUD = 95

start audit

SqlTBGT = 64

PL/Sql Stored Procedure

SqlTCBT = 69

END TRANSACTION *) { COMMIT SERVER COMMAND TYPES

SqlTCCT = 70

begin transaction

SqlTCDA = 45

drop foreign key *) { SERVER COMMAND TYPES

SqlTCDB = 39

update statistics

SqlTCET = 71

commit transaction

SqlTCFL = 81

orphan a transaction

SqlTCHN = 34

label on

SqlTCIN = 6

delete

SqlTCKI = 62

check table

SqlTCKT = 61

set client

SqlTCMT = 9

drop table

SqlTCOM = 24

revoke resource

SqlTCOT = 80

resolve one transaction

SqlTCPT = 72

end transaction

SqlTCRA = 78

stop daemon

SqlTCRD = 51

delete stogroup

SqlTCRO = 79

resolve all transactions

SqlTCRT = 73

prepare transaction

SqlTCRX = 75

status transaction

SqlTCSD = 76

reduce transaction

SqlTCSG = 48

delete dbarea

SqlTCST = 74

rollback transaction

SqlTCSY = 27

post

SqlTCTB = 3

insert

SqlTCTD = 77

start daemon

SqlTCVW = 29

drop synonym

SqlTCXN = 66

PREPARE TRANSACTION

SqlTDCO = 12

add column

SqlTDDA = 47

alter dbarea

SqlTDDB = 53

alter database

SqlTDED = 56

install database

SqlTDEL = 5

update

SqlTDFK = 44

drop primary key

SqlTDFL = 82

CREATE FAILURE

SqlTDIN = 7

create index

SqlTDPK = 43

add foreign key

SqlTDRU = 58

add RI user error

SqlTDSG = 50

alter stogroup

SqlTDSY = 28

create synonym

SqlTDTB = 8

drop index

SqlTDVW = 30

create view

SqlTENT = 68

ROLLBACK TRANSACTION

SqlTFRN = 40

check database

SqlTGEP = 88

stored procedure

SqlTGRC = 18

grant dba

SqlTGRD = 17

grant privilege on table

SqlTGRP = 16

modify column

SqlTGRR = 19

grant connect

SqlTIND = 55

set default stogroup

SqlTINS = 2

select

SqlTLAB = 33

alter password

SqlTLDP = 86

Unload command

SqlTMCO = 15

rename column

SqlTMRU = 59

drop RI user error

SqlTOPL = 63

check index

SqlTPOS = 26

wait

SqlTPRO = 87

load command

SqlTPRT = 65

BEGIN TRANSACTION

SqlTRBK = 10

commit

SqlTRBS = 37

savepoint

SqlTRCO = 14

rename table

SqlTRCT = 31

drop view

SqlTREC = 22

revoke dba

SqlTRED = 21

revoke privilege on table

SqlTREE = 89

grant execute privilege

SqlTREP = 20

grant resource

SqlTRER = 23

revoke connect

SqlTRPT = 35

chained command

SqlTRTB = 13

drop column

SqlTRXN = 67

COMMIT TRANSACTION

SqlTSCL = 60

modify RI user error

SqlTSDS = 54

delete database

SqlTSEL = 1

(ubyte1 PTR)0 - null pointer *) { RESULT COMMAND TYPES

SqlTSTF = 84

SET TRACETWOPC ON

SqlTSTN = 83

DELETE FAILURE

SqlTSTP = 96

audit message

SqlTSTR = 94

drop event

SqlTSVP = 36

repair table

SqlTTGC = 90

revoke execute privilege

SqlTTGD = 91

create trigger

SqlTUDS = 38

rollback to savepoint

SqlTUNL = 85

SET TRACETWOPC OFF

SqlTUPD = 4

create table

SqlTVNC = 92

drop trigger

SqlTVND = 93

create event

SqlTWAI = 25

comment on

SqlTXDL = 98

Alter CoMmand

SqlTXDU = 99

lock database

Variables