sdsyb.pas

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

{*
** Define the invalid count that the application gets when
** ct_res_info() is called at the wrong time.
*}
  CS_NO_COUNT		= TCS_INT(-1);

{*******************************************************************************
**
** Commands in Open Client/Server APIs.
**
*******************************************************************************}

{*
** ct_command() command types.
*}
  CS_LANG_CMD		= TCS_INT(148);
  CS_RPC_CMD		= TCS_INT(149);
  CS_MSG_CMD		= TCS_INT(150);
  CS_SEND_DATA_CMD	= TCS_INT(151);
  CS_PACKAGE_CMD    	= TCS_INT(152);
  CS_SEND_BULK_CMD	= TCS_INT(153);

{*
** ct_cursor() command types.
*}
  CS_CURSOR_DECLARE	= TCS_INT(700);
  CS_CURSOR_OPEN    	= TCS_INT(701);
  CS_CURSOR_ROWS    	= TCS_INT(703);
  CS_CURSOR_UPDATE	= TCS_INT(704);
  CS_CURSOR_DELETE	= TCS_INT(705);
  CS_CURSOR_CLOSE   	= TCS_INT(706);
  CS_CURSOR_DEALLOC	= TCS_INT(707);
  CS_CURSOR_OPTION	= TCS_INT(725);

{*
** Open Server-specific cursor command types.
*}
  CS_CURSOR_FETCH    	= TCS_INT(708);
  CS_CURSOR_INFO     	= TCS_INT(709);

{*
** ct_dyndesc() command types.
*}
  CS_ALLOC		= TCS_INT(710);
  CS_DEALLOC		= TCS_INT(711);
  CS_USE_DESC		= TCS_INT(712);
  CS_GETCNT		= TCS_INT(713);
  CS_SETCNT		= TCS_INT(714);
  CS_GETATTR		= TCS_INT(715);
  CS_SETATTR		= TCS_INT(716);

{*
** ct_dynamic() command types.
*}
  CS_PREPARE		= TCS_INT(717);
  CS_EXECUTE		= TCS_INT(718);
  CS_EXEC_IMMEDIATE	= TCS_INT(719);
  CS_DESCRIBE_INPUT	= TCS_INT(720);
  CS_DESCRIBE_OUTPUT	= TCS_INT(721);
  CS_DYN_CURSOR_DECLARE	= TCS_INT(722);


{*
** ct_dynsqlda() arguments and actions
*}
  CS_SQLDA_SYBASE 	= TCS_INT(729);
  CS_GET_IN		= TCS_INT(730);
  CS_GET_OUT		= TCS_INT(731);
  CS_SQLDA_BIND		= TCS_INT(732);
  CS_SQLDA_PARAM  	= TCS_INT(733);

{*
** Open Server-specific dynamic command types.
*}
  CS_PROCNAME		= TCS_INT(723);
  CS_ACK  		= TCS_INT(724);

{*
** ct_ds_objinfo() objinfo types.
*}
  CS_OBJ_CLASSOID	= TCS_INT(725);
  CS_OBJ_DNAME		= TCS_INT(726);
  CS_OBJ_NUMATTR 	= TCS_INT(727);
  CS_OBJ_ATRRIBUTE	= TCS_INT(728);

{*
** Command options
*}
  CS_RECOMPILE		= TCS_INT(188);
  CS_NO_RECOMPILE	= TCS_INT(189);
  CS_BULK_INIT		= TCS_INT(190);
  CS_BULK_CONT		= TCS_INT(191);
  CS_BULK_DATA		= TCS_INT(192);
  CS_COLUMN_DATA 	= TCS_INT(193);

{*
** Cursor options.
*}
  CS_FOR_UPDATE		= TCS_INT($01);
  CS_READ_ONLY		= TCS_INT($02);
  CS_DYNAMIC		= TCS_INT($04);		// Open Server only
  CS_RESTORE_OPEN	= TCS_INT($08);		// CT-Lib only
  CS_MORE    		= TCS_INT($10);
  CS_END    		= TCS_INT($20);
  CS_IMPLICIT_CURSOR	= TCS_INT($40);		// Added for implicit cursor  

