sybdb.h

ncbi源码

RETCODE dbsetmaxprocs(int maxprocs);
RETCODE dbsetnull(DBPROCESS *dbprocess, int bindtype, int bindlen, BYTE *bindval);
RETCODE dbsetopt(DBPROCESS *dbproc, int option, char *char_param, int int_param);
STATUS dbsetrow(DBPROCESS *dbprocess, DBINT row);
RETCODE dbsettime(int seconds);
void dbsetuserdata(DBPROCESS *dbproc, BYTE *ptr);
RETCODE dbsetversion(DBINT version);
int dbspid(DBPROCESS *dbproc);
RETCODE dbspr1row(DBPROCESS *dbproc, char *buffer, DBINT buf_len);
DBINT dbspr1rowlen(DBPROCESS *dbproc);
RETCODE dbsprhead(DBPROCESS *dbproc, char *buffer, DBINT buf_len);
RETCODE dbsprline(DBPROCESS *dbproc, char *buffer, DBINT buf_len, DBCHAR line_char);
RETCODE dbsqlexec(DBPROCESS *dbproc);
RETCODE dbsqlok(DBPROCESS *dbproc);
RETCODE dbsqlsend(DBPROCESS *dbproc);
int dbstrbuild(DBPROCESS *dbprocess, char *buf, int size, char *text, char *fmt, ...);
int dbstrcmp(DBPROCESS *dbprocess, char *s1, int l1, char *s2, int l2, DBSORTORDER *sort);
RETCODE dbstrcpy(DBPROCESS *dbproc, int start, int numbytes, char *dest);
int dbstrlen(DBPROCESS *dbproc);
int dbstrsort(DBPROCESS *dbprocess, char *s1, int l1, char *s2, int l2, DBSORTORDER *sort);
DBBOOL dbtabbrowse(DBPROCESS *dbprocess, int tabnum);
int dbtabcount(DBPROCESS *dbprocess);
char *dbtabname(DBPROCESS *dbprocess, int tabnum);
char *dbtabsoruce(DBPROCESS *dbprocess, int colnum, int *tabnum);

#define SYBEMEM         20010   /* Unable to allocate sufficient memory. */
#define SYBESMSG        20018   
#define SYBERPND        20019  
#define SYBETIME        20003   /* SQL Server connection timed out. */
#define SYBEABNC        20032   /* Attempt to bind to a non-existent column. */
#define SYBENSIP        20045   /* Negative starting index passed to dbstrcpy().
 */
#define SYBECOFL        20049   /* Data-conversion resulted in overflow. */
#define SYBECSYN        20050   /* Attempt to convert data stopped by syntax err
or in source field. */
#define SYBERDCN        20053   /* Requested data-conversion does not exist. */
#define SYBECLOS        20056   /* Error in closing network connection. */

#define SYBETTS          20066
#define SYBEBDIO         20063
#define SYBEBCVH         20083
#define SYBEBIVI         20080
#define SYBEBCBC         20081
#define SYBEBCFO         20082
#define SYBEBCPB         20078
#define SYBEBCPN         20077
#define SYBEBCPI         20076
#define SYBEBCITBNM      20238
#define SYBEBCITBLEN     20239
#define SYBEBCBNPR       20230
#define SYBEBCBPREF      20236
#define SYBEVDPT         20079
#define SYBEUNOP         20115  /* Unknown option passed to dbsetopt(). */
#define SYBESPID         20154  /* Called dbspid() with a NULL dbproc. */
#define SYBEBNUM         20214  /* Bad numbytes parameter passed to dbstrcpy(). 
*/
#define SYBEBCPCTYP      20233
#define SYBEBCHLEN       20235
#define SYBEBCPREF       20237
#define SYBEBCVLEN       20234
#define SYBEBCUO         20084
#define SYBEBUOE         20097  /* FIXME: I made up this number (not the name). 
jkl */
#define SYBEBUOF         20098
#define SYBEBUDF         20102
#define SYBEBIHC         20103
#define SYBEBCUC         20085
#define SYBEBUCE         20096  /* FIXME: I made up this number (not the name). 
jkl */
#define SYBEBUCF         20099
#define SYBEIFNB         20065
#define SYBEBCRE         20070
#define SYBEBCNN         20073
#define SYBEBBCI         20068

