1 /* FreeTDS - Library of routines accessing Sybase and Microsoft databases 2 * Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004 Brian Bruns 3 * Copyright (C) 2010, 2011 Frediano Ziglio 4 * 5 * This library is free software; you can redistribute it and/or 6 * modify it under the terms of the GNU Library General Public 7 * License as published by the Free Software Foundation; either 8 * version 2 of the License, or (at your option) any later version. 9 * 10 * This library is distributed in the hope that it will be useful, 11 * but WITHOUT ANY WARRANTY; without even the implied warranty of 12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 13 * Library General Public License for more details. 14 * 15 * You should have received a copy of the GNU Library General Public 16 * License along with this library; if not, write to the 17 * Free Software Foundation, Inc., 59 Temple Place - Suite 330, 18 * Boston, MA 02111-1307, USA. 19 */ 20 21 /** \file ../include/sybdb.h 22 * \brief Primary include file for db-lib applications. 23 * 24 * Declares macros, functions, enumerated types, and defined tokens 25 * used by the db-lib API. 26 */ 27 28 #ifndef _sybdb_h_ 29 #define _sybdb_h_ 30 31 #include "tds_sysdep_public.h" 32 33 #undef TDS_STATIC_CAST 34 #ifdef __cplusplus 35 #define TDS_STATIC_CAST(type, a) static_cast<type>(a) 36 extern "C" 37 { 38 #if 0 39 } 40 #endif 41 #else 42 #define TDS_STATIC_CAST(type, a) ((type)(a)) 43 #endif 44 45 static const char rcsid_sybdb_h[] = "$Id: sybdb.h,v 1.106 2011-12-05 02:26:31 jklowden Exp $"; 46 static const void *const no_unused_sybdb_h_warn[] = { rcsid_sybdb_h, no_unused_sybdb_h_warn }; 47 48 #ifdef FALSE 49 #undef FALSE 50 #endif 51 #ifdef TRUE 52 #undef TRUE 53 #endif 54 #define FALSE 0 55 #define TRUE 1 56 57 #define DBSAVE 1 58 #define DBNOSAVE 0 59 #define DBNOERR -1 60 61 #define INT_EXIT 0 62 #define INT_CONTINUE 1 63 #define INT_CANCEL 2 64 #define INT_TIMEOUT 3 65 66 #define DBMAXNUMLEN 33 67 /* https://msdn.microsoft.com/en-us/library/ms176061.aspx */ 68 #define DBMAXNAME 128 69 70 /** 71 * DBVERSION_xxx are used with dbsetversion() 72 */ 73 #define DBVERSION_UNKNOWN 0 74 #define DBVERSION_46 1 75 #define DBVERSION_100 2 76 #define DBVERSION_42 3 77 #define DBVERSION_70 4 78 #define DBVERSION_71 5 79 #define DBVERSION_80 DBVERSION_71 80 #define DBVERSION_72 6 81 #define DBVERSION_73 7 82 83 /* these two are defined by Microsoft for dbsetlversion() */ 84 #define DBVER42 DBVERSION_42 85 #define DBVER60 DBVERSION_70 /* our best approximation */ 86 87 /** 88 * DBTDS_xxx are returned by DBTDS() 89 * The integer values of the constants are poorly chosen. 90 */ 91 #define DBTDS_UNKNOWN 0 92 #define DBTDS_2_0 1 /* pre 4.0 SQL Server */ 93 #define DBTDS_3_4 2 /* Microsoft SQL Server (3.0) */ 94 #define DBTDS_4_0 3 /* 4.0 SQL Server */ 95 #define DBTDS_4_2 4 /* 4.2 SQL Server */ 96 #define DBTDS_4_6 5 /* 2.0 OpenServer and 4.6 SQL Server. */ 97 #define DBTDS_4_9_5 6 /* 4.9.5 (NCR) SQL Server */ 98 #define DBTDS_5_0 7 /* 5.0 SQL Server */ 99 #define DBTDS_7_0 8 /* Microsoft SQL Server 7.0 */ 100 #define DBTDS_8_0 9 /* Microsoft SQL Server 2000 */ 101 #define DBTDS_9_0 10 /* Microsoft SQL Server 2005 */ 102 #define DBTDS_7_1 9 /* Microsoft SQL Server 2000 */ 103 #define DBTDS_7_2 10 /* Microsoft SQL Server 2005 */ 104 #define DBTDS_7_3 11 /* Microsoft SQL Server 2008 */ 105 106 #define DBTXPLEN 16 107 108 #define BCPMAXERRS 1 109 #define BCPFIRST 2 110 #define BCPLAST 3 111 #define BCPBATCH 4 112 #define BCPKEEPIDENTITY 8 113 114 #define BCPLABELED 5 115 #define BCPHINTS 6 116 117 #define DBCMDNONE 0 118 #define DBCMDPEND 1 119 #define DBCMDSENT 2 120 121 typedef int RETCODE; 122 123 typedef void DBCURSOR; 124 typedef void DBXLATE; 125 typedef void DBSORTORDER; 126 typedef void DBLOGINFO; 127 typedef void *DBVOIDPTR; 128 typedef short SHORT; 129 typedef unsigned short USHORT; 130 typedef int (*INTFUNCPTR) (void *, ...); 131 typedef int (*DBWAITFUNC) (void); 132 typedef DBWAITFUNC(*DB_DBBUSY_FUNC) (void *dbproc); 133 typedef void (*DB_DBIDLE_FUNC) (DBWAITFUNC dfunc, void *dbproc); 134 typedef int (*DB_DBCHKINTR_FUNC) (void *dbproc); 135 typedef int (*DB_DBHNDLINTR_FUNC) (void *dbproc); 136 137 #ifndef __INCvxWorksh 138 /* VxWorks already defines STATUS and BOOL. Compiler gets mad if you 139 ** redefine them. */ 140 /* __INCvxWorksh will get #defined by std. include files included from tds.h 141 */ 142 #ifdef STATUS 143 /* On DU4.0d we get a conflicting STATUS definition from arpa/nameser.h 144 when _REENTRANT is defined. 145 */ 146 #undef STATUS 147 #endif 148 typedef int STATUS; 149 #if !defined(_WINDEF_) && !defined(_WINDEF_H) && !defined(DOS32X) 150 typedef int BOOL; 151 #endif 152 #endif 153 154 #ifndef _tds_h_ 155 /* copied from tds.h */ 156 /* TODO find a best way... */ 157 enum 158 { 159 SYBCHAR = 47, /* 0x2F */ 160 #define SYBCHAR SYBCHAR 161 SYBVARCHAR = 39, /* 0x27 */ 162 #define SYBVARCHAR SYBVARCHAR 163 SYBINTN = 38, /* 0x26 */ 164 #define SYBINTN SYBINTN 165 SYBINT1 = 48, /* 0x30 */ 166 #define SYBINT1 SYBINT1 167 SYBINT2 = 52, /* 0x34 */ 168 #define SYBINT2 SYBINT2 169 SYBINT4 = 56, /* 0x38 */ 170 #define SYBINT4 SYBINT4 171 SYBINT8 = 127, /* 0x7F */ 172 #define SYBINT8 SYBINT8 173 SYBFLT8 = 62, /* 0x3E */ 174 #define SYBFLT8 SYBFLT8 175 SYBDATETIME = 61, /* 0x3D */ 176 #define SYBDATETIME SYBDATETIME 177 SYBBIT = 50, /* 0x32 */ 178 #define SYBBIT SYBBIT 179 SYBBITN = 104, /* 0x68 */ 180 #define SYBBITN SYBBITN 181 SYBTEXT = 35, /* 0x23 */ 182 #define SYBTEXT SYBTEXT 183 SYBNTEXT = 99, /* 0x63 */ 184 #define SYBNTEXT SYBNTEXT 185 SYBIMAGE = 34, /* 0x22 */ 186 #define SYBIMAGE SYBIMAGE 187 SYBMONEY4 = 122, /* 0x7A */ 188 #define SYBMONEY4 SYBMONEY4 189 SYBMONEY = 60, /* 0x3C */ 190 #define SYBMONEY SYBMONEY 191 SYBDATETIME4 = 58, /* 0x3A */ 192 #define SYBDATETIME4 SYBDATETIME4 193 SYBREAL = 59, /* 0x3B */ 194 #define SYBREAL SYBREAL 195 SYBBINARY = 45, /* 0x2D */ 196 #define SYBBINARY SYBBINARY 197 SYBVOID = 31, /* 0x1F */ 198 #define SYBVOID SYBVOID 199 SYBVARBINARY = 37, /* 0x25 */ 200 #define SYBVARBINARY SYBVARBINARY 201 SYBNUMERIC = 108, /* 0x6C */ 202 #define SYBNUMERIC SYBNUMERIC 203 SYBDECIMAL = 106, /* 0x6A */ 204 #define SYBDECIMAL SYBDECIMAL 205 SYBFLTN = 109, /* 0x6D */ 206 #define SYBFLTN SYBFLTN 207 SYBMONEYN = 110, /* 0x6E */ 208 #define SYBMONEYN SYBMONEYN 209 SYBDATETIMN = 111, /* 0x6F */ 210 #define SYBDATETIMN SYBDATETIMN 211 SYBNVARCHAR = 103, /* 0x67 */ 212 #define SYBNVARCHAR SYBNVARCHAR 213 SYBMSDATE = 40, /* 0x28 */ 214 #define SYBMSDATE SYBMSDATE 215 SYBMSTIME = 41, /* 0x29 */ 216 #define SYBMSTIME SYBMSTIME 217 SYBMSDATETIME2 = 42, /* 0x2A */ 218 #define SYBMSDATETIME2 SYBMSDATETIME2 219 SYBMSDATETIMEOFFSET = 43, /* 0x2B */ 220 #define SYBMSDATETIMEOFFSET SYBMSDATETIMEOFFSET 221 }; 222 223 #define SYBAOPCNT 0x4b 224 #define SYBAOPCNTU 0x4c 225 #define SYBAOPSUM 0x4d 226 #define SYBAOPSUMU 0x4e 227 #define SYBAOPAVG 0x4f 228 #define SYBAOPAVGU 0x50 229 #define SYBAOPMIN 0x51 230 #define SYBAOPMAX 0x52 231 232 /* mssql2k compute operator */ 233 #define SYBAOPCNT_BIG 0x09 234 #define SYBAOPSTDEV 0x30 235 #define SYBAOPSTDEVP 0x31 236 #define SYBAOPVAR 0x32 237 #define SYBAOPVARP 0x33 238 #define SYBAOPCHECKSUM_AGG 0x72 239 240 #endif 241 242 typedef unsigned char DBBOOL; 243 typedef char DBCHAR; 244 typedef unsigned char DBBIT; 245 typedef unsigned char DBTINYINT; 246 typedef tds_sysdep_int16_type DBSMALLINT; 247 typedef tds_sysdep_int32_type DBINT; 248 typedef tds_sysdep_int64_type DBBIGINT; 249 typedef unsigned char DBBINARY; 250 typedef tds_sysdep_real32_type DBREAL; 251 typedef tds_sysdep_real64_type DBFLT8; 252 typedef unsigned tds_sysdep_int16_type DBUSMALLINT; 253 typedef unsigned tds_sysdep_int32_type DBUINT; 254 typedef unsigned tds_sysdep_int64_type DBUBIGINT; 255 256 typedef struct 257 { 258 DBSMALLINT len; 259 char str[256]; 260 } DBVARYCHAR; 261 262 typedef struct 263 { 264 DBSMALLINT len; 265 unsigned char array[256]; 266 } DBVARYBIN; 267 268 typedef struct 269 { 270 unsigned char precision; 271 unsigned char scale; 272 unsigned char array[33]; 273 } DBNUMERIC; 274 275 typedef DBNUMERIC DBDECIMAL; 276 277 typedef struct 278 { 279 DBINT mnyhigh; 280 unsigned tds_sysdep_int32_type mnylow; 281 } DBMONEY; 282 283 typedef struct 284 { 285 DBINT mny4; 286 } DBMONEY4; 287 288 typedef struct 289 { 290 DBINT dtdays; 291 DBINT dttime; 292 } DBDATETIME; 293 294 typedef struct 295 { 296 DBUSMALLINT days; /* days since Jan-1-1900 */ 297 DBUSMALLINT minutes; /* minutes since midnight */ 298 } DBDATETIME4; 299 300 typedef struct 301 { 302 DBUBIGINT time; /**< time, 7 digit precision */ 303 DBINT date; /**< date, 0 = 1900-01-01 */ 304 DBSMALLINT offset; /**< time offset */ 305 DBUSMALLINT time_prec:3; 306 DBUSMALLINT _res:10; 307 DBUSMALLINT has_time:1; 308 DBUSMALLINT has_date:1; 309 DBUSMALLINT has_offset:1; 310 } DBDATETIMEALL; 311 312 #ifdef MSDBLIB 313 # define SQLCHAR SYBCHAR 314 typedef struct 315 { 316 DBUSMALLINT numdays; 317 DBUSMALLINT nummins; 318 } DBDATETIM4; 319 #endif 320 321 typedef struct tds_dblib_loginrec LOGINREC; 322 323 #ifndef DOS32X 324 typedef unsigned char BYTE; 325 #endif 326 327 typedef struct dbtypeinfo 328 { 329 DBINT precision; 330 DBINT scale; 331 } DBTYPEINFO; 332 333 struct dbstring 334 { 335 BYTE *strtext; 336 DBINT strtotlen; 337 struct dbstring *strnext; 338 }; 339 typedef struct dbstring DBSTRING; 340 341 /* Used by dbcolinfo */ 342 enum 343 { MAXCOLNAMELEN = 512 }; /* duplicates TDS_SYSNAME_SIZE */ 344 typedef enum { CI_REGULAR=1, CI_ALTERNATE=2, CI_CURSOR=3 } CI_TYPE; 345 346 typedef struct 347 { 348 DBINT SizeOfStruct; 349 DBCHAR Name[MAXCOLNAMELEN+2]; 350 DBCHAR ActualName[MAXCOLNAMELEN+2]; 351 DBCHAR TableName[MAXCOLNAMELEN+2]; 352 SHORT Type; 353 DBINT UserType; 354 DBINT MaxLength; 355 BYTE Precision; 356 BYTE Scale; 357 BOOL VarLength; 358 BYTE Null; 359 BYTE CaseSensitive; 360 BYTE Updatable; 361 BOOL Identity; 362 363 } DBCOL; 364 365 typedef struct 366 { 367 DBINT SizeOfStruct; 368 DBCHAR Name[MAXCOLNAMELEN+2]; 369 DBCHAR ActualName[MAXCOLNAMELEN+2]; 370 DBCHAR TableName[MAXCOLNAMELEN+2]; 371 SHORT Type; 372 DBINT UserType; 373 DBINT MaxLength; 374 BYTE Precision; 375 BYTE Scale; 376 BOOL VarLength; 377 BYTE Null; 378 BYTE CaseSensitive; 379 BYTE Updatable; 380 BOOL Identity; 381 SHORT ServerType; 382 DBINT ServerMaxLength; 383 DBCHAR ServerTypeDeclaration[256]; 384 } DBCOL2; 385 /* end dbcolinfo stuff */ 386 387 388 389 /* a large list of options, DBTEXTSIZE is needed by sybtcl */ 390 #define DBPARSEONLY 0 391 #define DBESTIMATE 1 392 #define DBSHOWPLAN 2 393 #define DBNOEXEC 3 394 #define DBARITHIGNORE 4 395 #define DBNOCOUNT 5 396 #define DBARITHABORT 6 397 #define DBTEXTLIMIT 7 398 #define DBBROWSE 8 399 #define DBOFFSET 9 400 #define DBSTAT 10 401 #define DBERRLVL 11 402 #define DBCONFIRM 12 403 #define DBSTORPROCID 13 404 #define DBBUFFER 14 405 #define DBNOAUTOFREE 15 406 #define DBROWCOUNT 16 407 #define DBTEXTSIZE 17 408 #define DBNATLANG 18 409 #define DBDATEFORMAT 19 410 #define DBPRPAD 20 411 #define DBPRCOLSEP 21 412 #define DBPRLINELEN 22 413 #define DBPRLINESEP 23 414 #define DBLFCONVERT 24 415 #define DBDATEFIRST 25 416 #define DBCHAINXACTS 26 417 #define DBFIPSFLAG 27 418 #define DBISOLATION 28 419 #define DBAUTH 29 420 #define DBIDENTITY 30 421 #define DBNOIDCOL 31 422 #define DBDATESHORT 32 423 #define DBCLIENTCURSORS 33 424 #define DBSETTIME 34 425 #define DBQUOTEDIDENT 35 426 427 #define DBNUMOPTIONS 36 428 429 #define DBPADOFF 0 430 #define DBPADON 1 431 432 #define OFF 0 433 #define ON 1 434 435 #define NOSUCHOPTION 2 436 437 #define MAXOPTTEXT 32 438 439 typedef struct tds_dblib_dbprocess DBPROCESS; 440 441 /* 442 * Sybase & Microsoft use different names for the dbdaterec members. 443 * Keep these two structures physically identical in memory. 444 * dbdatecrack() casts one to the other for ease of implementation. 445 * 446 * Giving credit where credit is due, we can acknowledge that 447 * Microsoft chose the better names here, hands down. ("datedmonth"?!) 448 */ 449 struct tds_microsoft_dbdaterec 450 { 451 DBINT year; /* 1753 - 9999 */ 452 DBINT quarter; /* 1 - 4 */ 453 DBINT month; /* 1 - 12 */ 454 DBINT day; /* 1 - 31 */ 455 DBINT dayofyear; /* 1 - 366 */ 456 DBINT week; /* 1 - 54 (for leap years) */ 457 DBINT weekday; /* 1 - 7 (Mon. - Sun.) */ 458 DBINT hour; /* 0 - 23 */ 459 DBINT minute; /* 0 - 59 */ 460 DBINT second; /* 0 - 59 */ 461 DBINT millisecond; /* 0 - 999 */ 462 DBINT tzone; /* -840 - 840 */ 463 }; 464 465 struct tds_sybase_dbdaterec 466 { 467 DBINT dateyear; /* 1900 and counting */ 468 DBINT quarter; /* 0 - 3 (Microsoft only) */ 469 DBINT datemonth; /* 0 - 11 */ 470 DBINT datedmonth; /* 1 - 31 */ 471 DBINT datedyear; /* 1 - 366 */ 472 DBINT week; /* 1 - 54 (Microsoft only) */ 473 DBINT datedweek; /* 0 - 6 */ 474 DBINT datehour; /* 0 - 23 */ 475 DBINT dateminute; /* 0 - 59 */ 476 DBINT datesecond; /* 0 - 59 */ 477 DBINT datemsecond; /* 0 - 999 */ 478 DBINT datetzone; /* -840 - 840 */ 479 }; 480 481 struct tds_microsoft_dbdaterec2 482 { 483 DBINT year; /* 1753 - 9999 */ 484 DBINT quarter; /* 1 - 4 */ 485 DBINT month; /* 1 - 12 */ 486 DBINT day; /* 1 - 31 */ 487 DBINT dayofyear; /* 1 - 366 */ 488 DBINT week; /* 1 - 54 (for leap years) */ 489 DBINT weekday; /* 1 - 7 (Mon. - Sun.) */ 490 DBINT hour; /* 0 - 23 */ 491 DBINT minute; /* 0 - 59 */ 492 DBINT second; /* 0 - 59 */ 493 DBINT nanosecond; /* 0 - 999999999 */ 494 DBINT tzone; /* 0 - 127 (Sybase only) */ 495 }; 496 497 struct tds_sybase_dbdaterec2 498 { 499 DBINT dateyear; /* 1900 and counting */ 500 DBINT quarter; /* 0 - 3 (Microsoft only) */ 501 DBINT datemonth; /* 0 - 11 */ 502 DBINT datedmonth; /* 1 - 31 */ 503 DBINT datedyear; /* 1 - 366 */ 504 DBINT week; /* 1 - 54 (Microsoft only) */ 505 DBINT datedweek; /* 0 - 6 */ 506 DBINT datehour; /* 0 - 23 */ 507 DBINT dateminute; /* 0 - 59 */ 508 DBINT datesecond; /* 0 - 59 */ 509 DBINT datensecond; /* 0 - 999999999 */ 510 DBINT datetzone; /* 0 - 127 */ 511 }; 512 513 514 #ifdef MSDBLIB 515 typedef struct tds_microsoft_dbdaterec DBDATEREC; 516 typedef struct tds_microsoft_dbdaterec2 DBDATEREC2; 517 #else 518 typedef struct tds_sybase_dbdaterec DBDATEREC; 519 typedef struct tds_sybase_dbdaterec2 DBDATEREC2; 520 #endif 521 522 typedef int (*EHANDLEFUNC) (DBPROCESS * dbproc, int severity, int dberr, int oserr, char *dberrstr, char *oserrstr); 523 524 typedef int (*MHANDLEFUNC) (DBPROCESS * dbproc, DBINT msgno, int msgstate, int severity, char *msgtext, char *srvname, 525 char *proc, int line); 526 527 /* dbpoll() result codes, sybtcl needs DBRESULT */ 528 #define DBRESULT 1 529 #define DBNOTIFICATION 2 530 #define DBTIMEOUT 3 531 #define DBINTERRUPT 4 532 533 /* more sybtcl needs: */ 534 #define DBTXTSLEN 8 535 536 /* bind types */ 537 #define CHARBIND 0 538 #define STRINGBIND 1 539 #define NTBSTRINGBIND 2 540 #define VARYCHARBIND 3 541 #define VARYBINBIND 4 542 #define TINYBIND 6 543 #define SMALLBIND 7 544 #define INTBIND 8 545 #define FLT8BIND 9 546 #define REALBIND 10 547 #define DATETIMEBIND 11 548 #define SMALLDATETIMEBIND 12 549 #define MONEYBIND 13 550 #define SMALLMONEYBIND 14 551 #define BINARYBIND 15 552 #define BITBIND 16 553 #define NUMERICBIND 17 554 #define DECIMALBIND 18 555 #define SRCNUMERICBIND 19 556 #define SRCDECIMALBIND 20 557 #define BIGINTBIND 30 558 #define DATETIME2BIND 31 559 #define MAXBINDTYPES 32 /* keep last */ 560 561 #define DBPRCOLSEP 21 562 #define DBPRLINELEN 22 563 #define DBRPCRETURN 1 564 #define DBRPCDEFAULT 2 565 566 #define REG_ROW -1 567 #define MORE_ROWS -1 568 #define NO_MORE_ROWS -2 569 #define BUF_FULL -3 570 #define NO_MORE_RESULTS 2 571 #define SUCCEED 1 572 #define FAIL 0 573 574 #define DB_IN 1 575 #define DB_OUT 2 576 #define DB_QUERYOUT 3 577 578 #define DBSINGLE 0 579 #define DBDOUBLE 1 580 #define DBBOTH 2 581 582 /* remote procedure call (rpc) options */ 583 #define DBRPCRECOMPILE TDS_STATIC_CAST(DBSMALLINT, 0x0001) 584 #define DBRPCRESET TDS_STATIC_CAST(DBSMALLINT, 0x0002) 585 #define DBRPCCURSOR TDS_STATIC_CAST(DBSMALLINT, 0x0008) 586 587 #if defined(DBLIB_UNIMPLEMENTED) 588 DBBOOL db12hour(DBPROCESS * dbprocess, const char language[]); 589 590 DBBOOL dbcolbrowse(DBPROCESS * dbprocess, int colnum); 591 592 RETCODE dbcursor(DBCURSOR * hc, DBINT optype, DBINT bufno, BYTE * table, BYTE * values); 593 RETCODE dbcursorbind(DBCURSOR * hc, int col, int vartype, DBINT varlen, DBINT * poutlen, BYTE * pvaraddr, DBTYPEINFO * typeinfo); 594 void dbcursorclose(DBCURSOR * hc); 595 RETCODE dbcursorcolinfo(DBCURSOR * hc, DBINT column, DBCHAR * colname, DBINT * coltype, DBINT * collen, DBINT * usertype); 596 RETCODE dbcursorfetch(DBCURSOR * hc, DBINT fetchtype, DBINT rownum); 597 RETCODE dbcursorinfo(DBCURSOR * hc, DBINT * ncols, DBINT * nrows); 598 DBCURSOR *dbcursoropen(DBPROCESS * dbprocess, BYTE * stmt, SHORT scollopt, SHORT concuropt, USHORT nrows, DBINT * pstatus); 599 600 int dbdate4cmp(DBPROCESS * dbprocess, DBDATETIME4 * d1, DBDATETIME4 * d2); 601 RETCODE dbdate4zero(DBPROCESS * dbprocess, DBDATETIME4 * d1); 602 RETCODE dbdatechar(DBPROCESS * dbprocess, char *buf, int datepart, int value); 603 int dbdatename(DBPROCESS * dbprocess, char *buf, int date, DBDATETIME * datetime); 604 char *dateorder(DBPROCESS * dbprocess, char *language); 605 DBINT dbdatepart(DBPROCESS * dbprocess, int datepart, DBDATETIME * datetime); 606 RETCODE dbdatezero(DBPROCESS * dbprocess, DBDATETIME * d1); 607 char *dbdayname(DBPROCESS * dbprocess, char *language, int daynum); 608 609 int dbgetoff(DBPROCESS * dbprocess, DBUSMALLINT offtype, int startfrom); 610 611 char *dbqual(DBPROCESS * dbprocess, int tabnum, char *tabname); 612 void dbfreequal(char *qualptr); 613 614 DBSORTORDER *dbloadsort(DBPROCESS * dbprocess); 615 RETCODE dbfreesort(DBPROCESS * dbprocess, DBSORTORDER * sortorder); 616 617 RETCODE dbload_xlate(DBPROCESS * dbprocess, char *srv_charset, char *clt_name, DBXLATE ** xlt_tosrv, DBXLATE ** xlt_todisp); 618 619 RETCODE dbmny4divide(DBPROCESS * dbproc, DBMONEY4 * m1, DBMONEY4 * m2, DBMONEY4 * quotient); 620 RETCODE dbmny4mul(DBPROCESS * dbproc, DBMONEY4 * m1, DBMONEY4 * m2, DBMONEY4 * prod); 621 RETCODE dbmnyadd(DBPROCESS * dbproc, DBMONEY * m1, DBMONEY * m2, DBMONEY * sum); 622 RETCODE dbmnydivide(DBPROCESS * dbproc, DBMONEY * m1, DBMONEY * m2, DBMONEY * quotient); 623 RETCODE dbmnydown(DBPROCESS * dbproc, DBMONEY * mnyptr, int divisor, int *remainder); 624 RETCODE dbmnyinit(DBPROCESS * dbproc, DBMONEY * mnyptr, int trim, DBBOOL * negative); 625 RETCODE dbmnyndigit(DBPROCESS * dbproc, DBMONEY * mnyptr, DBCHAR * value, DBBOOL * zero); 626 RETCODE dbmnymul(DBPROCESS * dbproc, DBMONEY * m1, DBMONEY * m2, DBMONEY * prod); 627 RETCODE dbmnydigit(DBPROCESS * dbprocess, DBMONEY * m1, DBCHAR * value, DBBOOL * zero); 628 RETCODE dbmnyscale(DBPROCESS * dbproc, DBMONEY * dest, int multiplier, int addend); 629 630 631 RETCODE dbnpcreate(DBPROCESS * dbprocess); 632 RETCODE dbnpdefine(DBPROCESS * dbprocess, DBCHAR * procedure_name, DBSMALLINT namelen); 633 634 int DBNUMORDERS(DBPROCESS * dbprocess); 635 636 RETCODE dbpoll(DBPROCESS * dbproc, long milliseconds, DBPROCESS ** ready_dbproc, int *return_reason); 637 int dbordercol(DBPROCESS * dbprocess, int order); 638 639 RETCODE dbregdrop(DBPROCESS * dbprocess, DBCHAR * procnm, DBSMALLINT namelen); 640 RETCODE dbregexec(DBPROCESS * dbproc, DBUSMALLINT options); 641 RETCODE dbreghandle(DBPROCESS * dbprocess, DBCHAR * procnm, DBSMALLINT namelen, INTFUNCPTR handler); 642 RETCODE dbreginit(DBPROCESS * dbproc, DBCHAR * procedure_name, DBSMALLINT namelen); 643 RETCODE dbreglist(DBPROCESS * dbproc); 644 RETCODE dbregnowatch(DBPROCESS * dbprocess, DBCHAR * procnm, DBSMALLINT namelen); 645 RETCODE dbregparam(DBPROCESS * dbproc, char *param_name, int type, DBINT datalen, BYTE * data); 646 RETCODE dbregwatch(DBPROCESS * dbprocess, DBCHAR * procnm, DBSMALLINT namelen, DBUSMALLINT options); 647 RETCODE dbregwatchlist(DBPROCESS * dbprocess); 648 649 void dbrpwclr(LOGINREC * login); 650 RETCODE dbrpwset(LOGINREC * login, char *srvname, char *password, int pwlen); 651 652 DBINT dbreadpage(DBPROCESS * dbprocess, char *p_dbname, DBINT pageno, BYTE * buf); 653 RETCODE dbwritepage(DBPROCESS * dbprocess, char *p_dbname, DBINT pageno, DBINT size, BYTE * buf); 654 655 RETCODE dbsetdeflang(char *language); 656 657 int dbstrcmp(DBPROCESS * dbprocess, char *s1, int l1, char *s2, int l2, DBSORTORDER * sort); 658 int dbstrsort(DBPROCESS * dbprocess, char *s1, int l1, char *s2, int l2, DBSORTORDER * sort); 659 660 DBBOOL dbtabbrowse(DBPROCESS * dbprocess, int tabnum); 661 int dbtabcount(DBPROCESS * dbprocess); 662 char *dbtabname(DBPROCESS * dbprocess, int tabnum); 663 char *dbtabsource(DBPROCESS * dbprocess, int colnum, int *tabnum); 664 665 RETCODE dbsetlshort(LOGINREC * login, int value, int which); 666 667 RETCODE dbsendpassthru(DBPROCESS * dbprocess, DBVOIDPTR bufp); 668 RETCODE dbrecvpassthru(DBPROCESS * dbprocess, DBVOIDPTR * bufp); 669 670 RETCODE dbgetloginfo(DBPROCESS * dbprocess, DBLOGINFO ** loginfo); 671 RETCODE dbsetloginfo(LOGINREC * loginrec, DBLOGINFO * loginfo); 672 673 int dbtsnewlen(DBPROCESS * dbprocess); 674 DBBINARY *dbtsnewval(DBPROCESS * dbprocess); 675 RETCODE dbtsput(DBPROCESS * dbprocess, DBBINARY * newts, int newtslen, int tabnum, char *tabname); 676 677 RETCODE dbfree_xlate(DBPROCESS * dbprocess, DBXLATE * xlt_tosrv, DBXLATE * clt_todisp); 678 int dbxlate(DBPROCESS * dbprocess, char *src, int srclen, char *dest, int destlen, DBXLATE * xlt, int *srcbytes_used, 679 DBBOOL srcend, int status); 680 681 RETCODE bcp_moretext(DBPROCESS * dbproc, DBINT size, BYTE * text); 682 RETCODE bcp_writefmt(DBPROCESS * dbproc, const char filename[]); 683 684 void build_xact_string(char *xact_name, char *service_name, DBINT commid, char *result); 685 RETCODE remove_xact(DBPROCESS * connect, DBINT commid, int n); 686 RETCODE abort_xact(DBPROCESS * connect, DBINT commid); 687 void close_commit(DBPROCESS * connect); 688 RETCODE commit_xact(DBPROCESS * connect, DBINT commid); 689 DBPROCESS *open_commit(LOGINREC * login, char *servername); 690 RETCODE scan_xact(DBPROCESS * connect, DBINT commid); 691 DBINT start_xact(DBPROCESS * connect, char *application_name, char *xact_name, int site_count); 692 DBINT stat_xact(DBPROCESS * connect, DBINT commid); 693 694 #endif /* define unimplemented */ 695 696 BYTE *dbadata(DBPROCESS * dbproc, int computeid, int column); 697 DBINT dbadlen(DBPROCESS * dbproc, int computeid, int column); 698 RETCODE dbaltbind(DBPROCESS * dbprocess, int computeid, int column, int vartype, DBINT varlen, BYTE * varaddr); 699 RETCODE dbaltbind_ps(DBPROCESS * dbprocess, int computeid, int column, int vartype, DBINT varlen, BYTE * varaddr, 700 DBTYPEINFO * typeinfo); 701 int dbaltcolid(DBPROCESS * dbproc, int computeid, int column); 702 DBINT dbaltlen(DBPROCESS * dbproc, int computeid, int column); 703 int dbaltop(DBPROCESS * dbproc, int computeid, int column); 704 int dbalttype(DBPROCESS * dbproc, int computeid, int column); 705 DBINT dbaltutype(DBPROCESS * dbproc, int computeid, int column); 706 RETCODE dbanullbind(DBPROCESS * dbprocess, int computeid, int column, DBINT * indicator); 707 RETCODE dbbind(DBPROCESS * dbproc, int column, int vartype, DBINT varlen, BYTE * varaddr); 708 RETCODE dbbind_ps(DBPROCESS * dbprocess, int column, int vartype, DBINT varlen, BYTE * varaddr, DBTYPEINFO * typeinfo); 709 int dbbufsize(DBPROCESS * dbprocess); 710 BYTE *dbbylist(DBPROCESS * dbproc, int computeid, int *size); 711 RETCODE dbcancel(DBPROCESS * dbproc); 712 RETCODE dbcanquery(DBPROCESS * dbproc); 713 char *dbchange(DBPROCESS * dbprocess); 714 DBBOOL dbcharsetconv(DBPROCESS * dbprocess); 715 void dbclose(DBPROCESS * dbproc); 716 void dbclrbuf(DBPROCESS * dbproc, DBINT n); 717 RETCODE dbclropt(DBPROCESS * dbproc, int option, const char param[]); 718 RETCODE dbcmd(DBPROCESS * dbproc, const char cmdstring[]); 719 RETCODE dbcmdrow(DBPROCESS * dbproc); 720 721 #define DBCMDROW(x) dbcmdrow((x)) 722 RETCODE dbtablecolinfo (DBPROCESS *dbproc, DBINT column, DBCOL *pdbcol ); 723 RETCODE dbcolinfo (DBPROCESS *dbproc, CI_TYPE type, DBINT column, DBINT computeid, DBCOL *pdbcol); 724 DBINT dbcollen(DBPROCESS * dbproc, int column); 725 char *dbcolname(DBPROCESS * dbproc, int column); 726 char *dbcolsource(DBPROCESS * dbproc, int colnum); 727 int dbcoltype(DBPROCESS * dbproc, int column); 728 DBTYPEINFO *dbcoltypeinfo(DBPROCESS * dbproc, int column); 729 DBINT dbcolutype(DBPROCESS * dbprocess, int column); 730 DBINT dbconvert(DBPROCESS * dbproc, int srctype, const BYTE * src, DBINT srclen, int desttype, BYTE * dest, DBINT destlen); 731 DBINT dbconvert_ps(DBPROCESS * dbprocess, int srctype, const BYTE * src, DBINT srclen, int desttype, BYTE * dest, DBINT destlen, 732 DBTYPEINFO * typeinfo); 733 BOOL dbiscount(DBPROCESS * dbproc); 734 DBINT dbcount(DBPROCESS * dbproc); 735 736 #define DBCOUNT(x) dbcount((x)) 737 int dbcurcmd(DBPROCESS * dbproc); 738 739 #define DBCURCMD(x) dbcurcmd((x)) 740 DBINT dbcurrow(DBPROCESS * dbproc); 741 742 #define DBCURROW(x) dbcurrow((x)) 743 BYTE *dbdata(DBPROCESS * dbproc, int column); 744 int dbdatecmp(DBPROCESS * dbproc, DBDATETIME * d1, DBDATETIME * d2); 745 RETCODE dbdatecrack(DBPROCESS * dbproc, DBDATEREC * di, DBDATETIME * dt); 746 RETCODE dbanydatecrack(DBPROCESS * dbproc, DBDATEREC2 * di, int type, const void *data); 747 DBINT dbdatlen(DBPROCESS * dbproc, int column); 748 DBBOOL dbdead(DBPROCESS * dbproc); 749 750 #define DBDEAD(x) dbdead((x)) 751 EHANDLEFUNC dberrhandle(EHANDLEFUNC handler); 752 void dbexit(void); 753 RETCODE dbfcmd(DBPROCESS * dbproc, const char *fmt, ...); 754 DBINT dbfirstrow(DBPROCESS * dbproc); 755 756 #define DBFIRSTROW(x) dbfirstrow((x)) 757 void dbfreebuf(DBPROCESS * dbproc); 758 char *dbgetchar(DBPROCESS * dbprocess, int n); 759 char *dbgetcharset(DBPROCESS * dbprocess); 760 int dbgetlusername(LOGINREC * login, BYTE * name_buffer, int buffer_len); 761 int dbgetmaxprocs(void); 762 char *dbgetnatlanf(DBPROCESS * dbprocess); 763 int dbgetpacket(DBPROCESS * dbproc); 764 RETCODE dbgetrow(DBPROCESS * dbproc, DBINT row); 765 int dbgettime(void); 766 #define DBGETTIME dbgettime 767 BYTE *dbgetuserdata(DBPROCESS * dbproc); 768 DBBOOL dbhasretstat(DBPROCESS * dbproc); 769 RETCODE dbinit(void); 770 int dbiordesc(DBPROCESS * dbproc); 771 772 #define DBIORDESC(x) dbiordesc((x)) 773 int dbiowdesc(DBPROCESS * dbproc); 774 775 #define DBIOWDESC(x) dbiowdesc((x)) 776 DBBOOL dbisavail(DBPROCESS * dbprocess); 777 778 #define DBISAVAIL(x) dbisavail((x)) 779 DBBOOL dbisopt(DBPROCESS * dbproc, int option, const char param[]); 780 DBINT dblastrow(DBPROCESS * dbproc); 781 782 #define DBLASTROW(x) dblastrow((x)) 783 LOGINREC *dblogin(void); 784 void dbloginfree(LOGINREC * login); 785 786 int dbmny4cmp(DBPROCESS * dbproc, DBMONEY4 * m1, DBMONEY4 * m2); 787 int dbmnycmp(DBPROCESS * dbproc, DBMONEY * m1, DBMONEY * m2); 788 789 RETCODE dbmny4add(DBPROCESS * dbproc, DBMONEY4 * m1, DBMONEY4 * m2, DBMONEY4 * sum); 790 RETCODE dbmnydec(DBPROCESS * dbproc, DBMONEY * mnyptr); 791 RETCODE dbmnyinc(DBPROCESS * dbproc, DBMONEY * mnyptr); 792 RETCODE dbmnymaxpos(DBPROCESS * dbproc, DBMONEY * dest); 793 RETCODE dbmnymaxneg(DBPROCESS * dbproc, DBMONEY * dest); 794 RETCODE dbmny4minus(DBPROCESS * dbproc, DBMONEY4 * src, DBMONEY4 * dest); 795 RETCODE dbmnyminus(DBPROCESS * dbproc, DBMONEY * src, DBMONEY * dest); 796 RETCODE dbmny4sub(DBPROCESS * dbproc, DBMONEY4 * m1, DBMONEY4 * m2, DBMONEY4 * diff); 797 RETCODE dbmnysub(DBPROCESS * dbproc, DBMONEY * m1, DBMONEY * m2, DBMONEY * diff); 798 799 RETCODE dbmny4copy(DBPROCESS * dbprocess, DBMONEY4 * m1, DBMONEY4 * m2); 800 RETCODE dbmnycopy(DBPROCESS * dbproc, DBMONEY * src, DBMONEY * dest); 801 802 RETCODE dbmny4zero(DBPROCESS * dbproc, DBMONEY4 * dest); 803 RETCODE dbmnyzero(DBPROCESS * dbproc, DBMONEY * dest); 804 805 const char *dbmonthname(DBPROCESS * dbproc, char *language, int monthnum, DBBOOL shortform); 806 RETCODE dbmorecmds(DBPROCESS * dbproc); 807 808 #define DBMORECMDS(x) dbmorecmds((x)) 809 RETCODE dbmoretext(DBPROCESS * dbproc, DBINT size, const BYTE text[]); 810 MHANDLEFUNC dbmsghandle(MHANDLEFUNC handler); 811 char *dbname(DBPROCESS * dbproc); 812 STATUS dbnextrow(DBPROCESS * dbproc); 813 RETCODE dbnullbind(DBPROCESS * dbproc, int column, DBINT * indicator); 814 int dbnumalts(DBPROCESS * dbproc, int computeid); 815 int dbnumcols(DBPROCESS * dbproc); 816 int dbnumcompute(DBPROCESS * dbprocess); 817 int dbnumrets(DBPROCESS * dbproc); 818 DBPROCESS *tdsdbopen(LOGINREC * login, const char *server, int msdblib); 819 DBPROCESS *dbopen(LOGINREC * login, const char *server); 820 821 /* pivot functions */ 822 struct col_t; 823 void dbpivot_count (struct col_t *output, const struct col_t *input); 824 void dbpivot_sum (struct col_t *output, const struct col_t *input); 825 void dbpivot_min (struct col_t *output, const struct col_t *input); 826 void dbpivot_max (struct col_t *output, const struct col_t *input); 827 828 struct pivot_t; 829 typedef void (*DBPIVOT_FUNC)(struct col_t *output, const struct col_t *input); 830 struct pivot_t * dbrows_pivoted(DBPROCESS *dbproc); 831 STATUS dbnextrow_pivoted(DBPROCESS *dbproc, struct pivot_t *pp); 832 RETCODE dbpivot(DBPROCESS *dbproc, int nkeys, int *keys, int ncols, int *cols, DBPIVOT_FUNC func, int val); 833 834 DBPIVOT_FUNC dbpivot_lookup_name( const char name[] ); 835 836 #ifdef MSDBLIB 837 #define dbopen(x,y) tdsdbopen((x),(y), 1) 838 #else 839 #define dbopen(x,y) tdsdbopen((x),(y), 0) 840 #endif 841 842 /* fix PHP problem */ 843 #ifdef PHP_SYBASE_DBOPEN 844 #undef PHP_SYBASE_DBOPEN 845 #define PHP_SYBASE_DBOPEN dbopen 846 #endif 847 848 void dbprhead(DBPROCESS * dbproc); 849 DBINT dbprcollen(DBPROCESS * dbproc, int column); 850 RETCODE dbprrow(DBPROCESS * dbproc); 851 const char *dbprtype(int token); 852 DBBOOL DRBUF(DBPROCESS * dbprocess); 853 STATUS dbreadtext(DBPROCESS * dbproc, void *buf, DBINT bufsize); 854 void dbrecftos(const char filename[]); 855 RETCODE dbresults(DBPROCESS * dbproc); 856 RETCODE dbresults_r(DBPROCESS * dbproc, int recursive); 857 BYTE *dbretdata(DBPROCESS * dbproc, int retnum); 858 int dbretlen(DBPROCESS * dbproc, int retnum); 859 char *dbretname(DBPROCESS * dbproc, int retnum); 860 DBINT dbretstatus(DBPROCESS * dbproc); 861 int dbrettype(DBPROCESS * dbproc, int retnum); 862 RETCODE dbrows(DBPROCESS * dbproc); 863 864 #define DBROWS(x) dbrows((x)) 865 STATUS dbrowtype(DBPROCESS * dbprocess); 866 867 #define DBROWTYPE(x) dbrowtype((x)) 868 RETCODE dbrpcinit(DBPROCESS * dbproc, const char rpcname[], DBSMALLINT options); 869 RETCODE dbrpcparam(DBPROCESS * dbproc, const char paramname[], BYTE status, int type, DBINT maxlen, DBINT datalen, BYTE * value); 870 RETCODE dbrpcsend(DBPROCESS * dbproc); 871 RETCODE dbsafestr(DBPROCESS * dbproc, const char *src, DBINT srclen, char *dest, DBINT destlen, int quotetype); 872 RETCODE *dbsechandle(DBINT type, INTFUNCPTR handler); 873 char *dbservcharset(DBPROCESS * dbprocess); 874 void dbsetavail(DBPROCESS * dbprocess); 875 void dbsetbusy(DBPROCESS * dbprocess, DB_DBBUSY_FUNC busyfunc); 876 RETCODE dbsetdefcharset(char *charset); 877 void dbsetidle(DBPROCESS * dbprocess, DB_DBIDLE_FUNC idlefunc); 878 void dbsetifile(char *filename); 879 void dbsetinterrupt(DBPROCESS * dbproc, DB_DBCHKINTR_FUNC chkintr, DB_DBHNDLINTR_FUNC hndlintr); 880 RETCODE dbsetlogintime(int seconds); 881 RETCODE dbsetmaxprocs(int maxprocs); 882 RETCODE dbsetnull(DBPROCESS * dbprocess, int bindtype, int bindlen, BYTE * bindval); 883 RETCODE dbsetopt(DBPROCESS * dbproc, int option, const char *char_param, int int_param); 884 STATUS dbsetrow(DBPROCESS * dbprocess, DBINT row); 885 RETCODE dbsettime(int seconds); 886 void dbsetuserdata(DBPROCESS * dbproc, BYTE * ptr); 887 RETCODE dbsetversion(DBINT version); 888 889 int dbspid(DBPROCESS * dbproc); 890 RETCODE dbspr1row(DBPROCESS * dbproc, char *buffer, DBINT buf_len); 891 DBINT dbspr1rowlen(DBPROCESS * dbproc); 892 RETCODE dbsprhead(DBPROCESS * dbproc, char *buffer, DBINT buf_len); 893 RETCODE dbsprline(DBPROCESS * dbproc, char *buffer, DBINT buf_len, DBCHAR line_char); 894 RETCODE dbsqlexec(DBPROCESS * dbproc); 895 RETCODE dbsqlok(DBPROCESS * dbproc); 896 RETCODE dbsqlsend(DBPROCESS * dbproc); 897 int dbstrbuild(DBPROCESS * dbproc, char *charbuf, int bufsize, char *text, char *formats, ...); 898 RETCODE dbstrcpy(DBPROCESS * dbproc, int start, int numbytes, char *dest); 899 int dbstrlen(DBPROCESS * dbproc); 900 DBINT dbvarylen(DBPROCESS * dbproc, int column); 901 902 #define SYBEVERDOWN 100 /* TDS version downgraded . */ 903 #define SYBEICONVIU 2400 /* Some character(s) could not be converted into client's character set. */ 904 #define SYBEICONVAVAIL 2401 /* Character set conversion is not available between client character set '%.*s' and server character set '%.*s'.*/ 905 #define SYBEICONVO 2402 /* Error converting characters into server's character set. Some character(s) could not be converted.*/ 906 #define SYBEICONVI 2403 /* Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?').*/ 907 #define SYBEICONV2BIG 2404 /* Buffer overflow converting characters from client into server's character set.*/ 908 /* cf. doc/dblib_errors.txt for more iconv error values. */ 909 /* Reserve a few slots for other iconv-related issues. */ 910 #define SYBETDSVER 2410 /* Cannot bcp with TDSVER < 5.0 */ 911 #define SYBEPORT 2500 /* Both port and instance specified */ 912 #define SYBESYNC 20001 /* Read attempted while out of synchronization with SQL Server. */ 913 #define SYBEFCON 20002 /* SQL Server connection failed. */ 914 #define SYBETIME 20003 /* SQL Server connection timed out. */ 915 #define SYBEREAD 20004 /* Read from SQL Server failed. */ 916 #define SYBEBUFL 20005 /* DB-LIBRARY internal error - send buffer length corrupted. */ 917 #define SYBEWRIT 20006 /* Write to SQL Server failed. */ 918 #define SYBEVMS 20007 /* Sendflush: VMS I/O error. */ 919 #define SYBESOCK 20008 /* Unable to open socket */ 920 #define SYBECONN 20009 /* Unable to connect socket -- SQL Server is unavailable or does not exist. */ 921 #define SYBEMEM 20010 /* Unable to allocate sufficient memory */ 922 #define SYBEDBPS 20011 /* Maximum number of DBPROCESSes already allocated. */ 923 #define SYBEINTF 20012 /* Server name not found in interface file */ 924 #define SYBEUHST 20013 /* Unknown host machine name */ 925 #define SYBEPWD 20014 /* Incorrect password. */ 926 #define SYBEOPIN 20015 /* Could not open interface file. */ 927 #define SYBEINLN 20016 /* Interface file: unexpected end-of-line. */ 928 #define SYBESEOF 20017 /* Unexpected EOF from SQL Server. */ 929 #define SYBESMSG 20018 /* General SQL Server error: Check messages from the SQL Server. */ 930 #define SYBERPND 20019 /* Attempt to initiate a new SQL Server operation with results pending. */ 931 #define SYBEBTOK 20020 /* Bad token from SQL Server: Data-stream processing out of sync. */ 932 #define SYBEITIM 20021 /* Illegal timeout value specified. */ 933 #define SYBEOOB 20022 /* Error in sending out-of-band data to SQL Server. */ 934 #define SYBEBTYP 20023 /* Unknown bind type passed to DB-LIBRARY function. */ 935 #define SYBEBNCR 20024 /* Attempt to bind user variable to a non-existent compute row. */ 936 #define SYBEIICL 20025 /* Illegal integer column length returned by SQL Server. Legal integer lengths are 1, 2, and 4 bytes. */ 937 #define SYBECNOR 20026 /* Column number out of range. */ 938 #define SYBENPRM 20027 /* NULL parameter not allowed for this dboption. */ 939 #define SYBEUVDT 20028 /* Unknown variable-length datatype encountered. */ 940 #define SYBEUFDT 20029 /* Unknown fixed-length datatype encountered. */ 941 #define SYBEWAID 20030 /* DB-LIBRARY internal error: ALTFMT following ALTNAME has wrong id. */ 942 #define SYBECDNS 20031 /* Datastream indicates that a compute column is derived from a non-existent select-list member. */ 943 #define SYBEABNC 20032 /* Attempt to bind to a non-existent column. */ 944 #define SYBEABMT 20033 /* User attempted a dbbind() with mismatched column and variable types. */ 945 #define SYBEABNP 20034 /* Attempt to bind using NULL pointers. */ 946 #define SYBEAAMT 20035 /* User attempted a dbaltbind() with mismatched column and variable types. */ 947 #define SYBENXID 20036 /* The Server did not grant us a distributed-transaction ID. */ 948 #define SYBERXID 20037 /* The Server did not recognize our distributed-transaction ID. */ 949 #define SYBEICN 20038 /* Invalid computeid or compute column number. */ 950 #define SYBENMOB 20039 /* No such member of 'order by' clause. */ 951 #define SYBEAPUT 20040 /* Attempt to print unknown token. */ 952 #define SYBEASNL 20041 /* Attempt to set fields in a null loginrec. */ 953 #define SYBENTLL 20042 /* Name too long for loginrec field. */ 954 #define SYBEASUL 20043 /* Attempt to set unknown loginrec field. */ 955 #define SYBERDNR 20044 /* Attempt to retrieve data from a non-existent row. */ 956 #define SYBENSIP 20045 /* Negative starting index passed to dbstrcpy(). */ 957 #define SYBEABNV 20046 /* Attempt to bind to a NULL program variable. */ 958 #define SYBEDDNE 20047 /* DBPROCESS is dead or not enabled. */ 959 #define SYBECUFL 20048 /* Data-conversion resulted in underflow. */ 960 #define SYBECOFL 20049 /* Data-conversion resulted in overflow. */ 961 #define SYBECSYN 20050 /* Attempt to convert data stopped by syntax error in source field. */ 962 #define SYBECLPR 20051 /* Data-conversion resulted in loss of precision. */ 963 #define SYBECNOV 20052 /* Attempt to set variable to NULL resulted in overflow. */ 964 #define SYBERDCN 20053 /* Requested data-conversion does not exist. */ 965 #define SYBESFOV 20054 /* dbsafestr() overflowed its destination buffer. */ 966 #define SYBEUNT 20055 /* Unknown network type found in interface file. */ 967 #define SYBECLOS 20056 /* Error in closing network connection. */ 968 #define SYBEUAVE 20057 /* Unable to allocate VMS event flag. */ 969 #define SYBEUSCT 20058 /* Unable to set communications timer. */ 970 #define SYBEEQVA 20059 /* Error in queueing VMS AST routine. */ 971 #define SYBEUDTY 20060 /* Unknown datatype encountered. */ 972 #define SYBETSIT 20061 /* Attempt to call dbtsput() with an invalid timestamp. */ 973 #define SYBEAUTN 20062 /* Attempt to update the timestamp of a table which has no timestamp column. */ 974 #define SYBEBDIO 20063 /* Bad bulk-copy direction. Must be either IN or OUT. */ 975 #define SYBEBCNT 20064 /* Attempt to use Bulk Copy with a non-existent Server table. */ 976 #define SYBEIFNB 20065 /* Illegal field number passed to bcp_control(). */ 977 #define SYBETTS 20066 /* The table which bulk-copy is attempting to copy to a host-file is shorter than the number of rows which bulk-copy was instructed to skip. */ 978 #define SYBEKBCO 20067 /* 1000 rows successfully bulk-copied to host-file. */ 979 #define SYBEBBCI 20068 /* Batch successfully bulk-copied to SQL Server. */ 980 #define SYBEKBCI 20069 /* Bcp: 1000 rows sent to SQL Server. */ 981 #define SYBEBCRE 20070 /* I/O error while reading bcp data-file. */ 982 #define SYBETPTN 20071 /* Syntax error: only two periods are permitted in table names. */ 983 #define SYBEBCWE 20072 /* I/O error while writing bcp data-file. */ 984 #define SYBEBCNN 20073 /* Attempt to bulk-copy a NULL value into Server column %d, which does not accept NULL values. */ 985 #define SYBEBCOR 20074 /* Attempt to bulk-copy an oversized row to the SQL Server. */ 986 #define SYBEBCIS 20075 /* Attempt to bulk-copy an illegally-sized column value to the SQL Server. */ 987 #define SYBEBCPI 20076 /* bcp_init() must be called before any other bcp routines. */ 988 #define SYBEBCPN 20077 /* bcp_bind(), bcp_collen(), bcp_colptr(), bcp_moretext() and bcp_sendrow() may be used only after bcp_init() has been called with the copy direction set to DB_IN. */ 989 #define SYBEBCPB 20078 /* bcp_bind(), bcp_moretext() and bcp_sendrow() may NOT be used after bcp_init() has been passed a non-NULL input file name. */ 990 #define SYBEVDPT 20079 /* For bulk copy, all variable-length data must have either a length-prefix or a terminator specified. */ 991 #define SYBEBIVI 20080 /* bcp_columns(), bcp_colfmt() and bcp_colfmt_ps() may be used only after bcp_init() has been passed a valid input file. */ 992 #define SYBEBCBC 20081 /* bcp_columns() must be called before bcp_colfmt() and bcp_colfmt_ps(). */ 993 #define SYBEBCFO 20082 /* Bcp host-files must contain at least one column. */ 994 #define SYBEBCVH 20083 /* bcp_exec() may be called only after bcp_init() has been passed a valid host file. */ 995 #define SYBEBCUO 20084 /* Bcp: Unable to open host data-file. */ 996 #define SYBEBCUC 20085 /* Bcp: Unable to close host data-file. */ 997 #define SYBEBUOE 20086 /* Bcp: Unable to open error-file. */ 998 #define SYBEBUCE 20087 /* Bcp: Unable to close error-file. */ 999 #define SYBEBWEF 20088 /* I/O error while writing bcp error-file. */ 1000 #define SYBEASTF 20089 /* VMS: Unable to setmode for control_c ast. */ 1001 #define SYBEUACS 20090 /* VMS: Unable to assign channel to sys$command. */ 1002 #define SYBEASEC 20091 /* Attempt to send an empty command buffer to the SQL Server. */ 1003 #define SYBETMTD 20092 /* Attempt to send too much TEXT data via the dbmoretext() call. */ 1004 #define SYBENTTN 20093 /* Attempt to use dbtxtsput() to put a new text-timestamp into a non-existent data row. */ 1005 #define SYBEDNTI 20094 /* Attempt to use dbtxtsput() to put a new text-timestamp into a column whose datatype is neither SYBTEXT nor SYBIMAGE. */ 1006 #define SYBEBTMT 20095 /* Attempt to send too much TEXT data via the bcp_moretext() call. */ 1007 #define SYBEORPF 20096 /* Attempt to set remote password would overflow the login-record's remote-password field. */ 1008 #define SYBEUVBF 20097 /* Attempt to read an unknown version of BCP format-file. */ 1009 #define SYBEBUOF 20098 /* Bcp: Unable to open format-file. */ 1010 #define SYBEBUCF 20099 /* Bcp: Unable to close format-file. */ 1011 #define SYBEBRFF 20100 /* I/O error while reading bcp format-file. */ 1012 #define SYBEBWFF 20101 /* I/O error while writing bcp format-file. */ 1013 #define SYBEBUDF 20102 /* Bcp: Unrecognized datatype found in format-file. */ 1014 #define SYBEBIHC 20103 /* Incorrect host-column number found in bcp format-file. */ 1015 #define SYBEBEOF 20104 /* Unexpected EOF encountered in BCP data-file. */ 1016 #define SYBEBCNL 20105 /* Negative length-prefix found in BCP data-file. */ 1017 #define SYBEBCSI 20106 /* Host-file columns may be skipped only when copying INto the Server. */ 1018 #define SYBEBCIT 20107 /* It's illegal to use BCP terminators with program variables other than SYBCHAR, SYBBINARY, SYBTEXT, or SYBIMAGE. */ 1019 #define SYBEBCSA 20108 /* The BCP hostfile '%s' contains only %ld rows. Skipping all of these rows is not allowed. */ 1020 #define SYBENULL 20109 /* NULL DBPROCESS pointer passed to DB-Library. */ 1021 #define SYBEUNAM 20110 /* Unable to get current username from operating system. */ 1022 #define SYBEBCRO 20111 /* The BCP hostfile '%s' contains only %ld rows. It was impossible to read the requested %ld rows. */ 1023 #define SYBEMPLL 20112 /* Attempt to set maximum number of DBPROCESSes lower than 1. */ 1024 #define SYBERPIL 20113 /* It is illegal to pass -1 to dbrpcparam() for the datalen of parameters which are of type SYBCHAR, SYBVARCHAR, SYBBINARY, or SYBVARBINARY. */ 1025 #define SYBERPUL 20114 /* When passing a SYBINTN, SYBDATETIMN, SYBMONEYN, or SYBFLTN parameter via dbrpcparam(), it's necessary to specify the parameter's maximum or actual length, so that DB-Library can recognize it as a SYBINT1, SYBINT2, SYBINT4, SYBMONEY, or SYBMONEY4, etc. */ 1026 #define SYBEUNOP 20115 /* Unknown option passed to dbsetopt(). */ 1027 #define SYBECRNC 20116 /* The current row is not a result of compute clause %d, so it is illegal to attempt to extract that data from this row. */ 1028 #define SYBERTCC 20117 /* dbreadtext() may not be used to receive the results of a query which contains a COMPUTE clause. */ 1029 #define SYBERTSC 20118 /* dbreadtext() may only be used to receive the results of a query which contains a single result column. */ 1030 #define SYBEUCRR 20119 /* Internal software error: Unknown connection result reported by * dbpasswd(). */ 1031 #define SYBERPNA 20120 /* The RPC facility is available only when using a SQL Server whose version number is 4.0 or greater. */ 1032 #define SYBEOPNA 20121 /* The text/image facility is available only when using a SQL Server whose version number is 4.0 or greater. */ 1033 #define SYBEFGTL 20122 /* Bcp: Row number of the first row to be copied cannot be greater than the row number for the last row to be copied. */ 1034 #define SYBECWLL 20123 /* Attempt to set column width less than 1. */ 1035 #define SYBEUFDS 20124 /* Unrecognized format encountered in dbstrbuild(). */ 1036 #define SYBEUCPT 20125 /* Unrecognized custom-format parameter-type encountered in dbstrbuild(). */ 1037 #define SYBETMCF 20126 /* Attempt to install too many custom formats via dbfmtinstall(). */ 1038 #define SYBEAICF 20127 /* Error in attempting to install custom format. */ 1039 #define SYBEADST 20128 /* Error in attempting to determine the size of a pair of translation tables. */ 1040 #define SYBEALTT 20129 /* Error in attempting to load a pair of translation tables. */ 1041 #define SYBEAPCT 20130 /* Error in attempting to perform a character-set translation. */ 1042 #define SYBEXOCI 20131 /* A character-set translation overflowed its destination buffer while using bcp to copy data from a host-file to the SQL Server. */ 1043 #define SYBEFSHD 20132 /* Error in attempting to find the Sybase home directory. */ 1044 #define SYBEAOLF 20133 /* Error in attempting to open a localization file. */ 1045 #define SYBEARDI 20134 /* Error in attempting to read datetime information from a localization file. */ 1046 #define SYBEURCI 20135 /* Unable to read copyright information from the dblib localization file. */ 1047 #define SYBEARDL 20136 /* Error in attempting to read the dblib.loc localization file. */ 1048 #define SYBEURMI 20137 /* Unable to read money-format information from the dblib localization file. */ 1049 #define SYBEUREM 20138 /* Unable to read error mnemonic from the dblib localization file. */ 1050 #define SYBEURES 20139 /* Unable to read error string from the dblib localization file. */ 1051 #define SYBEUREI 20140 /* Unable to read error information from the dblib localization file. */ 1052 #define SYBEOREN 20141 /* Warning: an out-of-range error-number was encountered in dblib.loc. The maximum permissible error-number is defined as DBERRCOUNT in sybdb.h. */ 1053 #define SYBEISOI 20142 /* Invalid sort-order information found. */ 1054 #define SYBEIDCL 20143 /* Illegal datetime column length returned by DataServer. Legal datetime lengths are 4 and 8 bytes. */ 1055 #define SYBEIMCL 20144 /* Illegal money column length returned by DataServer. Legal money lengths are 4 and 8 bytes. */ 1056 #define SYBEIFCL 20145 /* Illegal floating-point column length returned by DataServer. Legal floating-point lengths are 4 and 8 bytes. */ 1057 #define SYBEUTDS 20146 /* Unrecognized TDS version received from SQL Server. */ 1058 #define SYBEBUFF 20147 /* Bcp: Unable to create format-file. */ 1059 #define SYBEACNV 20148 /* Attemp to do conversion with NULL destination variable. */ 1060 #define SYBEDPOR 20149 /* Out-of-range datepart constant. */ 1061 #define SYBENDC 20150 /* Cannot have negative component in date in numeric form. */ 1062 #define SYBEMVOR 20151 /* Month values must be between 1 and 12. */ 1063 #define SYBEDVOR 20152 /* Day values must be between 1 and 7. */ 1064 #define SYBENBVP 20153 /* Cannot pass dbsetnull() a NULL bindval pointer. */ 1065 #define SYBESPID 20154 /* Called dbspid() with a NULL dbproc. */ 1066 #define SYBENDTP 20155 /* Called dbdatecrack() with a NULL datetime parameter. */ 1067 #define SYBEXTN 20156 /* The xlt_todisp and xlt_tosrv parameters to dbfree_xlate() were NULL. */ 1068 #define SYBEXTDN 20157 /* Warning: the xlt_todisp parameter to dbfree_xlate() was NULL. The space associated with the xlt_tosrv parameter has been freed. */ 1069 #define SYBEXTSN 20158 /* Warning: the xlt_tosrv parameter to dbfree_xlate() was NULL. The space associated with the xlt_todisp parameter has been freed. */ 1070 #define SYBENUM 20159 /* Incorrect number of arguments given to DB-Library. */ 1071 #define SYBETYPE 20160 /* Invalid argument type given to DB-Library. */ 1072 #define SYBEGENOS 20161 /* General Operating System Error. */ 1073 #define SYBEPAGE 20162 /* wrong resource type or length given for dbpage() operation. */ 1074 #define SYBEOPTNO 20163 /* Option is not allowed or is unreconized */ 1075 #define SYBEETD 20164 /* Failure to send the expected amount of TEXT or IMAGE data via dbmoretext(). */ 1076 #define SYBERTYPE 20165 /* Invalid resource type given to DB-Library. */ 1077 #define SYBERFILE 20166 /* "Can not open resource file." */ 1078 #define SYBEFMODE 20167 /* Read/Write/Append mode denied on file. */ 1079 #define SYBESLCT 20168 /* Could not select or copy field specified */ 1080 #define SYBEZTXT 20169 /* Attempt to send zero length TEXT or IMAGE to dataserver via dbwritetext(). */ 1081 #define SYBENTST 20170 /* The file being opened must be a stream_lf. */ 1082 #define SYBEOSSL 20171 /* Operating system login level not in range of Secure SQL Server */ 1083 #define SYBEESSL 20172 /* Login security level entered does not agree with operating system level */ 1084 #define SYBENLNL 20173 /* Program not linked with specified network library. */ 1085 #define SYBENHAN 20174 /* called dbrecvpassthru() with a NULL handler parameter. */ 1086 #define SYBENBUF 20175 /* called dbsendpassthru() with a NULL buf pointer. */ 1087 #define SYBENULP 20176 /* Called %s with a NULL %s parameter. */ 1088 #define SYBENOTI 20177 /* No event handler installed. */ 1089 #define SYBEEVOP 20178 /* Called dbregwatch() with a bad options parameter. */ 1090 #define SYBENEHA 20179 /* Called dbreghandle() with a NULL handler parameter. */ 1091 #define SYBETRAN 20180 /* DBPROCESS is being used for another transaction. */ 1092 #define SYBEEVST 20181 /* Must initiate a transaction before calling dbregparam(). */ 1093 #define SYBEEINI 20182 /* Must call dbreginit() before dbregraise(). */ 1094 #define SYBEECRT 20183 /* Must call dbregdefine() before dbregcreate(). */ 1095 #define SYBEECAN 20184 /* Attempted to cancel unrequested event notification. */ 1096 #define SYBEEUNR 20185 /* Unsolicited event notification received. */ 1097 #define SYBERPCS 20186 /* Must call dbrpcinit() before dbrpcparam(). */ 1098 #define SYBETPAR 20187 /* No SYBTEXT or SYBIMAGE parameters were defined. */ 1099 #define SYBETEXS 20188 /* Called dbmoretext() with a bad size parameter. */ 1100 #define SYBETRAC 20189 /* Attempted to turn off a trace flag that was not on. */ 1101 #define SYBETRAS 20190 /* DB-Library internal error - trace structure not found. */ 1102 #define SYBEPRTF 20191 /* dbtracestring() may only be called from a printfunc(). */ 1103 #define SYBETRSN 20192 /* Bad numbytes parameter passed to dbtracestring(). */ 1104 #define SYBEBPKS 20193 /* In DBSETLPACKET(), the packet size parameter must be between 0 and 999999. */ 1105 #define SYBEIPV 20194 /* %1! is an illegal value for the %2! parameter of %3!. */ 1106 #define SYBEMOV 20195 /* Money arithmetic resulted in overflow in function %1!. */ 1107 #define SYBEDIVZ 20196 /* Attempt to divide by $0.00 in function %1!. */ 1108 #define SYBEASTL 20197 /* Synchronous I/O attempted at AST level. */ 1109 #define SYBESEFA 20198 /* DBSETNOTIFS cannot be called if connections are present. */ 1110 #define SYBEPOLL 20199 /* Only one dbpoll() can be active at a time. */ 1111 #define SYBENOEV 20200 /* dbpoll() cannot be called if registered procedure notifications have been disabled. */ 1112 #define SYBEBADPK 20201 /* Packet size of %1! not supported. -- size of %2! used instead. */ 1113 #define SYBESECURE 20202 /* Secure Server function not supported in this version. */ 1114 #define SYBECAP 20203 /* DB-Library capabilities not accepted by the Server. */ 1115 #define SYBEFUNC 20204 /* Functionality not supported at the specified version level. */ 1116 #define SYBERESP 20205 /* Response function address passed to dbresponse() must be non-NULL. */ 1117 #define SYBEIVERS 20206 /* Illegal version level specified. */ 1118 #define SYBEONCE 20207 /* Function can be called only once. */ 1119 #define SYBERPNULL 20208 /* value parameter for dbprcparam() can be NULL, only if the datalen parameter is 0 */ 1120 #define SYBERPTXTIM 20209 /* RPC parameters cannot be of type Text/Image. */ 1121 #define SYBENEG 20210 /* Negotiated login attempt failed. */ 1122 #define SYBELBLEN 20211 /* Security labels should be less than 256 characters long. */ 1123 #define SYBEUMSG 20212 /* Unknown message-id in MSG datastream. */ 1124 #define SYBECAPTYP 20213 /* Unexpected capability type in CAPABILITY datastream. */ 1125 #define SYBEBNUM 20214 /* Bad numbytes parameter passed to dbstrcpy() */ 1126 #define SYBEBBL 20215 /* Bad bindlen parameter passed to dbsetnull() */ 1127 #define SYBEBPREC 20216 /* Illegal precision specified */ 1128 #define SYBEBSCALE 20217 /* Illegal scale specified */ 1129 #define SYBECDOMAIN 20218 /* Source field value is not within the domain of legal values. */ 1130 #define SYBECINTERNAL 20219 /* Internal Conversion error. */ 1131 #define SYBEBTYPSRV 20220 /* Datatype is not supported by the server. */ 1132 #define SYBEBCSET 20221 /* Unknown character-set encountered." */ 1133 #define SYBEFENC 20222 /* Password Encryption failed." */ 1134 #define SYBEFRES 20223 /* Challenge-Response function failed.", */ 1135 #define SYBEISRVPREC 20224 /* Illegal precision value returned by the server. */ 1136 #define SYBEISRVSCL 20225 /* Illegal scale value returned by the server. */ 1137 #define SYBEINUMCL 20226 /* Invalid numeric column length returned by the server. */ 1138 #define SYBEIDECCL 20227 /* Invalid decimal column length returned by the server. */ 1139 #define SYBEBCMTXT 20228 /* bcp_moretext() may be used only when there is at least one text or image column in the server table. */ 1140 #define SYBEBCPREC 20229 /* Column %1!: Illegal precision value encountered. */ 1141 #define SYBEBCBNPR 20230 /* bcp_bind(): if varaddr is NULL, prefixlen must be 0 and no terminator should be specified. */ 1142 #define SYBEBCBNTYP 20231 /* bcp_bind(): if varaddr is NULL and varlen greater than 0, the table column type must be SYBTEXT or SYBIMAGE and the program variable type must be SYBTEXT, SYBCHAR, SYBIMAGE or SYBBINARY. */ 1143 #define SYBEBCSNTYP 20232 /* column number %1!: if varaddr is NULL and varlen greater than 0, the table column type must be SYBTEXT or SYBIMAGE and the program variable type must be SYBTEXT, SYBCHAR, SYBIMAGE or SYBBINARY. */ 1144 #define SYBEBCPCTYP 20233 /* bcp_colfmt(): If table_colnum is 0, host_type cannot be 0. */ 1145 #define SYBEBCVLEN 20234 /* varlen should be greater than or equal to -1. */ 1146 #define SYBEBCHLEN 20235 /* host_collen should be greater than or equal to -1. */ 1147 #define SYBEBCBPREF 20236 /* Illegal prefix length. Legal values are 0, 1, 2 or 4. */ 1148 #define SYBEBCPREF 20237 /* Illegal prefix length. Legal values are -1, 0, 1, 2 or 4. */ 1149 #define SYBEBCITBNM 20238 /* bcp_init(): tblname parameter cannot be NULL. */ 1150 #define SYBEBCITBLEN 20239 /* bcp_init(): tblname parameter is too long. */ 1151 #define SYBEBCSNDROW 20240 /* bcp_sendrow() may NOT be called unless all text data for the previous row has been sent using bcp_moretext(). */ 1152 #define SYBEBPROCOL 20241 /* bcp protocol error: returned column count differs from the actual number of columns received. */ 1153 #define SYBEBPRODEF 20242 /* bcp protocol error: expected default information and got none. */ 1154 #define SYBEBPRONUMDEF 20243 /* bcp protocol error: expected number of defaults differs from the actual number of defaults received. */ 1155 #define SYBEBPRODEFID 20244 /* bcp protocol error: default column id and actual column id are not same */ 1156 #define SYBEBPRONODEF 20245 /* bcp protocol error: default value received for column that does not have default. */ 1157 #define SYBEBPRODEFTYP 20246 /* bcp protocol error: default value datatype differs from column datatype. */ 1158 #define SYBEBPROEXTDEF 20247 /* bcp protocol error: more than one row of default information received. */ 1159 #define SYBEBPROEXTRES 20248 /* bcp protocol error: unexpected set of results received. */ 1160 #define SYBEBPROBADDEF 20249 /* bcp protocol error: illegal default column id received. */ 1161 #define SYBEBPROBADTYP 20250 /* bcp protocol error: unknown column datatype. */ 1162 #define SYBEBPROBADLEN 20251 /* bcp protocol error: illegal datatype length received. */ 1163 #define SYBEBPROBADPREC 20252 /* bcp protocol error: illegal precision value received. */ 1164 #define SYBEBPROBADSCL 20253 /* bcp protocol error: illegal scale value received. */ 1165 #define SYBEBADTYPE 20254 /* Illegal value for type parameter given to %1!. */ 1166 #define SYBECRSNORES 20255 /* Cursor statement generated no results. */ 1167 #define SYBECRSNOIND 20256 /* One of the tables involved in the cursor statement does not have a unique index. */ 1168 #define SYBECRSVIEW 20257 /* A view cannot be joined with another table or a view in a cursor statement. */ 1169 #define SYBECRSVIIND 20258 /* The view used in the cursor statement does not include all the unique index columns of the underlying tables. */ 1170 #define SYBECRSORD 20259 /* Only fully keyset driven cursors can have 'order by', ' group by', or 'having' phrases. */ 1171 #define SYBECRSBUFR 20260 /* Row buffering should not be turned on when using cursor APIs. */ 1172 #define SYBECRSNOFREE 20261 /* The DBNOAUTOFREE option should not be turned on when using cursor APIs. */ 1173 #define SYBECRSDIS 20262 /* Cursor statement contains one of the disallowed phrases 'compute', 'union', 'for browse', or 'select into'. */ 1174 #define SYBECRSAGR 20263 /* Aggregate functions are not allowed in a cursor statement. */ 1175 #define SYBECRSFRAND 20264 /* Fetch types RANDOM and RELATIVE can only be used within the keyset of keyset driven cursors. */ 1176 #define SYBECRSFLAST 20265 /* Fetch type LAST requires fully keyset driven cursors. */ 1177 #define SYBECRSBROL 20266 /* Backward scrolling cannot be used in a forward scrolling cursor. */ 1178 #define SYBECRSFROWN 20267 /* Row number to be fetched is outside valid range. */ 1179 #define SYBECRSBSKEY 20268 /* Keyset cannot be scrolled backward in mixed cursors with a previous fetch type. */ 1180 #define SYBECRSRO 20269 /* Data locking or modifications cannot be made in a READONLY cursor. */ 1181 #define SYBECRSNOCOUNT 20270 /* The DBNOCOUNT option should not be turned on when doing updates or deletes with dbcursor(). */ 1182 #define SYBECRSTAB 20271 /* Table name must be determined in operations involving data locking or modifications. */ 1183 #define SYBECRSUPDNB 20272 /* Update or insert operations cannot use bind variables when binding type is NOBIND. */ 1184 #define SYBECRSNOWHERE 20273 /* A WHERE clause is not allowed in a cursor update or insert. */ 1185 #define SYBECRSSET 20274 /* A SET clause is required for a cursor update or insert. */ 1186 #define SYBECRSUPDTAB 20275 /* Update or insert operations using bind variables require single table cursors. */ 1187 #define SYBECRSNOUPD 20276 /* Update or delete operation did not affect any rows. */ 1188 #define SYBECRSINV 20277 /* Invalid cursor statement. */ 1189 #define SYBECRSNOKEYS 20278 /* The entire keyset must be defined for KEYSET cursors. */ 1190 #define SYBECRSNOBIND 20279 /* Cursor bind must be called prior to updating cursor */ 1191 #define SYBECRSFTYPE 20280 /* Unknown fetch type. */ 1192 #define SYBECRSINVALID 20281 /* The cursor handle is invalid. */ 1193 #define SYBECRSMROWS 20282 /* Multiple rows are returned, only one is expected. */ 1194 #define SYBECRSNROWS 20283 /* No rows returned, at least one is expected. */ 1195 #define SYBECRSNOLEN 20284 /* No unique index found. */ 1196 #define SYBECRSNOPTCC 20285 /* No OPTCC was found. */ 1197 #define SYBECRSNORDER 20286 /* The order of clauses must be from, where, and order by. */ 1198 #define SYBECRSNOTABLE 20287 /* Table name is NULL. */ 1199 #define SYBECRSNUNIQUE 20288 /* No unique keys associated with this view. */ 1200 #define SYBECRSVAR 20289 /* There is no valid address associated with this bind. */ 1201 #define SYBENOVALUE 20290 /* Security labels require both a name and a value */ 1202 #define SYBEVOIDRET 20291 /* Parameter of type SYBVOID cannot be a return parameter. */ 1203 #define SYBECLOSEIN 20292 /* Unable to close interface file. */ 1204 #define SYBEBOOL 20293 /* Boolean parameters must be TRUE or FALSE. */ 1205 #define SYBEBCPOPT 20294 /* The option cannot be called while a bulk copy operation is progress. */ 1206 #define SYBEERRLABEL 20295 /* An illegal value was returned from the security label handler. */ 1207 #define SYBEATTNACK 20296 /* Timed out waiting for server to acknowledge attention." */ 1208 #define SYBEBBFL 20297 /* -001- Batch failed in bulk-copy to SQL Server */ 1209 #define SYBEDCL 20298 /* -004- DCL Error */ 1210 #define SYBECS 20299 /* -004- cs context Error */ 1211 #define SYBEBULKINSERT 20599 /* cannot build bulk insert statement */ 1212 #define SYBECOLSIZE 22000 /* Invalid column information structure size */ 1213 1214 int dbtds(DBPROCESS * dbprocess); 1215 1216 #define DBTDS(a) dbtds(a) 1217 DBINT dbtextsize(DBPROCESS * dbprocess); 1218 DBBINARY *dbtxptr(DBPROCESS * dbproc, int column); 1219 DBBINARY *dbtxtimestamp(DBPROCESS * dbproc, int column); 1220 DBBINARY *dbtxtsnewval(DBPROCESS * dbprocess); 1221 RETCODE dbtxtsput(DBPROCESS * dbprocess, DBBINARY newtxts, int colnum); 1222 RETCODE dbuse(DBPROCESS * dbproc, const char *name); 1223 const char *dbversion(void); 1224 DBBOOL dbwillconvert(int srctype, int desttype); 1225 RETCODE dbwritetext(DBPROCESS * dbproc, char *objname, DBBINARY * textptr, DBTINYINT textptrlen, DBBINARY * timestamp, 1226 DBBOOL log, DBINT size, BYTE * text); 1227 1228 /* LOGINREC manipulation */ 1229 RETCODE dbsetlname(LOGINREC * login, const char *value, int which); 1230 RETCODE dbsetlbool(LOGINREC * login, int value, int which); 1231 RETCODE dbsetllong(LOGINREC * login, long value, int which); 1232 RETCODE dbsetlversion (LOGINREC * login, BYTE version); 1233 1234 #define DBSETHOST 1 1235 #define DBSETLHOST(x,y) dbsetlname((x), (y), DBSETHOST) 1236 #define dbsetlhost(x,y) dbsetlname((x), (y), DBSETHOST) 1237 #define DBSETUSER 2 1238 #define DBSETLUSER(x,y) dbsetlname((x), (y), DBSETUSER) 1239 #define dbsetluser(x,y) dbsetlname((x), (y), DBSETUSER) 1240 #define DBSETPWD 3 1241 #define DBSETLPWD(x,y) dbsetlname((x), (y), DBSETPWD) 1242 #define dbsetlpwd(x,y) dbsetlname((x), (y), DBSETPWD) 1243 #if defined(DBLIB_UNIMPLEMENTED) 1244 # define DBSETHID 4 /* not implemented */ 1245 # define DBSETLHID(x,y) dbsetlname((x), (y), DBSETHID) 1246 #endif 1247 #define DBSETAPP 5 1248 #define DBSETLAPP(x,y) dbsetlname((x), (y), DBSETAPP) 1249 #define dbsetlapp(x,y) dbsetlname((x), (y), DBSETAPP) 1250 #define DBSETBCP 6 1251 #define BCP_SETL(x,y) dbsetlbool((x), (y), DBSETBCP) 1252 #define DBSETLSECURE(x) dbsetlbool((x), (1), DBSETBCP) 1253 #define DBSETNATLANG 7 1254 #define DBSETLNATLANG(x,y) dbsetlname((x), (y), DBSETNATLANG) 1255 #define dbsetlnatlang(x,y) dbsetlname((x), (y), DBSETNATLANG) 1256 #if defined(DBLIB_UNIMPLEMENTED) 1257 # define DBSETNOSHORT 8 /* not implemented */ 1258 # define DBSETLNOSHORT(x,y) dbsetlbool((x), (y), DBSETNOSHORT) 1259 # define DBSETHIER 9 /* not implemented */ 1260 # define DBSETLHIER(x,y) dbsetlshort((x), (y), DBSETHIER) 1261 #endif 1262 #define DBSETCHARSET 10 1263 #define DBSETLCHARSET(x,y) dbsetlname((x), (y), DBSETCHARSET) 1264 #define DBSETPACKET 11 1265 #define DBSETLPACKET(x,y) dbsetllong((x), (y), DBSETPACKET) 1266 #define dbsetlpacket(x,y) dbsetllong((x), (y), DBSETPACKET) 1267 #define DBSETENCRYPT 12 1268 #define DBSETLENCRYPT(x,y) dbsetlbool((x), (y), DBSETENCRYPT) 1269 #define DBSETLABELED 13 1270 #define DBSETLLABELED(x,y) dbsetlbool((x), (y), DBSETLABELED) 1271 #define BCP_SETLABELED(x,y) dbsetlbool((x), (y), DBSETLABELED) 1272 #define DBSETDBNAME 14 1273 #define DBSETLDBNAME(x,y) dbsetlname((x), (y), DBSETDBNAME) 1274 #define DBSETLVERSION(login, version) dbsetlversion((login), (version)) 1275 1276 RETCODE bcp_init(DBPROCESS * dbproc, const char *tblname, const char *hfile, const char *errfile, int direction); 1277 DBINT bcp_done(DBPROCESS * dbproc); 1278 1279 DBINT bcp_batch(DBPROCESS * dbproc); 1280 RETCODE bcp_bind(DBPROCESS * dbproc, BYTE * varaddr, int prefixlen, DBINT varlen, BYTE * terminator, int termlen, int type, 1281 int table_column); 1282 RETCODE bcp_collen(DBPROCESS * dbproc, DBINT varlen, int table_column); 1283 RETCODE bcp_columns(DBPROCESS * dbproc, int host_colcount); 1284 RETCODE bcp_colfmt(DBPROCESS * dbproc, int host_column, int host_type, int host_prefixlen, DBINT host_collen, 1285 const BYTE * host_term, int host_termlen, int colnum); 1286 RETCODE bcp_colfmt_ps(DBPROCESS * dbproc, int host_column, int host_type, int host_prefixlen, DBINT host_collen, 1287 BYTE * host_term, int host_termlen, int colnum, DBTYPEINFO * typeinfo); 1288 RETCODE bcp_colptr(DBPROCESS * dbproc, BYTE * colptr, int table_column); 1289 RETCODE bcp_control(DBPROCESS * dbproc, int field, DBINT value); 1290 int bcp_getbatchsize(DBPROCESS * dbproc); /* FreeTDS only */ 1291 RETCODE bcp_exec(DBPROCESS * dbproc, DBINT * rows_copied); 1292 DBBOOL bcp_getl(LOGINREC * login); 1293 RETCODE bcp_options(DBPROCESS * dbproc, int option, BYTE * value, int valuelen); 1294 RETCODE bcp_readfmt(DBPROCESS * dbproc, const char filename[]); 1295 RETCODE bcp_sendrow(DBPROCESS * dbproc); 1296 1297 #ifdef __cplusplus 1298 #if 0 1299 { 1300 #endif 1301 } 1302 #endif 1303 1304 #endif 1305