{*
** Sybase-defined message ids for CS_MSG_CMDs.
*}
  CS_MSG_GETLABELS	= TCS_INT(6);
  CS_MSG_LABELS		= TCS_INT(7);
  CS_MSG_TABLENAME	= TCS_INT(8);
  CS_PARSE_TREE		= TCS_INT(8710);

{*
** Minimum and maximum user-defined message id for CS_MSG_CMDs.
*}
  CS_USER_MSGID		= TCS_INT(32768);
  CS_USER_MAX_MSGID	= TCS_INT(65535);

{*
** Defines for sp_regwatch registered procedure
*}
  CS_NOTIFY_ONCE        = $0002; 	// one-time notification request.
  CS_NOTIFY_ALWAYS      = $0004; 	// permanent notification request.
  CS_NOTIFY_WAIT        = $0020; 	// blocking notification request.
  CS_NOTIFY_NOWAIT      = $0040;	// non-blocking notification request.


{*******************************************************************************
** 			Open Client properties.
*******************************************************************************}

{*
** Properties that are used in *_props() functions.
*}
  CS_USERNAME		= TCS_INT(9100);
  CS_PASSWORD		= TCS_INT(9101);
  CS_APPNAME		= TCS_INT(9102);
  CS_HOSTNAME		= TCS_INT(9103);
  CS_LOGIN_STATUS      	= TCS_INT(9104);
  CS_TDS_VERSION       	= TCS_INT(9105);
  CS_CHARSETCNV		= TCS_INT(9106);
  CS_PACKETSIZE		= TCS_INT(9107);
  CS_USERDATA		= TCS_INT(9108);
  CS_COMMBLOCK		= TCS_INT(9109);
  CS_NETIO		= TCS_INT(9110);
  CS_NOINTERRUPT       	= TCS_INT(9111);
  CS_TEXTLIMIT		= TCS_INT(9112);
  CS_HIDDEN_KEYS       	= TCS_INT(9113);
  CS_VERSION		= TCS_INT(9114);
  CS_IFILE		= TCS_INT(9115);
  CS_LOGIN_TIMEOUT	= TCS_INT(9116);
  CS_TIMEOUT		= TCS_INT(9117);
  CS_MAX_CONNECT       	= TCS_INT(9118);
  CS_MESSAGE_CB	        = TCS_INT(9119);
  CS_EXPOSE_FMTS	= TCS_INT(9120);
  CS_EXTRA_INF		= TCS_INT(9121);
  CS_TRANSACTION_NAME	= TCS_INT(9122);
  CS_ANSI_BINDS		= TCS_INT(9123);
  CS_BULK_LOGIN		= TCS_INT(9124);
  CS_LOC_PROP		= TCS_INT(9125);
  CS_CUR_STATUS		= TCS_INT(9126);
  CS_CUR_ID		= TCS_INT(9127);
  CS_CUR_NAME		= TCS_INT(9128);
  CS_CUR_ROWCOUNT	= TCS_INT(9129);
  CS_PARENT_HANDLE	= TCS_INT(9130);
  CS_EED_CMD		= TCS_INT(9131);
  CS_DIAG_TIMEOUT	= TCS_INT(9132);
  CS_DISABLE_POLL	= TCS_INT(9133);
  CS_NOTIF_CMD		= TCS_INT(9134);
  CS_SEC_ENCRYPTION	= TCS_INT(9135);
  CS_SEC_CHALLENGE	= TCS_INT(9136);
  CS_SEC_NEGOTIATE	= TCS_INT(9137);
  CS_MEM_POOL		= TCS_INT(9138);
  CS_USER_ALLOC		= TCS_INT(9139);
  CS_USER_FREE		= TCS_INT(9140);
  CS_ENDPOINT		= TCS_INT(9141);
  CS_NO_TRUNCATE	= TCS_INT(9142);
  CS_CON_STATUS		= TCS_INT(9143);
  CS_VER_STRING		= TCS_INT(9144);
  CS_ASYNC_NOTIFS	= TCS_INT(9145);
  CS_SERVERNAME		= TCS_INT(9146);
  CS_THREAD_RESOURCE	= TCS_INT(9147);
  CS_NOAPI_CHK		= TCS_INT(9148);
  CS_SEC_APPDEFINED	= TCS_INT(9149);
  CS_NOCHARSETCNV_REQD	= TCS_INT(9150);
  CS_STICKY_BINDS	= TCS_INT(9151);
  CS_HAVE_CMD		= TCS_INT(9152);
  CS_HAVE_BINDS		= TCS_INT(9153);
  CS_HAVE_CUROPEN	= TCS_INT(9154);
  CS_EXTERNAL_CONFIG	= TCS_INT(9155);
  CS_CONFIG_FILE	= TCS_INT(9156);
  CS_CONFIG_BY_SERVERNAME=TCS_INT(9157);