#define BCPETTS          SYBETTS
#define BCPEBDIO         SYBEBDIO
#define BCPEBCVH         SYBEBCVH
#define BCPEBIVI         SYBEBIVI
#define BCPEBCBC         SYBEBCBC
#define BCPEBCFO         SYBEBCFO
#define BCPEBCPB         SYBEBCPB
#define BCPEBCPN         SYBEBCPN
#define BCPEBCPI         SYBEBCPI
#define BCPEBCITBNM      SYBEBCITBNM
#define BCPEBCITBLEN     SYBEBCITBLEN
#define BCPEBCBNPR       SYBEBCBNPR
#define BCPEBCBPREF      SYBEBCBPREF
#define BCPEVDPT         SYBEVDPT
#define BCPEBCPCTYP      SYBEBCPCTYP
#define BCPEBCHLEN       SYBEBCHLEN
#define BCPEBCPREF       SYBEBCPREF
#define BCPEBCVLEN       SYBEBCVLEN
#define BCPEBCUO         SYBEBCUO
#define BCPEBUOF         SYBEBUOF
#define BCPEBUDF         SYBEBUDF
#define BCPEBIHC         SYBEBIHC
#define BCPEBCUC         SYBEBCUC
#define BCPEBUCF         SYBEBUCF
#define BCPEIFNB         SYBEIFNB
#define BCPEBCRE         SYBEBCRE
#define BCPEBCNN         SYBEBCNN
int DBTDS(DBPROCESS *dbprocess);
DBINT dbtextsize(DBPROCESS *dbprocess);
int dbtsnewlen(DBPROCESS *dbprocess);
DBBINARY *dbtsnewval(DBPROCESS *dbprocess);
RETCODE dbtsput(DBPROCESS *dbprocess, DBBINARY *newts, int newtslen, int tabnum, char *tabname);
DBBINARY *dbtxptr(DBPROCESS *dbproc, int column);
DBBINARY *dbtxtimestamp(DBPROCESS *dbproc, int column);
DBBINARY *dbtxtsnewval(DBPROCESS *dbprocess);
RETCODE dbtxtsput(DBPROCESS *dbprocess, DBBINARY newtxts, int colnum);
RETCODE dbuse(DBPROCESS *dbproc, char *dbname);
DBBOOL dbcarylen(DBPROCESS *dbprocess, int column);
char *dbversion(void);
DBBOOL dbwillconvert(int srctype, int desttype);
RETCODE dbwritepage(DBPROCESS *dbprocess, char *dbname, DBINT pageno, DBINT size, BYTE *buf);
RETCODE dbwritetext(DBPROCESS *dbproc, char *objname, DBBINARY *textptr, DBTINYINT textptrlen, DBBINARY *timestamp, DBBOOL log, DBINT size, BYTE *text);
int dbxlate(DBPROCESS *dbprocess, char *src, int srclen, char *dest, int destlen, DBXLATE *xlt, int *srcbytes_used, DBBOOL srcend, int status);

/* LOGINREC manipulation */
RETCODE dbsetlname(LOGINREC *login, char *value, int which);
RETCODE dbsetlbool(LOGINREC *login, int value, int which);
RETCODE dbsetlshort(LOGINREC *login, int value, int which);
RETCODE dbsetllong(LOGINREC* login, long value, int which);
#define DBSETHOST		1
#define DBSETLHOST(x,y)		dbsetlname((x), (y), DBSETHOST)
#define DBSETUSER		2
#define DBSETLUSER(x,y)		dbsetlname((x), (y), DBSETUSER)
#define DBSETPWD		3
#define DBSETLPWD(x,y)		dbsetlname((x), (y), DBSETPWD)
#define DBSETHID		4 /* not implemented */
#define DBSETLHID(x,y)		dbsetlname((x), (y), DBSETHID)
#define DBSETAPP		5
#define DBSETLAPP(x,y)		dbsetlname((x), (y), DBSETAPP)
#define DBSETBCP		6
#define BCP_SETL(x,y)		dbsetlbool((x), (y), DBSETBCP)
#define DBSETNATLANG		7
#define DBSETLNATLANG(x,y)	dbsetlname((x), (y), DBSETNATLANG)
#define DBSETNOSHORT		8 /* not implemented */
#define DBSETLNOSHORT(x,y)	dbsetlbool((x), (y), DBSETNOSHORT)
#define DBSETHIER		9 /* not implemented */
#define DBSETLHIER(x,y)		dbsetlshort((x), (y), DBSETHIER)
#define DBSETCHARSET		10
#define DBSETLCHARSET(x,y)	dbsetlname((x), (y), DBSETCHARSET)
#define DBSETPACKET		11
#define DBSETLPACKET(x,y)	dbsetllong((x), (y), DBSETPACKET)
#define DBSETENCRYPT		12
#define DBSETLENCRYPT(x,y)	dbsetlbool((x), (y), DBSETENCRYPT)
#define DBSETLABELED		13
#define DBSETLLABELED(x,y)	dbsetlbool((x), (y), DBSETLABELED)
#define BCP_SETLABELED(x,y)	dbsetlbool((x), (y), DBSETLABELED)

