sybdb.h

这是linux下关于C的编程

/*
**      Sybase DB-LIBRARY 
**      Confidential Property of Sybase, Inc.
**      (c) Copyright Sybase, Inc. 1988 to 1996.
**      All rights reserved.
**
**
** Use, duplication, or disclosure by the Government
** is subject to restrictions as set forth in subparagraph (c) (1) (ii)
** of the Rights in Technical Data and Computer Software clause
** at DFARS 52.227-7013. Sybase, Inc. 6475 Christie Avenue, Emeryville,
** CA 94608.
**
** History
**
** 001  12JAN94	 Added prototypes for the functions refered thru
**		 function pointer to make DBLIB ANSI compliant.		sureshk
** 002	08Jul94	Fixed all the prototypes to make it consistant with
**		all other public headers				nagar
** 003  11AUG94	 Added db_filmode field in DBPROCESS			cchen
** 004  30MAY96	 Added DCL interfaces support to dblib			cchen
*/

#ifndef __sybdb__
#define __sybdb__

/* 
** Include stdio.h if it hasn't already been done 
*/
#ifndef FILE

#include <stdio.h>

/* 
** If NULL has not been defined by stdio.h
** make sure it has a valid value.
*/
#ifndef NULL		
#define NULL	0
#endif /* NULL */


#endif /* FILE */


/* 
** Indicate use of Macintosh compiler
*/
#if defined(applec) || defined(powerc) || defined(__MWERKS__) || defined(THINK_C)
#define SYB_MAC 1
#endif  /* defined(applec) || defined(powerc) || defined(__MWERKS__) || defined(THINK_C) */

#include        <syblogin.h>

/*
** The following datatype definitions are included here to avoid including
** tds.h. This will help in keeing the number of released header files
** to a minimum.
*/
#define SYBVOID		(BYTE)0x1F
#define SYBBINARY	(BYTE)0x2D
#define SYBBIT		(BYTE)0x32
#define SYBCHAR		(BYTE)0x2F
#define SYBDATETIME4	(BYTE)0x3A
#define SYBDATETIME	(BYTE)0x3D
#define SYBDATETIMN	(BYTE)0x6F
#define SYBDECIMAL	(BYTE)0x6A
#define SYBFLT8		(BYTE)0x3E
#define SYBFLTN		(BYTE)0x6D
#define SYBREAL		(BYTE)0x3B
#define SYBIMAGE	(BYTE)0x22
#define SYBINT1		(BYTE)0x30
#define SYBINT2		(BYTE)0x34
#define SYBINT4		(BYTE)0x38
#define SYBINTN		(BYTE)0x26
#define SYBLONGBINARY	(BYTE)0xE1
#define SYBLONGCHAR	(BYTE)0xAF
#define SYBMONEY4	(BYTE)0x7A
#define SYBMONEY	(BYTE)0x3C
#define SYBMONEYN	(BYTE)0x6E
#define SYBNUMERIC	(BYTE)0x6C
#define SYBTEXT		(BYTE)0x23
#define SYBVARBINARY	(BYTE)0x25
#define SYBVARCHAR	(BYTE)0x27
#define SYBSENSITIVITY	(BYTE)0x67
#define SYBBOUNDARY	(BYTE)0x68

/*
** The following tokens can be returned by dbaltop().
*/
#define SYBAOPCNT	(BYTE)0x4b
#define SYBAOPSUM	(BYTE)0x4d
#define SYBAOPAVG	(BYTE)0x4f
#define SYBAOPMIN	(BYTE)0x51
#define SYBAOPMAX	(BYTE)0x52

/* Additions for 10.0 front ends, taken from the now obsolete sybdbtoken.h */
#define SYBAOPCNTU		0x4c
#define SYBAOPSUMU		0x4e
#define SYBAOPAVGU		0x50
#define SYBTLEND		0x01
#define SYBQLEND		0x02
#define SYBVARCHNE		0x1e
#define SYBDBAID		0x05
#define SYBDBCLOSE		0x13


#ifdef  ABS
#undef  ABS
#endif  /* ABS */
#define ABS(a)          ((a) > 0 ? (a) : -(a))

/*
**  Status code for dbnextrow() and dbgetrow().
**  Return of > 0 indicates ALTROW.
**  FAIL is another possible return.
*/
#define MORE_ROWS       -1
#define NO_MORE_ROWS    -2
#define REG_ROW         MORE_ROWS
#define BUF_FULL        -3

/*
** Return code for dbreadtext().
*/
#define NO_MORE_PARAMS  -4

/*
**  Status code for dbresults(). Possible return values are
**  SUCCEED, FAIL, and NO_MORE_RESULTS.
*/
#define NO_MORE_RESULTS 2

/*
**  Return code for message-handlers. Indicates whether or not the handler
**  wants DB-LIBRARY to buffer the current Server message for later use
**  by the program.
*/
#define DBSAVE          1
#define DBNOSAVE        0

#define DBNOERR         -1

/*
** Default size of row buffer.  This is what people get if they do
** a dbsetopt(dbproc, DBBUFFER, 0).
*/
#define DBBUFSIZE       1000

/* The size of a SYBTEXT timestamp, in bytes. This timestamp is not to be
 * confused with a browse-mode timestamp.
 */
#define DBTXTSLEN       8

/* The size of a text-pointer, in bytes. */
#if !VMS
#define DBTXPLEN        ((DBTINYINT)16)
#else
#define DBTXPLEN        ((unsigned char)16)
#endif