{*
** Directory Service connection properties
*}
  CS_DS_CHAIN		= TCS_INT(9158);
  CS_DS_EXPANDALIAS	= TCS_INT(9159);
  CS_DS_COPY		= TCS_INT(9160);
  CS_DS_LOCALSCOPE	= TCS_INT(9161);
  CS_DS_PREFERCHAIN	= TCS_INT(9162);
  CS_DS_SCOPE		= TCS_INT(9163);
  CS_DS_SIZELIMIT 	= TCS_INT(9164);
  CS_DS_TIMELIMIT 	= TCS_INT(9165);
  CS_DS_PRINCIPAL 	= TCS_INT(9166);
// For CS_DS_PASSWORD (9198) see below   
  CS_DS_REFERRAL  	= TCS_INT(9167);
  CS_DS_SEARCH		= TCS_INT(9168);
  CS_DS_DITBASE		= TCS_INT(9169);
  CS_DS_FAILOVER  	= TCS_INT(9170);
  CS_NET_TRANADDR 	= TCS_INT(9171);
  CS_DS_PROVIDER  	= TCS_INT(9172);
  CS_RETRY_COUNT  	= TCS_INT(9173);
  CS_LOOP_DELAY   	= TCS_INT(9174);

{*
** Properties for Security services support
*}
  CS_SEC_NETWORKAUTH	= TCS_INT(9175);
  CS_SEC_DELEGATION	= TCS_INT(9176);
  CS_SEC_MUTUALAUTH	= TCS_INT(9177);
  CS_SEC_INTEGRITY	= TCS_INT(9178);
  CS_SEC_CONFIDENTIALITY= TCS_INT(9179);
  CS_SEC_CREDTIMEOUT	= TCS_INT(9180);
  CS_SEC_SESSTIMEOUT	= TCS_INT(9181);
  CS_SEC_DETECTREPLAY	= TCS_INT(9182);
  CS_SEC_DETECTSEQ	= TCS_INT(9183);
  CS_SEC_DATAORIGIN	= TCS_INT(9184);
  CS_SEC_MECHANISM	= TCS_INT(9185);
  CS_SEC_CREDENTIALS	= TCS_INT(9186);
  CS_SEC_CHANBIND	= TCS_INT(9187);
  CS_SEC_SERVERPRINCIPAL= TCS_INT(9188);
  CS_SEC_KEYTAB		= TCS_INT(9189);

{*
** More properties
*}
  CS_ABORTCHK_INTERVAL	= TCS_INT(9190);
  CS_LOGIN_TYPE		= TCS_INT(9191);
  CS_CON_KEEPALIVE	= TCS_INT(9192);
  CS_CON_TCP_NODELAY	= TCS_INT(9193);
  CS_LOGIN_REMOTE_SERVER= TCS_INT(9194);
  CS_LOGIN_REMOTE_PASSWD= TCS_INT(9195);

{*
** Property for reverting to behavior of earlier versions
*}
  CS_BEHAVIOR		= TCS_INT(9197);

{*
** Property for HA failover
*}
  CS_HAFAILOVER  	= TCS_INT(9196);

{*
** Property for Directory services. (belongs with CS_DS_* above)
** Added at LDAP implementation time.
*}
  CS_DS_PASSWORD	= TCS_INT(9198);

{*
** Properties for SSL
*}
  CS_PROP_SSL_PROTOVERSION     = TCS_INT(9200);
  CS_PROP_SSL_CIPHER	       = TCS_INT(9201);
  CS_PROP_SSL_LOCALID	       = TCS_INT(9202);
  CS_PROP_SSL_CA	       = TCS_INT(9203);
  CS_PROP_TLS_KEYREGEN	       = TCS_INT(9205);