extern	RETCODE    bcp_init(DBPROCESS *dbproc, char *tblname, char *hfile, 
                            char *errfile, int direction);
extern	RETCODE    bcp_collen(DBPROCESS *dbproc, DBINT varlen, 
                              int table_column);
extern	RETCODE    bcp_columns(DBPROCESS *dbproc, int host_colcount);
extern	RETCODE    bcp_colfmt(DBPROCESS *dbproc, int host_colnum, 
                              int host_type, int host_prefixlen, 
                              DBINT host_collen, BYTE *host_term,
                              int host_termlen, int table_colnum);
extern	RETCODE    bcp_colfmt_ps(DBPROCESS *dbproc, int host_colnum, 
                                 int host_type, int host_prefixlen, 
                                 DBINT host_collen, BYTE *host_term,
                                 int host_termlen, int table_colnum, 
                                 DBTYPEINFO *typeinfo);
extern	RETCODE    bcp_control(DBPROCESS *dbproc, int field, DBINT value);
extern	RETCODE    bcp_colptr(DBPROCESS *dbproc, BYTE *colptr,
                              int table_column);
extern	DBBOOL     bcp_getl(LOGINREC *login);
extern	RETCODE    bcp_exec(DBPROCESS *dbproc, DBINT *rows_copied);
extern	RETCODE    bcp_readfmt(DBPROCESS *dbproc, char *filename);
extern	RETCODE    bcp_writefmt(DBPROCESS *dbproc, char *filename);
extern	RETCODE    bcp_sendrow(DBPROCESS *dbproc);
extern	RETCODE    bcp_moretext(DBPROCESS *dbproc, DBINT size, BYTE *text);
extern	int    bcp_batch(DBPROCESS *dbproc);
extern	int    bcp_done(DBPROCESS *dbproc);
extern	RETCODE    bcp_bind(DBPROCESS *dbproc, BYTE *varaddr, int prefixlen, 
                            DBINT varlen, BYTE *terminator, int termlen, 
                            int type, int table_column);
extern	RETCODE    dbmnyadd(DBPROCESS *dbproc, DBMONEY *m1, DBMONEY *m2, 
                            DBMONEY *sum);
extern	RETCODE    dbmnysub(DBPROCESS *dbproc, DBMONEY *m1, DBMONEY *m2, 
                            DBMONEY *diff);
extern	RETCODE    dbmnymul(DBPROCESS *dbproc, DBMONEY *m1, DBMONEY *m2,
                            DBMONEY *prod);
extern	RETCODE    dbmnydivide(DBPROCESS *dbproc, DBMONEY *m1, DBMONEY *m2,
                               DBMONEY *quotient);
extern	RETCODE    dbmnycmp(DBPROCESS *dbproc, DBMONEY *m1, DBMONEY *m2);
extern	RETCODE    dbmnyscale(DBPROCESS *dbproc, DBMONEY *dest,int multiplier,
                              int addend);
extern	RETCODE    dbmnyzero(DBPROCESS *dbproc, DBMONEY *dest);
extern	RETCODE    dbmnymaxpos(DBPROCESS *dbproc, DBMONEY *dest);
extern	RETCODE    dbmnymaxneg(DBPROCESS *dbproc, DBMONEY *dest);
extern	RETCODE    dbmnyndigit(DBPROCESS *dbproc, DBMONEY *mnyptr,
                               DBCHAR *value, DBBOOL *zero);
extern	RETCODE    dbmnyinit(DBPROCESS *dbproc,DBMONEY *mnyptr, int trim, 
                             DBBOOL *negative);
extern	RETCODE    dbmnydown(DBPROCESS *dbproc,DBMONEY *mnyptr, int divisor, 
                             int *remainder);
extern	RETCODE    dbmnyinc(DBPROCESS *dbproc,DBMONEY *mnyptr);
extern	RETCODE    dbmnydec(DBPROCESS *dbproc,DBMONEY *mnyptr);
extern	RETCODE    dbmnyminus(DBPROCESS *dbproc,DBMONEY *src, DBMONEY *dest);
extern	RETCODE    dbmny4cmp(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2);
extern	RETCODE    dbmny4minus(DBPROCESS *dbproc, DBMONEY4 *src, 
                               DBMONEY4 *dest);
