sdcsb.pas

SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland Delphi

  SQLBDAL = 22;			// Apple DAL interface
  SQLBSHR = 23;			// Teradata ShareBase
  SQLBIOL = 24;			// Informix On-Line
  SQLBEDA = 25;			// EDA/SQL
  SQLBUDS = 26;			// SNI UDS
  SQLBMIM = 27;			// Nocom Mimer
  SQLBOR7 = 28;			// Oracle version 7
  SQLBIOS = 29;			// Ingres OpenSQL
  SQLBIOD = 30;			// Ingres OpenSQL with date support
  SQLBODB = 31;			// ODBC Router
  SQLBS10 = 32;			// SYBASE System 10
  SQLBSE6 = 33;			// Informix SE version 6
  SQLBOL6 = 34;			// Informix On-Line version 6
  SQLBNSE = 35;			// Informix SE NLS version 6
  SQLBNOL = 36;			// Informix On-Line NLS version 6
  SQLBAPP = 99;			// SQLHost App Services

	{ 	SIZES 	}
  SqlSNum =  12;		// numeric program buffer size
  SqlSDat = SQLSNUM;		// date-time program buffer size
  SqlSCda =  26;		// character date-time size
  SqlSDte = SQLSDAT;		// date (only) program buffer size
  SqlSCde =  10;		// character date (only) size
  SqlSRid =  40;		// size of ROWID
  SqlSTim = SQLSDAT;		// time (only) program buffer size
  SqlSCti =  15;		// character time (only) size
  SqlSFem = 100;		// file extension size (multi-user)
  SqlSFes =  20; 		// file extension size (single-user)
  SqlSTex =   5;		// table extent size		    


	{ 	NULL POINTER 	}
  SQLNPTR = nil;                //  (ubyte1 PTR)0 - null pointer

	{ 	RESULT COMMAND TYPES 	}
  SqlTSEL = 1;			// select
  SqlTINS = 2;			// insert
  SqlTCTB = 3;			// create table
  SqlTUPD = 4;			// update
  SqlTDEL = 5;			// delete
  SqlTCIN = 6;			// create index
  SqlTDIN = 7;			// drop index
  SqlTDTB = 8;			// drop table
  SqlTCMT = 9;			// commit
  SqlTRBK = 10;			// rollback
  SqlTACO = 11;			// add column
  SqlTDCO = 12;			// drop column
  SqlTRTB = 13;			// rename table
  SqlTRCO = 14;			// rename column
  SqlTMCO = 15;			// modify column
  SqlTGRP = 16;			// grant privilege on table
  SqlTGRD = 17;			// grant dba
  SqlTGRC = 18;			// grant connect
  SqlTGRR = 19;			// grant resource
  SqlTREP = 20;			// revoke privilege on table
  SqlTRED = 21;			// revoke dba
  SqlTREC = 22;			// revoke connect
  SqlTRER = 23;			// revoke resource
  SqlTCOM = 24;			// comment on
  SqlTWAI = 25;			// wait
  SqlTPOS = 26;			// post
  SqlTCSY = 27;			// create synonym
  SqlTDSY = 28;			// drop synonym
  SqlTCVW = 29;			// create view
  SqlTDVW = 30;			// drop view
  SqlTRCT = 31;			// row count
  SqlTAPW = 32;			// alter password
  SqlTLAB = 33;			// label on
  SqlTCHN = 34;			// chained command
  SqlTRPT = 35;			// repair table
  SqlTSVP = 36;			// savepoint
  SqlTRBS = 37;			// rollback to savepoint
  SqlTUDS = 38;			// update statistics
  SqlTCDB = 39;			// check database
  SqlTFRN = 40;			// foreign DBMS commands
  SqlTAPK = 41;			// add primary key
  SqlTAFK = 42;			// add foreign key
  SqlTDPK = 43;			// drop primary key
  SqlTDFK = 44;			// drop foreign key

	{ 	SERVER COMMAND TYPES 		}
  SqlTCDA = 45;			// create dbarea
  SqlTADA = 46;			// alter  dbarea
  SqlTDDA = 47;			// delete dbarea
  SqlTCSG = 48;			// create stogroup
  SqlTASG = 49;			// alter  stogroup
  SqlTDSG = 50;			// delete stogroup
  SqlTCRD = 51;			// create database
  SqlTADB = 52;			// alter  database
  SqlTDDB = 53;			// delete database
  SqlTSDS = 54;			// set default stogroup
  SqlTIND = 55;			// install database
  SqlTDED = 56;			// de-install database
	{ 	END OF SERVER COMMAND TYPES 	}

  SqlTARU = 57;			// add RI user error
  SqlTDRU = 58;			// drop RI user error
  SqlTMRU = 59;			// modify RI user error
  SqlTSCL = 60;			// set client
  SqlTCKT = 61;			// check table
  SqlTCKI = 62;			// check index
  SqlTOPL = 63;			// PL/Sql Stored Procedure
  SqlTBGT = 64;			// BEGIN TRANSACTION
  SqlTPRT = 65;			// PREPARE TRANSACTION
  SqlTCXN = 66;			// COMMIT TRANSACTION
  SqlTRXN = 67;			// ROLLBACK TRANSACTION
  SqlTENT = 68;			// END TRANSACTION

	{ 	COMMIT SERVER COMMAND TYPES 	}
  SqlTCBT = 69;			// begin transaction
  SqlTCCT = 70;			// commit transaction
  SqlTCET = 71;			// end	 transaction
  SqlTCPT = 72;			// prepare transaction
  SqlTCRT = 73;			// rollback transaction
  SqlTCST = 74;			// status transaction
  SqlTCRX = 75;			// reduce transaction
  SqlTCSD = 76;			// start daemon
  SqlTCTD = 77;			// stop daemon
  SqlTCRA = 78;			// resolve all transactions
  SqlTCRO = 79;			// resolve one transaction
  SqlTCOT = 80;			// orphan a transaction
  SqlTCFL = 81;			// CREATE FAILURE
  SqlTDFL = 82;			// DELETE FAILURE
  SqlTSTN = 83;			// SET TRACETWOPC ON
  SqlTSTF = 84;			// SET TRACETWOPC OFF
  SqlTUNL = 85;			// Unload command
  SqlTLDP = 86;			// load command
  SqlTPRO = 87;			// stored procedure
  SqlTGEP = 88;			// grant  execute privilege
  SqlTREE = 89;			// revoke execute privilege
  SqlTTGC = 90;			// create trigger
  SqlTTGD = 91;			// drop trigger
  SqlTVNC = 92;			// create event
  SqlTVND = 93;			// drop event
  SqlTSTR = 94;			// start audit
  SqlTAUD = 95;			// audit message
  SqlTSTP = 96;			// stop audit
  SqlTACM = 97;			// Alter CoMmand
  SqlTXDL = 98;			// lock database
  SqlTXDU = 99;			// unlock database

	{ 	defines for isolation level string 	}
  SQLILRR = 'RR';		// Repeatable Read isolation
  SQLILCS = 'CS';		// Cursor Stability isolation
  SQLILRO = 'RO';		// Read-Only isolation
  SQLILRL = 'RL';		// Release Locks isolation
	{ 	defines for isolation level flags	}
  SQLFIRR = $01;		// Repeatable Read isolation flag
  SQLFICS = $02;		// Cursor Stability isolation flag
  SQLFIRO = $04;		// Read-Only isolation flag
  SQLFIRL = $08;		// Release Locks isolation flag
	{ 	defines for SQLROF rollforward mode parameter		}
  SQLMEOL = 1;			// rollforward to end of log
  SQLMEOB = 2;			// rollforward to end of backup
  SQLMTIM = 3;			// rollforward to specified time
	{	defines for when to collect Describe information	}
  SQLDELY = 0;			// get Describe info after sqlcom
  SQLDDLD = 1;			// get Describe info after sqlexe
  SQLDNVR = 2;			// never get any Describe info
	{	defines for SQLETX() and SQLTEM(): error text type parameters	}
  SQLXMSG = 1;			// retrieve error message text
  SQLXREA = 2;			// retrieve error message reason
  SQLXREM = 4;			// retrieve error message remedy
	{	defines for extended directory open function		}
  SQLANRM = $00;		// normal - no restrictions
  SQLARDO = $01;		// read only
  SQLAHDN = $02;		// hidden file
  SQLASYS = $04;		// system file
  SQLAVOL = $08;		// volume label
  SQLADIR = $10;		// directory
  SQLAARC = $20;		// archive bit
  SQLAFDL = $100;		// files and directories
	{	defines for state of cursor 		}
  SQLCIDL = 0;	 		// idle cursor
  SQLCECM = 1;	 		// executing compile
  SQLCCCM = 2;	 		// completed compile
  SQLCEXE = 3;	 		// executing command
  SQLCCXE = 4;	 		// completed command
  SQLCEFT = 5;	 		// executing fetch
  SQLCCFT = 6;	 		// completed fetch

	{ 	MAXIMUM SIZES 	}
  SQLMBNL = 18;			// bind name length
  SQLMBSL = 32000;		// max length Backend string literal
  SQLMCG1 = 32767;		// cache group pages
  SQLMCKF = 16;			// concatenated key fields
  SQLMCLL = 255; 		// clientlimit
  SQLMCLN = 12;			// maximum client name size
  SQLMCLP = 128; 		// commmand line parameter length
  SQLMCMT = 99;			// max command types
  SQLMCNM = 18;			// max referential constraint name
  SQLMCOH = 255; 		// column heading string
  SQLMCST = 400; 		// max connect string length
  SQLMDBA = 10;			// number of databases accessed
  SQLMDFN = 25;			// database file name
  SQLMPSS = 25;			// process status string
  SQLMDMO = 750; 		// maximum DB size for demos (Kbytes)
  SQLMDNM = 8;			// database name
  SQLMDVL = 254; 		// data value length
  SQLMERR = 255; 		// error message length
  SQLMETX = 3000;		// error text length
  SQLMFNL = 128; 		// filename length
  SQLMFQN = 3;			// number of fields in fully qualified column name
  SQLMFRD = 40;			// maximum size of foreign result set directory
  SQLMGCM = 32767;		// maximum group commit count
  SQLMICO = 255; 		// installed cache page owners
  SQLMICU = 255; 		// installed cursors
  SQLMIDB = 255; 		// installed databases
  SQLMILK = 32767;		// installed locks
  SQLMINL = 2000;		// input length
  SQLMIPG = 32767;		// installed pages
  SQLMIPR = 800; 		// installed processes
  SQLMITR = 800; 		// installed transactions
  SQLMJTB = 17;			// joined tables
  SQLMLID = 32;			// long identifiers
  SQLMNBF = 60000;		// network buffer size
  SQLMNCO = 254; 		// number of columns per row
  SQLMUCO = 253; 		// number of user columns available
  SQLMNPF = 3;			// NETPREFIX size
  SQLMOUL = 1000;		// output length
  SQLMPAL = 255; 		// max path string length
  SQLMPFS = 21;			// max platform string length
  SQLMPRE = 15;			// maximum decimal precision
  SQLMPTL = 4;			// maximum print level
  SQLMPWD = 128; 		// maximum password length
  SQLMCTL = 43200;		// max query timelimit (12 hours)
  SQLMRBB = 8192;		// maximum rollback log buffer
  SQLMRCB = 20480;		// maximum recovery log buffer
  SQLMRET = 1000;		// retry count
  SQLMRFH = 4;			// maximum # remote file handles
  SQLMROB = 8192;		// max size of restore output buffer
  SQLMSES = 16;			// number of sessions
  SQLMSID = 8;			// short identifiers
  SQLMSLI = 255; 		// max number of select list exprs.
  SQLMSNM = 8;			// server name
  SQLMSRL = 32;			// max length of SQL reserved word
  SQLMSVN = 199; 		// maximum server names
  SQLMTFS = 10;			// maximum temporary file size
  SQLMTMO = 200; 		// maximum timeout
  SQLMTSS = 256; 		// text string space size
  SQLMUSR = 128; 		// maximum username length
  SQLMVER = 8;			// max version string (nn.nn.nn)
  SQLMXER = 255; 		// Extended error message length
  SQLMXLF = 4194304;		// max log file size
  SQLMTHM = 2;			// maximum thread mode value
  SQLMPKL = 254; 		// max primary key length
  SQLMGTI = 250; 		// max global transaction-id length
  SQLMAUF = 32;			// max concurrent audit files
  SQLMPNM = 8;			// max protocol name length
  SQLMOSR = 255; 		// max OS sample rate
  SQLMAWS = 255; 		// max OS Averaging window size
  SQLMMID = 32;			// max length identificatin strings

	{ 	MINIMUMS 	}
  SQLMCG0 = 1;			// cache group pages
  SQLMEXS = 1024;		// partitioned file extension size
  SQLMLFE = 100000;		// minimum log file extension size
  SQLMLFS = 100000;		// minimum log file size
  SQLMPAG = 15;			// minimum pages (cache)
  SQLMITM = 1;			// minimum thread mode value


type
  byte1		= ShortInt;
  ubyte1	= Byte;
  byte2		= SmallInt;
  ubyte2	= Word;
  byte4		= LongInt;
  ubyte4	= LongInt;

  ubyte1p	= TSDPtr;

  SqlTApi = Word;
  SqlTPfp = TFarProc;

  SqlTARC = ubyte1;		// remote connection architecture
  SqlTBNL = ubyte1;		// bind name length
  SqlTBNN = ubyte1;		// bind number
  SqlTBNP = ubyte1p;		// bind name pointer
  SqlTNUL = byte2;		// null indicator
  SqlTBOO = ubyte1;		// boolean data type
  SqlTCDL = ubyte1;		// column data length
  SqlTCHL = ubyte1;		// column header length
  SqlTCHO = ubyte1;		// check option
  SqlTCHP = ubyte1p;		// column header pointer
  SqlTCLL = ubyte2;		// column data length(long)
  SqlTCTY = ubyte1;		// command type