{*
** CS_DS_SCOPE Values
*}
  CS_SCOPE_COUNTRY	= TCS_INT(1);
  CS_SCOPE_DMD		= TCS_INT(2);
  CS_SCOPE_WORLD 	= TCS_INT(3);

{*
** CS_DS_SEARCH Values
*}
  CS_SEARCH_OBJECT	= TCS_INT(1);
  CS_SEARCH_ONE_LEVEL	= TCS_INT(2);
  CS_SEARCH_SUBTREE	= TCS_INT(3);

{*
** Possible values for the CS_NETIO property.
*}
  CS_SYNC_IO		= TCS_INT(8111);
  CS_ASYNC_IO		= TCS_INT(8112);
  CS_DEFER_IO		= TCS_INT(8113);

{*
** Possible bit values for the CS_LOGIN_STATUS property.
*}
  CS_CONSTAT_CONNECTED	= TCS_INT($01);
  CS_CONSTAT_DEAD  	= TCS_INT($02);


{*
** Possible bit values for the CS_CUR_STATUS property.
*}
  CS_CURSTAT_NONE   	= TCS_INT($00);
  CS_CURSTAT_DECLARED	= TCS_INT($01);
  CS_CURSTAT_OPEN   	= TCS_INT($02);
  CS_CURSTAT_CLOSED	= TCS_INT($04);
  CS_CURSTAT_RDONLY	= TCS_INT($08);
  CS_CURSTAT_UPDATABLE	= TCS_INT($10);
  CS_CURSTAT_ROWCOUNT	= TCS_INT($20);
  CS_CURSTAT_DEALLOC	= TCS_INT($40);

{*
** Possible bit values for implicit cursor status
*}
  CS_IMPCURSTAT_NONE	       = TCS_INT($00);
  CS_IMPCURSTAT_READROWS       = TCS_INT($01);
  CS_IMPCURSTAT_CLOSED	       = TCS_INT($02);
  CS_IMPCURSTAT_SENDSUCCESS    = TCS_INT($04);
  CS_IMPCURSTAT_SENDDONE       = TCS_INT($08);

{*
** Possible values for the CS_TDS_VERSION property.
*}
  CS_TDS_40		= TCS_INT(7360);
  CS_TDS_42		= TCS_INT(7361);
  CS_TDS_46		= TCS_INT(7362);
  CS_TDS_495		= TCS_INT(7363);
  CS_TDS_50		= TCS_INT(7364);

{*
** Possible values for the CS_BEHAVIOR property.
*}
  CS_BEHAVIOR_100	= TCS_INT(7370);
  CS_BEHAVIOR_110	= TCS_INT(7371);
  CS_BEHAVIOR_120	= TCS_INT(7372);
  CS_BEHAVIOR_125	= TCS_INT(7373);

{*
** Possible values for the CS_PROP_SSL_PROTOVERSION property.
**
** If 2.0 handshake is desired with SSL 3.0 or TLS 1.0, or
** CS_SSLVER_20HAND
*}
  CS_SSLVER_20		= TCS_INT( 1 );
  CS_SSLVER_30		= TCS_INT( 2 );
  CS_SSLVER_TLS1	= TCS_INT( 3 );
  CS_SSLVER_20HAND	= TCS_INT( $80000000);

{*******************************************************************************
**
** Open Client/Server options.
**
*******************************************************************************}