extern	RETCODE    dbmny4zero(DBPROCESS *dbproc, DBMONEY4 *dest);
extern	RETCODE    dbmny4add(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2, 
                             DBMONEY4 *sum);
extern	RETCODE    dbmny4sub(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2,
                             DBMONEY4 *diff);
extern	RETCODE    dbmny4mul(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2, 
                             DBMONEY4 *prod);
extern	RETCODE    dbmny4divide(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2,
                                DBMONEY4 *quotient);
extern	RETCODE    dbmny4cmp(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2);
extern	RETCODE    dbdatecmp(DBPROCESS *dbproc, DBDATETIME *d1,
                             DBDATETIME *d2);
extern	RETCODE    dbdatecrack(DBPROCESS *dbproc, DBDATEREC *dateinfo,
                               DBDATETIME *datetime);
extern	void       dbrpwclr(LOGINREC *login);
extern	RETCODE    dbrpwset(LOGINREC *login, char *srvname, char *password, 
                            int pwlen);
extern	void       build_xact_string(char *xact_name, char *service_name,
                                     DBINT commid, char *result);
extern	RETCODE    remove_xact(DBPROCESS *connect, DBINT commid, int n);
extern	RETCODE    abort_xact(DBPROCESS *connect, DBINT commid);
extern	void       close_commit(DBPROCESS *connect);
extern	RETCODE    commit_xact(DBPROCESS *connect, DBINT commid);
extern	DBPROCESS *open_commit(LOGINREC *login, char *servername);
extern	RETCODE    scan_xact(DBPROCESS *connect, DBINT commid);
extern	DBINT      start_xact(DBPROCESS *connect, char *application_name,
                              char *xact_name, int site_count);
extern	DBINT      stat_xact(DBPROCESS *connect, DBINT commid);
extern	int        dbspid(DBPROCESS *dbproc);
extern  char      *dbmonthname(DBPROCESS *dbproc,char *language,int monthnum,
                               DBBOOL shortform);
extern  char      *dbname(DBPROCESS *dbproc);
extern  BYTE      *dbdata(DBPROCESS *dbproc,int column);
extern  char      *dbcolname(DBPROCESS *dbproc,int column);
extern  DBBINARY  *dbtxptr(DBPROCESS *dbproc,int column);
extern  DBBINARY  *dbtxtimestamp(DBPROCESS *dbproc, int column);
extern  RETCODE    dbwritetext(DBPROCESS *dbproc,char *objname, 
				DBBINARY *textptr, DBTINYINT textptrlen, 
				DBBINARY *timestamp, DBBOOL log, 
                                        DBINT size, BYTE *text);
extern  void       dbfreebuf(DBPROCESS *dbproc);
extern  RETCODE	   dbcmd(DBPROCESS *dbproc, char *cmdstring);
extern  RETCODE    dbsqlexec(DBPROCESS *dbproc);
extern  int        dbnumcols(DBPROCESS *dbproc);
extern  DBINT      dbcollen(DBPROCESS *dbproc, int column);
extern  char      *dbprtype(int token);
extern  RETCODE    dbbind(DBPROCESS *dbproc, int column, int vartype, 
                          DBINT varlen, BYTE *varaddr);
extern  RETCODE	   dbnullbind(DBPROCESS *dbproc, int column, DBINT *indicator);
extern  RETCODE    dbsqlsend(DBPROCESS *dbproc);
extern  RETCODE    dbaltutype(DBPROCESS *dbproc, int computeid, int column);
extern  RETCODE    dbaltlen(DBPROCESS *dbproc, int computeid, int column);
extern  RETCODE    dbpoll(DBPROCESS *dbproc, long milliseconds,
                          DBPROCESS **ready_dbproc, int *return_reason);

extern  DBINT dbspr1rowlen(DBPROCESS *dbproc);
extern  RETCODE dbspr1row(DBPROCESS *dbproc, char *buffer, DBINT buf_len);
extern  RETCODE dbsprline(DBPROCESS *dbproc,char *buffer, DBINT buf_len, 
			DBCHAR line_char);
extern  RETCODE dbsprhead(DBPROCESS *dbproc,char *buffer, DBINT buf_len);
extern  char *dbversion();
extern  RETCODE dbcanquery(DBPROCESS *dbproc);

#ifdef __cplusplus
#if 0
{
#endif
}
#endif

#endif