#define DBMAXNAME       30	/* Less like to collide with users' names
				** than "MAXNAME".
				*/
#define MAXNAME         30      /* Still here, so old programs won't
                                 * break yet.
                                 */
/* The following 2 defines are 1.0 Secure Server related. They are only here
** so that old applications are not broken.
*/
#define MINSECLEVEL     1
#define MAXSECLEVEL     16

#define DBMAXCOLNAME    30
#define DBMAXBYLIST     16

#define DBDATE_YY       0       /* year         1753 - 9999 */
#define DBDATE_QQ       1       /* quarter      1 - 4 */
#define DBDATE_MM       2       /* month        January - December */
#define DBDATE_DW       3       /* weekday      Monday - Sunday */
#define DBDATE_DD       4       /* day          1 - 31 */
#define DBDATE_DY       5       /* dayofyear    1 - 366 */
#define DBDATE_HH       6       /* hour         0 - 23 */
#define DBDATE_MI       7       /* minute       0 - 59 */
#define DBDATE_SS       8       /* second       0 - 59 */
#define DBDATE_MS       9       /* millisecond  0 - 999 */
#define DBDATE_WK       10      /* week         1 - 54 (for leap years) */
#define	DBDATE_CY	11
#define	DBDATE_CW	12
#define	DBDATE_CD	13

/* maximum printing lengths for fixed-length data */
#define PRINT4  11
#define PRINT2  6
#define PRINT1  3
#define PRFLT8  20
#define PRFLT4  20
#define PRMONEY 24
#define PRMONEY4        24
#define PRBIT   1
#define PROLDDATETIME   20      /* for backward compatibility */
#define PRDATETIME      26
#define PRDATETIME4     26
#define PRLDATETIME     30      /* includes milliseconds */
#define PRNUMERIC       (CS_MAX_PREC + 2)
#define PRDECIMAL       PRNUMERIC

/* constant definitions for dbsafestr()'s quotetype parameter */
#define DBSINGLE                0
#define DBDOUBLE                1
#define DBBOTH                  2

/* status values returned by dbxlate() */
#define DBXLATE_XOK     0
#define DBXLATE_XOF     1
#define DBXLATE_XPAT    2

/* type values for dbsechandle() */
#define DBENCRYPT	0
#define DBLABELS	1

#define NOBIND		-1
#define TINYBIND        1
#define SMALLBIND       2
#define INTBIND         3
#define CHARBIND        4
#define TEXTBIND        5
#define BINARYBIND      6
#define ARRAYBIND       7
#define BITBIND         8
#define DATETIMEBIND    9
#define MONEYBIND       10
#define FLT8BIND        11
#define STRINGBIND      12
#define NTBSTRINGBIND   13
#define VARYCHARBIND    14
#define VARYBINBIND     15
#define SMALLDATETIMEBIND       16
#define SMALLMONEYBIND  17
#define REALBIND        18
#define NUMERICBIND	19
#define DECIMALBIND	20
#define SENSITIVITYBIND	21
#define BOUNDARYBIND	22
#if VOS
#define FIXEDBIND	23                      /*kvk589*/
#define PACKEDBIND	24                      /*kvk589*/
#endif

#define MAXBIND		BOUNDARYBIND

/*
**    OFFSETS DEFINITIONS
**
**    These are a subset of the token values for offset information.
**    These defines come from y.tab.h
**
*/
#define _SELECT 365
#define _EXECUTE 330
#define _FROM 335
#define _ORDER 357
#define _COMPUTE 313
#define _TABLE 371
#define _PROCEDURE 362
#define _STATEMENT 459
#define _PARAM 452

/* end y.tab.h */

/* DB-LIBRARY minor error numbers */
#define SYBESYNC        20001   /* Read attempted while out of synchronization
                                 * with SQL Server.
                                 */
#define SYBEFCON        20002   /* SQL Server connection failed. */
#define SYBETIME        20003   /* SQL Server connection timed out. */
#define SYBEREAD        20004   /* Read from SQL Server failed. */
#define SYBEBUFL        20005   /* DB-LIBRARY internal error - send buffer
                                 * length corrupted.
                                 */
#define SYBEWRIT        20006   /* Write to SQL Server failed. */
#define SYBEVMS         20007   /* Sendflush: VMS I/O error. */
#define SYBESOCK        20008   /* Unable to open socket */
#define SYBECONN        20009   /* Unable to connect socket -- SQL Server is
                                 * unavailable or does not exist.
                                 */
#define SYBEMEM         20010   /* Unable to allocate sufficient memory */
#define SYBEDBPS        20011   /* Maximum number of DBPROCESSes
                                 * already allocated.
                                 */
#define SYBEINTF        20012   /* Server name not found in interface file */
#define SYBEUHST        20013   /* Unknown host machine name */
#define SYBEPWD         20014   /* Incorrect password. */
#define SYBEOPIN        20015   /* Could not open interface file. */
#define SYBEINLN        20016   /* Interface file: unexpected end-of-line. */
#define SYBESEOF        20017   /* Unexpected EOF from SQL Server. */
#define SYBESMSG        20018   /* General SQL Server error: Check messages
                                 * from the SQL Server.
                                 */
#define SYBERPND        20019   /* Attempt to initiate a new SQL Server
                                 * operation with results pending.
                                 */
#define SYBEBTOK        20020   /* Bad token from SQL Server: Data-stream
                                 * processing out of sync.
                                 */
#define SYBEITIM        20021   /* Illegal timeout value specified. */
#define SYBEOOB         20022   /* Error in sending out-of-band data to
                                 * SQL Server.