{*
** The following is the list of all valid options:
*}
  CS_OPT_DATEFIRST      = TCS_INT(5001);		// Set first day of week
  CS_OPT_TEXTSIZE       = TCS_INT(5002);    	// Text size
  CS_OPT_STATS_TIME     = TCS_INT(5003);    	// Server time statistics
  CS_OPT_STATS_IO       = TCS_INT(5004);    	// Server I/O statistics
  CS_OPT_ROWCOUNT       = TCS_INT(5005);    	// Maximum row count
  CS_OPT_NATLANG        = TCS_INT(5006);    	// National Language
  CS_OPT_DATEFORMAT     = TCS_INT(5007);    	// Date format
  CS_OPT_ISOLATION      = TCS_INT(5008);    	// Transaction isolation level
  CS_OPT_AUTHON         = TCS_INT(5009);    	// Set authority level on
  CS_OPT_CHARSET        = TCS_INT(5010);    	// Character set
  CS_OPT_SHOWPLAN       = TCS_INT(5013);    	// show execution plan

  CS_OPT_NOEXEC         = TCS_INT(5014);    	// don't execute query
  CS_OPT_ARITHIGNORE    = TCS_INT(5015);    	// ignore arithmetic exceptions

  CS_OPT_TRUNCIGNORE    = TCS_INT(5016);    	// support ANSI null values
  CS_OPT_ARITHABORT     = TCS_INT(5017);    	// abort on arithmetic exceptions

  CS_OPT_PARSEONLY      = TCS_INT(5018);    	// parse only, return error msgs

  CS_OPT_GETDATA        = TCS_INT(5020);    	// return trigger data
  CS_OPT_NOCOUNT        = TCS_INT(5021);    	// don't print done count
  CS_OPT_FORCEPLAN      = TCS_INT(5023);    	// force variable substitute order

  CS_OPT_FORMATONLY     = TCS_INT(5024);    	// send format w/o row
  CS_OPT_CHAINXACTS     = TCS_INT(5025);    	// chained transaction mode
  CS_OPT_CURCLOSEONXACT = TCS_INT(5026);    	// close cursor on end trans
  CS_OPT_FIPSFLAG       = TCS_INT(5027);    	// FIPS flag
  CS_OPT_RESTREES     	= TCS_INT(5028);    	// return resolution trees
  CS_OPT_IDENTITYON     = TCS_INT(5029);    	// turn on explicit identity
  CS_OPT_CURREAD       	= TCS_INT(5030);    	// Set session label @@ curread

  CS_OPT_CURWRITE      	= TCS_INT(5031);    	// Set session label @@curwrite

  CS_OPT_IDENTITYOFF    = TCS_INT(5032);    	// turn off explicit identity
  CS_OPT_AUTHOFF      	= TCS_INT(5033);    	// Set authority level off
  CS_OPT_ANSINULL      	= TCS_INT(5034);    	// ANSI NULLS behavior
  CS_OPT_QUOTED_IDENT  	= TCS_INT(5035);    	// Quoted identifiers
  CS_OPT_ANSIPERM    	= TCS_INT(5036);    	// ANSI permission checking
  CS_OPT_STR_RTRUNC    	= TCS_INT(5037);    	// ANSI right truncation
  CS_OPT_SORTMERGE	= TCS_INT(5038);	// Sort merge join status   

  CS_MIN_OPTION		= CS_OPT_DATEFIRST;
  CS_MAX_OPTION		= CS_OPT_SORTMERGE;

{*
** The supported options are summarized below with their defined values
** for `ArgSize' and `OptionArg'. ArgSize specifies the domain of valid
** values that are allowed.
**
** Option			ArgSize		OptionArg
** ---------------		---------	---------
** CS_OPT_DATEFIRST 		1 byte		Defines below
** CS_OPT_TEXTSIZE 		4 bytes		Size in bytes
** CS_OPT_ROWCOUNT  		4 bytes		Number of rows
** CS_OPT_NATLANG 		OptionArg Len	National Lang (string)
** CS_OPT_DATEFORMAT 		1 byte		Defines below
** CS_OPT_ISOLATION 		1 byte		Defines below
** CS_OPT_AUTHON 		OptionArg Len	Table Name (string)
** CS_OPT_CHARSET 		OptionArg Len	Character set (string)
** CS_OPT_IDENTITYON 		OptionArg Len	Table Name (string)
** CS_OPT_CURREAD 		OptionArg Len	Read Label(string)
** CS_OPT_CURWRITE 		OptionArg Len	Write Label(string)
** CS_OPT_IDENTITYOFF 		OptionArg Len	Table Name (string)
** CS_OPT_AUTHOFF 		OptionArg Len	Table Name (string)
** (All remaining options)	1 byte		Boolean value
**
** All string values must be sent in 7 bit ASCII.
**
*}

{* CS_OPT_DATEFIRST *}
  CS_OPT_MONDAY		= TCS_INT(1);
  CS_OPT_TUESDAY     	= TCS_INT(2);
  CS_OPT_WEDNESDAY	= TCS_INT(3);