*
proc,
intline);
539 #define DBNOTIFICATION 2 541 #define DBINTERRUPT 4 549 #define NTBSTRINGBIND 2 550 #define VARYCHARBIND 3 551 #define VARYBINBIND 4 557 #define DATETIMEBIND 11 558 #define SMALLDATETIMEBIND 12 560 #define SMALLMONEYBIND 14 561 #define BINARYBIND 15 563 #define NUMERICBIND 17 564 #define DECIMALBIND 18 565 #define SRCNUMERICBIND 19 566 #define SRCDECIMALBIND 20 569 #define BIGDATETIMEBIND 23 570 #define BIGTIMEBIND 24 571 #define BIGINTBIND 30 572 #define DATETIME2BIND 31 573 #define MAXBINDTYPES 32 575 #define DBPRCOLSEP 21 576 #define DBPRLINELEN 22 577 #define DBRPCRETURN 1 578 #define DBRPCDEFAULT 2 582 #define NO_MORE_ROWS -2 584 #define NO_MORE_RESULTS 2 590 #define DB_QUERYOUT 3 597 #define DBRPCRECOMPILE TDS_STATIC_CAST(DBSMALLINT, 0x0001) 598 #define DBRPCRESET TDS_STATIC_CAST(DBSMALLINT, 0x0002) 599 #define DBRPCCURSOR TDS_STATIC_CAST(DBSMALLINT, 0x0008) 601 #if defined(DBLIB_UNIMPLEMENTED) 618 char*dateorder(
DBPROCESS* dbprocess,
char*language);
621 char*dbdayname(
DBPROCESS* dbprocess,
char*language,
intdaynum);
625 char*dbqual(
DBPROCESS* dbprocess,
inttabnum,
char*tabname);
626 voiddbfreequal(
char*qualptr);
651 intdbordercol(
DBPROCESS* dbprocess,
intorder);
669 RETCODEdbsetdeflang(
char*language);
676 char*dbtabname(
DBPROCESS* dbprocess,
inttabnum);
677 char*dbtabsource(
DBPROCESS* dbprocess,
intcolnum,
int*tabnum);
690 intdbxlate(
DBPROCESS* dbprocess,
char*src,
intsrclen,
char*dest,
intdestlen,
DBXLATE* xlt,
int*srcbytes_used,
691 DBBOOLsrcend,
intstatus);
696 voidbuild_xact_string(
char*xact_name,
char*service_name,
DBINTcommid,
char*
result);
703 DBINTstart_xact(
DBPROCESS* connect,
char*application_name,
char*xact_name,
intsite_count);
733 #define DBCMDROW(x) dbcmdrow((x)) 748 #define DBCOUNT(x) dbcount((x)) 751 #define DBCURCMD(x) dbcurcmd((x)) 754 #define DBCURROW(x) dbcurrow((x)) 762 #define DBDEAD(x) dbdead((x)) 768 #define DBFIRSTROW(x) dbfirstrow((x)) 778 #define DBGETTIME dbgettime 784 #define DBIORDESC(x) dbiordesc((x)) 787 #define DBIOWDESC(x) dbiowdesc((x)) 790 #define DBISAVAIL(x) dbisavail((x)) 794 #define DBLASTROW(x) dblastrow((x)) 820 #define DBMORECMDS(x) dbmorecmds((x)) 848 #ifndef _FREETDS_LIBRARY_SOURCE 853 #define dbopen(x,y) tdsdbopen((x),(y), 1) 855 #define dbopen(x,y) tdsdbopen((x),(y), 0) 860 #ifdef PHP_SYBASE_DBOPEN 861 #undef PHP_SYBASE_DBOPEN 862 #define PHP_SYBASE_DBOPEN dbopen 881 #define DBROWS(x) dbrows((x)) 884 #define DBROWTYPE(x) dbrowtype((x)) 919 #define SYBEVERDOWN 100 920 #define SYBEICONVIU 2400 921 #define SYBEICONVAVAIL 2401 922 #define SYBEICONVO 2402 923 #define SYBEICONVI 2403 924 #define SYBEICONV2BIG 2404 927 #define SYBETDSVER 2410 928 #define SYBEPORT 2500 929 #define SYBESYNC 20001 930 #define SYBEFCON 20002 931 #define SYBETIME 20003 932 #define SYBEREAD 20004 933 #define SYBEBUFL 20005 934 #define SYBEWRIT 20006 935 #define SYBEVMS 20007 936 #define SYBESOCK 20008 937 #define SYBECONN 20009 938 #define SYBEMEM 20010 939 #define SYBEDBPS 20011 940 #define SYBEINTF 20012 941 #define SYBEUHST 20013 942 #define SYBEPWD 20014 943 #define SYBEOPIN 20015 944 #define SYBEINLN 20016 945 #define SYBESEOF 20017 946 #define SYBESMSG 20018 947 #define SYBERPND 20019 948 #define SYBEBTOK 20020 949 #define SYBEITIM 20021 950 #define SYBEOOB 20022 951 #define SYBEBTYP 20023 952 #define SYBEBNCR 20024 953 #define SYBEIICL 20025 954 #define SYBECNOR 20026 955 #define SYBENPRM 20027 956 #define SYBEUVDT 20028 957 #define SYBEUFDT 20029 958 #define SYBEWAID 20030 959 #define SYBECDNS 20031 960 #define SYBEABNC 20032 961 #define SYBEABMT 20033 962 #define SYBEABNP 20034 963 #define SYBEAAMT 20035 964 #define SYBENXID 20036 965 #define SYBERXID 20037 966 #define SYBEICN 20038 967 #define SYBENMOB 20039 968 #define SYBEAPUT 20040 969 #define SYBEASNL 20041 970 #define SYBENTLL 20042 971 #define SYBEASUL 20043 972 #define SYBERDNR 20044 973 #define SYBENSIP 20045 974 #define SYBEABNV 20046 975 #define SYBEDDNE 20047 976 #define SYBECUFL 20048 977 #define SYBECOFL 20049 978 #define SYBECSYN 20050 979 #define SYBECLPR 20051 980 #define SYBECNOV 20052 981 #define SYBERDCN 20053 982 #define SYBESFOV 20054 983 #define SYBEUNT 20055 984 #define SYBECLOS 20056 985 #define SYBEUAVE 20057 986 #define SYBEUSCT 20058 987 #define SYBEEQVA 20059 988 #define SYBEUDTY 20060 989 #define SYBETSIT 20061 990 #define SYBEAUTN 20062 991 #define SYBEBDIO 20063 992 #define SYBEBCNT 20064 993 #define SYBEIFNB 20065 994 #define SYBETTS 20066 995 #define SYBEKBCO 20067 996 #define SYBEBBCI 20068 997 #define SYBEKBCI 20069 998 #define SYBEBCRE 20070 999 #define SYBETPTN 20071 1000 #define SYBEBCWE 20072 1001 #define SYBEBCNN 20073 1002 #define SYBEBCOR 20074 1003 #define SYBEBCIS 20075 1004 #define SYBEBCPI 20076 1005 #define SYBEBCPN 20077 1006 #define SYBEBCPB 20078 1007 #define SYBEVDPT 20079 1008 #define SYBEBIVI 20080 1009 #define SYBEBCBC 20081 1010 #define SYBEBCFO 20082 1011 #define SYBEBCVH 20083 1012 #define SYBEBCUO 20084 1013 #define SYBEBCUC 20085 1014 #define SYBEBUOE 20086 1015 #define SYBEBUCE 20087 1016 #define SYBEBWEF 20088 1017 #define SYBEASTF 20089 1018 #define SYBEUACS 20090 1019 #define SYBEASEC 20091 1020 #define SYBETMTD 20092 1021 #define SYBENTTN 20093 1022 #define SYBEDNTI 20094 1023 #define SYBEBTMT 20095 1024 #define SYBEORPF 20096 1025 #define SYBEUVBF 20097 1026 #define SYBEBUOF 20098 1027 #define SYBEBUCF 20099 1028 #define SYBEBRFF 20100 1029 #define SYBEBWFF 20101 1030 #define SYBEBUDF 20102 1031 #define SYBEBIHC 20103 1032 #define SYBEBEOF 20104 1033 #define SYBEBCNL 20105 1034 #define SYBEBCSI 20106 1035 #define SYBEBCIT 20107 1036 #define SYBEBCSA 20108 1037 #define SYBENULL 20109 1038 #define SYBEUNAM 20110 1039 #define SYBEBCRO 20111 1040 #define SYBEMPLL 20112 1041 #define SYBERPIL 20113 1042 #define SYBERPUL 20114 1043 #define SYBEUNOP 20115 1044 #define SYBECRNC 20116 1045 #define SYBERTCC 20117 1046 #define SYBERTSC 20118 1047 #define SYBEUCRR 20119 1048 #define SYBERPNA 20120 1049 #define SYBEOPNA 20121 1050 #define SYBEFGTL 20122 1051 #define SYBECWLL 20123 1052 #define SYBEUFDS 20124 1053 #define SYBEUCPT 20125 1054 #define SYBETMCF 20126 1055 #define SYBEAICF 20127 1056 #define SYBEADST 20128 1057 #define SYBEALTT 20129 1058 #define SYBEAPCT 20130 1059 #define SYBEXOCI 20131 1060 #define SYBEFSHD 20132 1061 #define SYBEAOLF 20133 1062 #define SYBEARDI 20134 1063 #define SYBEURCI 20135 1064 #define SYBEARDL 20136 1065 #define SYBEURMI 20137 1066 #define SYBEUREM 20138 1067 #define SYBEURES 20139 1068 #define SYBEUREI 20140 1069 #define SYBEOREN 20141 1070 #define SYBEISOI 20142 1071 #define SYBEIDCL 20143 1072 #define SYBEIMCL 20144 1073 #define SYBEIFCL 20145 1074 #define SYBEUTDS 20146 1075 #define SYBEBUFF 20147 1076 #define SYBEACNV 20148 1077 #define SYBEDPOR 20149 1078 #define SYBENDC 20150 1079 #define SYBEMVOR 20151 1080 #define SYBEDVOR 20152 1081 #define SYBENBVP 20153 1082 #define SYBESPID 20154 1083 #define SYBENDTP 20155 1084 #define SYBEXTN 20156 1085 #define SYBEXTDN 20157 1086 #define SYBEXTSN 20158 1087 #define SYBENUM 20159 1088 #define SYBETYPE 20160 1089 #define SYBEGENOS 20161 1090 #define SYBEPAGE 20162 1091 #define SYBEOPTNO 20163 1092 #define SYBEETD 20164 1093 #define SYBERTYPE 20165 1094 #define SYBERFILE 20166 1095 #define SYBEFMODE 20167 1096 #define SYBESLCT 20168 1097 #define SYBEZTXT 20169 1098 #define SYBENTST 20170 1099 #define SYBEOSSL 20171 1100 #define SYBEESSL 20172 1101 #define SYBENLNL 20173 1102 #define SYBENHAN 20174 1103 #define SYBENBUF 20175 1104 #define SYBENULP 20176 1105 #define SYBENOTI 20177 1106 #define SYBEEVOP 20178 1107 #define SYBENEHA 20179 1108 #define SYBETRAN 20180 1109 #define SYBEEVST 20181 1110 #define SYBEEINI 20182 1111 #define SYBEECRT 20183 1112 #define SYBEECAN 20184 1113 #define SYBEEUNR 20185 1114 #define SYBERPCS 20186 1115 #define SYBETPAR 20187 1116 #define SYBETEXS 20188 1117 #define SYBETRAC 20189 1118 #define SYBETRAS 20190 1119 #define SYBEPRTF 20191 1120 #define SYBETRSN 20192 1121 #define SYBEBPKS 20193 1122 #define SYBEIPV 20194 1123 #define SYBEMOV 20195 1124 #define SYBEDIVZ 20196 1125 #define SYBEASTL 20197 1126 #define SYBESEFA 20198 1127 #define SYBEPOLL 20199 1128 #define SYBENOEV 20200 1129 #define SYBEBADPK 20201 1130 #define SYBESECURE 20202 1131 #define SYBECAP 20203 1132 #define SYBEFUNC 20204 1133 #define SYBERESP 20205 1134 #define SYBEIVERS 20206 1135 #define SYBEONCE 20207 1136 #define SYBERPNULL 20208 1137 #define SYBERPTXTIM 20209 1138 #define SYBENEG 20210 1139 #define SYBELBLEN 20211 1140 #define SYBEUMSG 20212 1141 #define SYBECAPTYP 20213 1142 #define SYBEBNUM 20214 1143 #define SYBEBBL 20215 1144 #define SYBEBPREC 20216 1145 #define SYBEBSCALE 20217 1146 #define SYBECDOMAIN 20218 1147 #define SYBECINTERNAL 20219 1148 #define SYBEBTYPSRV 20220 1149 #define SYBEBCSET 20221 1150 #define SYBEFENC 20222 1151 #define SYBEFRES 20223 1152 #define SYBEISRVPREC 20224 1153 #define SYBEISRVSCL 20225 1154 #define SYBEINUMCL 20226 1155 #define SYBEIDECCL 20227 1156 #define SYBEBCMTXT 20228 1157 #define SYBEBCPREC 20229 1158 #define SYBEBCBNPR 20230 1159 #define SYBEBCBNTYP 20231 1160 #define SYBEBCSNTYP 20232 1161 #define SYBEBCPCTYP 20233 1162 #define SYBEBCVLEN 20234 1163 #define SYBEBCHLEN 20235 1164 #define SYBEBCBPREF 20236 1165 #define SYBEBCPREF 20237 1166 #define SYBEBCITBNM 20238 1167 #define SYBEBCITBLEN 20239 1168 #define SYBEBCSNDROW 20240 1169 #define SYBEBPROCOL 20241 1170 #define SYBEBPRODEF 20242 1171 #define SYBEBPRONUMDEF 20243 1172 #define SYBEBPRODEFID 20244 1173 #define SYBEBPRONODEF 20245 1174 #define SYBEBPRODEFTYP 20246 1175 #define SYBEBPROEXTDEF 20247 1176 #define SYBEBPROEXTRES 20248 1177 #define SYBEBPROBADDEF 20249 1178 #define SYBEBPROBADTYP 20250 1179 #define SYBEBPROBADLEN 20251 1180 #define SYBEBPROBADPREC 20252 1181 #define SYBEBPROBADSCL 20253 1182 #define SYBEBADTYPE 20254 1183 #define SYBECRSNORES 20255 1184 #define SYBECRSNOIND 20256 1185 #define SYBECRSVIEW 20257 1186 #define SYBECRSVIIND 20258 1187 #define SYBECRSORD 20259 1188 #define SYBECRSBUFR 20260 1189 #define SYBECRSNOFREE 20261 1190 #define SYBECRSDIS 20262 1191 #define SYBECRSAGR 20263 1192 #define SYBECRSFRAND 20264 1193 #define SYBECRSFLAST 20265 1194 #define SYBECRSBROL 20266 1195 #define SYBECRSFROWN 20267 1196 #define SYBECRSBSKEY 20268 1197 #define SYBECRSRO 20269 1198 #define SYBECRSNOCOUNT 20270 1199 #define SYBECRSTAB 20271 1200 #define SYBECRSUPDNB 20272 1201 #define SYBECRSNOWHERE 20273 1202 #define SYBECRSSET 20274 1203 #define SYBECRSUPDTAB 20275 1204 #define SYBECRSNOUPD 20276 1205 #define SYBECRSINV 20277 1206 #define SYBECRSNOKEYS 20278 1207 #define SYBECRSNOBIND 20279 1208 #define SYBECRSFTYPE 20280 1209 #define SYBECRSINVALID 20281 1210 #define SYBECRSMROWS 20282 1211 #define SYBECRSNROWS 20283 1212 #define SYBECRSNOLEN 20284 1213 #define SYBECRSNOPTCC 20285 1214 #define SYBECRSNORDER 20286 1215 #define SYBECRSNOTABLE 20287 1216 #define SYBECRSNUNIQUE 20288 1217 #define SYBECRSVAR 20289 1218 #define SYBENOVALUE 20290 1219 #define SYBEVOIDRET 20291 1220 #define SYBECLOSEIN 20292 1221 #define SYBEBOOL 20293 1222 #define SYBEBCPOPT 20294 1223 #define SYBEERRLABEL 20295 1224 #define SYBEATTNACK 20296 1225 #define SYBEBBFL 20297 1226 #define SYBEDCL 20298 1227 #define SYBECS 20299 1228 #define SYBEBULKINSERT 20599 1229 #define SYBECOLSIZE 22000 1233 #define DBTDS(a) dbtds(a) 1253 #define DBSETLHOST(x,y) dbsetlname((x), (y), DBSETHOST) 1254 #define dbsetlhost(x,y) dbsetlname((x), (y), DBSETHOST) 1256 #define DBSETLUSER(x,y) dbsetlname((x), (y), DBSETUSER) 1257 #define dbsetluser(x,y) dbsetlname((x), (y), DBSETUSER) 1259 #define DBSETLPWD(x,y) dbsetlname((x), (y), DBSETPWD) 1260 #define dbsetlpwd(x,y) dbsetlname((x), (y), DBSETPWD) 1261 #if defined(DBLIB_UNIMPLEMENTED) 1263 # define DBSETLHID(x,y) dbsetlname((x), (y), DBSETHID) 1266 #define DBSETLAPP(x,y) dbsetlname((x), (y), DBSETAPP) 1267 #define dbsetlapp(x,y) dbsetlname((x), (y), DBSETAPP) 1269 #define BCP_SETL(x,y) dbsetlbool((x), (y), DBSETBCP) 1270 #define DBSETLSECURE(x) dbsetlbool((x), (1), DBSETBCP) 1271 #define DBSETNATLANG 7 1272 #define DBSETLNATLANG(x,y) dbsetlname((x), (y), DBSETNATLANG) 1273 #define dbsetlnatlang(x,y) dbsetlname((x), (y), DBSETNATLANG) 1274 #if defined(DBLIB_UNIMPLEMENTED) 1275 # define DBSETNOSHORT 8 1276 # define DBSETLNOSHORT(x,y) dbsetlbool((x), (y), DBSETNOSHORT) 1277 # define DBSETHIER 9 1278 # define DBSETLHIER(x,y) dbsetlshort((x), (y), DBSETHIER) 1280 #define DBSETCHARSET 10 1281 #define DBSETLCHARSET(x,y) dbsetlname((x), (y), DBSETCHARSET) 1282 #define DBSETPACKET 11 1283 #define DBSETLPACKET(x,y) dbsetllong((x), (y), DBSETPACKET) 1284 #define dbsetlpacket(x,y) dbsetllong((x), (y), DBSETPACKET) 1285 #define DBSETENCRYPT 12 1286 #define DBSETLENCRYPT(x,y) dbsetlbool((x), (y), DBSETENCRYPT) 1287 #define DBSETLABELED 13 1288 #define DBSETLLABELED(x,y) dbsetlbool((x), (y), DBSETLABELED) 1289 #define BCP_SETLABELED(x,y) dbsetlbool((x), (y), DBSETLABELED) 1290 #define DBSETDBNAME 14 1291 #define DBSETLDBNAME(x,y) dbsetlname((x), (y), DBSETDBNAME) 1292 #define DBSETLVERSION(login, version) dbsetlversion((login), (version)) 1294 #define DBSETUTF16 1001 1295 #define DBSETLUTF16(x,y) dbsetlbool((x), (y), DBSETUTF16) 1296 #define DBSETNTLMV2 1002 1297 #define DBSETLNTLMV2(x,y) dbsetlbool((x), (y), DBSETNTLMV2) 1298 #define DBSETREADONLY 1003 1299 #define DBSETLREADONLY(x,y) dbsetlbool((x), (y), DBSETREADONLY) 1310 const BYTE* host_term,
inthost_termlen,
intcolnum);
1312 BYTE* host_term,
inthost_termlen,
intcolnum,
DBTYPEINFO* typeinfo);
void(*)(CSeq_entry_Handle seh, IWorkbench *wb, const CSerialObject &obj) handler
static DBPROCESS * dbproc
static int hndlintr(DBPROCESS *dbproc)
static int chkintr(DBPROCESS *dbproc)
static SQLCHAR output[256]
static const char * str(char *buf, int n)
static const char * column
int dbbufsize(DBPROCESS *dbprocess)
struct dbtypeinfo DBTYPEINFO
RETCODE dbsetlshort(LOGINREC *login, int value, int which)
DBBINARY * dbtxtsnewval(DBPROCESS *dbprocess)
DBBOOL dbcharsetconv(DBPROCESS *dbprocess)
RETCODE dbaltbind_ps(DBPROCESS *dbprocess, int computeid, int column, int vartype, DBINT varlen, BYTE *varaddr, DBTYPEINFO *typeinfo)
DBWAITFUNC(* DB_DBBUSY_FUNC)(void *dbproc)
void dbsetidle(DBPROCESS *dbprocess, DB_DBIDLE_FUNC idlefunc)
void(* DB_DBIDLE_FUNC)(DBWAITFUNC dfunc, void *dbproc)
RETCODE dbbind_ps(DBPROCESS *dbprocess, int column, int vartype, DBINT varlen, BYTE *varaddr, DBTYPEINFO *typeinfo)
int(* DB_DBCHKINTR_FUNC)(void *dbproc)
char * dbgetcharset(DBPROCESS *dbprocess)
#define SYBMSDATETIMEOFFSET
RETCODE dbtxtsput(DBPROCESS *dbprocess, DBBINARY newtxts, int colnum)
char * dbgetnatlanf(DBPROCESS *dbprocess)
DBINT dbtextsize(DBPROCESS *dbprocess)
RETCODE dbmnysub(DBPROCESS *dbproc, DBMONEY *m1, DBMONEY *m2, DBMONEY *diff)
void(* DBPIVOT_FUNC)(struct col_t *output, const struct col_t *input)
int(* EHANDLEFUNC)(DBPROCESS *dbproc, int severity, int dberr, int oserr, char *dberrstr, char *oserrstr)
DBBOOL DRBUF(DBPROCESS *dbprocess)
RETCODE dbresults_r(DBPROCESS *dbproc, int recursive)
int(* INTFUNCPTR)(void *,...)
int(* DB_DBHNDLINTR_FUNC)(void *dbproc)
int(* MHANDLEFUNC)(DBPROCESS *dbproc, DBINT msgno, int msgstate, int severity, char *msgtext, char *srvname, char *proc, int line)
RETCODE * dbsechandle(DBINT type, INTFUNCPTR handler)
int dbgetlusername(LOGINREC *login, BYTE *name_buffer, int buffer_len)
RETCODE dbsetdefcharset(char *charset)
void dbsetbusy(DBPROCESS *dbprocess, DB_DBBUSY_FUNC busyfunc)
#define tds_sysdep_real32_type
#define tds_sysdep_int16_type
#define tds_sysdep_uint16_type
#define tds_sysdep_int64_type
#define tds_sysdep_uint32_type
#define tds_sysdep_int32_type
#define tds_sysdep_uint64_type
#define tds_sysdep_real64_type
#define dbpivot_lookup_name
#define dbnextrow_pivoted
RETCODE bcp_colfmt(DBPROCESS *dbproc, int host_colnum, int host_type, int host_prefixlen, DBINT host_collen, const BYTE *host_term, int host_termlen, int table_colnum)
Specify the format of a datafile prior to writing to a table.
DBBOOL bcp_getl(LOGINREC *login)
See if BCP_SETL() was used to set the LOGINREC for BCP work.
RETCODE bcp_control(DBPROCESS *dbproc, int field, DBINT value)
Set BCP options for uploading a datafile.
RETCODE bcp_columns(DBPROCESS *dbproc, int host_colcount)
Indicate how many columns are to be found in the datafile.
RETCODE bcp_colptr(DBPROCESS *dbproc, BYTE *colptr, int table_column)
Override bcp_bind() by pointing to a different host variable.
RETCODE bcp_bind(DBPROCESS *dbproc, BYTE *varaddr, int prefixlen, DBINT varlen, BYTE *terminator, int termlen, int db_vartype, int table_column)
Bind a program host variable to a database column.
RETCODE bcp_exec(DBPROCESS *dbproc, DBINT *rows_copied)
Write a datafile to a table.
DBINT bcp_done(DBPROCESS *dbproc)
Conclude the transfer of data from program variables.
RETCODE bcp_readfmt(DBPROCESS *dbproc, const char filename[])
Read a format definition file.
DBINT bcp_batch(DBPROCESS *dbproc)
Commit a set of rows to the table.
RETCODE bcp_init(DBPROCESS *dbproc, const char *tblname, const char *hfile, const char *errfile, int direction)
Prepare for bulk copy operation on a table.
RETCODE bcp_collen(DBPROCESS *dbproc, DBINT varlen, int table_column)
Set the length of a host variable to be written to a table.
RETCODE bcp_sendrow(DBPROCESS *dbproc)
Write data in host variables to the table.
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)
Specify the format of a host file for bulk copy purposes, with precision and scale support for numeri...
RETCODE bcp_options(DBPROCESS *dbproc, int option, BYTE *value, int valuelen)
Set "hints" for uploading a file.
void dbclrbuf(DBPROCESS *dbproc, DBINT n)
Clear n rows from the row buffer.
LOGINREC * dblogin(void)
Allocate a LOGINREC structure.
DBTYPEINFO * dbcoltypeinfo(DBPROCESS *dbproc, int column)
Get precision and scale information for a regular result column.
void dbfreebuf(DBPROCESS *dbproc)
Erase the command buffer, in case DBNOAUTOFREE was set with dbsetopt().
BYTE * dbdata(DBPROCESS *dbproc, int column)
Get address of data in a regular result column.
int dbstrlen(DBPROCESS *dbproc)
Get size of the command buffer, in bytes.
BYTE * dbadata(DBPROCESS *dbproc, int computeid, int column)
Get address of compute column data.
int dbspid(DBPROCESS *dbproc)
Get server process ID for a DBPROCESS.
DBBINARY * dbtxtimestamp(DBPROCESS *dbproc, int column)
Get text timestamp for a column in the current row.
BYTE * dbbylist(DBPROCESS *dbproc, int computeid, int *size)
Get bylist for a compute row.
char * dbservcharset(DBPROCESS *dbproc)
Get syscharset name of the server character set.
DBINT dbspr1rowlen(DBPROCESS *dbproc)
Determine size buffer required to hold the results returned by dbsprhead(), dbsprline(),...
DBINT dbconvert(DBPROCESS *dbproc, int srctype, const BYTE *src, DBINT srclen, int desttype, BYTE *dest, DBINT destlen)
cf.
DBINT dbadlen(DBPROCESS *dbproc, int computeid, int column)
Get size of data in a compute column.
RETCODE dbsetnull(DBPROCESS *dbproc, int bindtype, int bindlen, BYTE *bindval)
Define substitution values to be used when binding null values.
char * dbcolname(DBPROCESS *dbproc, int column)
Return name of a regular result column.
RETCODE dbfcmd(DBPROCESS *dbproc, const char *fmt,...)
printf-like way to form SQL to send to the server.
RETCODE dbdatecrack(DBPROCESS *dbproc, DBDATEREC *di, DBDATETIME *datetime)
Break a DBDATETIME value into useful pieces.
RETCODE dbresults(DBPROCESS *dbproc)
Set up query results.
RETCODE dbwritetext(DBPROCESS *dbproc, char *objname, DBBINARY *textptr, DBTINYINT textptrlen, DBBINARY *timestamp, DBBOOL log, DBINT size, BYTE *text)
Send text or image data to the server.
RETCODE dbcanquery(DBPROCESS *dbproc)
Cancel the query currently being retrieved, discarding all pending rows.
RETCODE dbinit(void)
Initialize db-lib.
DBINT dbvarylen(DBPROCESS *dbproc, int column)
Determine whether a column can vary in size.
RETCODE dbcancel(DBPROCESS *dbproc)
Cancel the current command batch.
RETCODE dbsetlogintime(int seconds)
Set maximum seconds db-lib waits for a server response to a login attempt.
RETCODE dbgetrow(DBPROCESS *dbproc, DBINT row)
Read a row from the row buffer.
int dbcoltype(DBPROCESS *dbproc, int column)
Get the datatype of a regular result set column.
void dbsetifile(char *filename)
set name and location of the interfaces file FreeTDS should use to look up a servername.
const char * dbversion()
See which version of db-lib is in use.
RETCODE dbuse(DBPROCESS *dbproc, const char *name)
Change current database.
int dbnumalts(DBPROCESS *dbproc, int computeid)
Get count of columns in a compute row.
BOOL dbiscount(DBPROCESS *dbproc)
Indicates whether or not the count returned by dbcount is real (Microsoft-compatibility feature).
int dbgettime(void)
Get maximum seconds db-lib waits for a server response to query.
RETCODE dbmoretext(DBPROCESS *dbproc, DBINT size, const BYTE text[])
Send chunk of a text/image value to the server.
const char * dbprtype(int token)
Print a token value's name to a buffer.
char * dbcolsource(DBPROCESS *dbproc, int column)
Get base database column name for a result set column.
char * dbchange(DBPROCESS *dbproc)
See if a command caused the current database to change.
RETCODE dbnullbind(DBPROCESS *dbproc, int column, DBINT *indicator)
Tie a null-indicator to a regular result column.
RETCODE dbbind(DBPROCESS *dbproc, int column, int vartype, DBINT varlen, BYTE *varaddr)
Tie a host variable to a resultset column.
RETCODE dbcmd(DBPROCESS *dbproc, const char cmdstring[])
Append SQL to the command buffer.
DBINT dbcollen(DBPROCESS *dbproc, int column)
Get size of a regular result column.
DBINT dbconvert_ps(DBPROCESS *dbproc, int db_srctype, const BYTE *src, DBINT srclen, int db_desttype, BYTE *dest, DBINT destlen, DBTYPEINFO *typeinfo)
Convert one datatype to another.
char * dbgetchar(DBPROCESS *dbproc, int pos)
Get address of a position in the command buffer.
RETCODE dbanullbind(DBPROCESS *dbproc, int computeid, int column, DBINT *indicator)
Tie a null-indicator to a compute result column.
RETCODE dbclropt(DBPROCESS *dbproc, int option, const char param[])
Reset an option.
DBINT dbcount(DBPROCESS *dbproc)
Get count of rows processed.
int dbaltop(DBPROCESS *dbproc, int computeid, int column)
Get aggregation operator for a compute column.
RETCODE dbtablecolinfo(DBPROCESS *dbproc, DBINT column, DBCOL *pdbcol)
describe table column attributes with a single call (Freetds-only API function modelled on dbcolinfo)
DBINT dbaltlen(DBPROCESS *dbproc, int computeid, int column)
Get size of data in compute column.
RETCODE dbsetopt(DBPROCESS *dbproc, int option, const char *char_param, int int_param)
Set db-lib or server option.
void dbprhead(DBPROCESS *dbproc)
Print result set headings to stdout.
RETCODE dbsetlversion(LOGINREC *login, BYTE version)
Set TDS version for future connections.
RETCODE dbprrow(DBPROCESS *dbproc)
Print a result set to stdout.
char * dbname(DBPROCESS *dbproc)
Get name of current database.
int dbalttype(DBPROCESS *dbproc, int computeid, int column)
Get datatype for a compute column.
RETCODE dbsprhead(DBPROCESS *dbproc, char *buffer, DBINT buf_len)
Print result set headings to a buffer.
RETCODE dbsqlexec(DBPROCESS *dbproc)
send the SQL command to the server and wait for an answer.
DBBOOL dbwillconvert(int srctype, int desttype)
Test whether or not a datatype can be converted to another datatype.
int dbcolutype(DBPROCESS *dbproc, int column)
Get user-defined datatype of a regular result column.
RETCODE dbstrbuild(DBPROCESS *dbproc, char *charbuf, int bufsize, char *text, char *formats,...)
Build a printable string from text containing placeholders for variables.
EHANDLEFUNC dberrhandle(EHANDLEFUNC handler)
Set an error handler, for messages from db-lib.
RETCODE dbsetversion(DBINT version)
Specify a db-lib version level.
int dbgetpacket(DBPROCESS *dbproc)
Get TDS packet size for the connection.
void dbrecftos(const char filename[])
Record to a file all SQL commands sent to the server.
BYTE * dbgetuserdata(DBPROCESS *dbproc)
Get address of user-allocated data from a DBPROCESS.
void dbsetuserdata(DBPROCESS *dbproc, BYTE *ptr)
Associate client-allocated (and defined) data with a DBPROCESS.
DBINT dbprcollen(DBPROCESS *dbproc, int column)
Get size of a result column needed to print column.
void dbloginfree(LOGINREC *login)
free the LOGINREC
RETCODE dbmorecmds(DBPROCESS *dbproc)
See if more commands are to be processed.
DBBOOL dbisopt(DBPROCESS *dbproc, int option, const char param[])
Get value of an option.
int dbnumcompute(DBPROCESS *dbproc)
Get count of COMPUTE clauses for a result set.
RETCODE dbsqlsend(DBPROCESS *dbproc)
Transmit the command buffer to the server.
RETCODE dbsprline(DBPROCESS *dbproc, char *buffer, DBINT buf_len, DBCHAR line_char)
Get formatted string for underlining dbsprhead() column names.
void dbexit()
Close server connections and free all related structures.
RETCODE dbsafestr(DBPROCESS *dbproc, const char *src, DBINT srclen, char *dest, DBINT destlen, int quotetype)
safely quotes character values in SQL text.
int dbaltcolid(DBPROCESS *dbproc, int computeid, int column)
Get column ID of a compute column.
RETCODE dbanydatecrack(DBPROCESS *dbproc, DBDATEREC2 *di, int type, const void *data)
Break any kind of date or time value into useful pieces.
RETCODE dbsettime(int seconds)
Set maximum seconds db-lib waits for a server response to query.
int dbnumcols(DBPROCESS *dbproc)
Return number of regular columns in a result set.
int dbgetmaxprocs(void)
get maximum simultaneous connections db-lib will open to the server.
DBBINARY * dbtxptr(DBPROCESS *dbproc, int column)
Get text pointer for a column in the current row.
MHANDLEFUNC dbmsghandle(MHANDLEFUNC handler)
Set a message handler, for messages from the server.
STATUS dbreadtext(DBPROCESS *dbproc, void *buf, DBINT bufsize)
Fetch part of a text or image value from the server.
RETCODE dbsqlok(DBPROCESS *dbproc)
Wait for results of a query from the server.
DBINT dbdatlen(DBPROCESS *dbproc, int column)
Get size of current row's data in a regular result column.
STATUS dbsetrow(DBPROCESS *dbproc, DBINT row)
Make a buffered row "current" without fetching it into bound variables.
void dbclose(DBPROCESS *dbproc)
Close a connection to the server and free associated resources.
RETCODE dbstrcpy(DBPROCESS *dbproc, int start, int numbytes, char *dest)
Get a copy of a chunk of the command buffer.
DBINT dbaltutype(DBPROCESS *dbproc, int computeid, int column)
Get user-defined datatype of a compute column.
RETCODE dbsetmaxprocs(int maxprocs)
Set maximum simultaneous connections db-lib will open to the server.
DBINT dbfirstrow(DBPROCESS *dbproc)
See if a server response has arrived.
RETCODE dbspr1row(DBPROCESS *dbproc, char *buffer, DBINT buf_len)
Print a regular result row to a buffer.
RETCODE dbaltbind(DBPROCESS *dbproc, int computeid, int column, int vartype, DBINT varlen, BYTE *varaddr)
Bind a compute column to a program variable.
int dbdatecmp(DBPROCESS *dbproc, DBDATETIME *d1, DBDATETIME *d2)
Compare DBDATETIME values, similar to strcmp(3).
const char * dbmonthname(DBPROCESS *dbproc, char *language, int monthnum, DBBOOL shortform)
Get name of a month, in some human language.
RETCODE dbmny4zero(DBPROCESS *dbproc, DBMONEY4 *dest)
Zero a DBMONEY4 value.
RETCODE dbmny4add(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2, DBMONEY4 *sum)
Add two DBMONEY4 values.
int dbmny4cmp(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2)
Compare two DBMONEY4 values.
RETCODE dbmnymaxpos(DBPROCESS *dbproc, DBMONEY *amount)
Get maximum positive DBMONEY value supported.
RETCODE dbmny4minus(DBPROCESS *dbproc, DBMONEY4 *src, DBMONEY4 *dest)
Negate a DBMONEY4 value.
RETCODE dbmnyminus(DBPROCESS *dbproc, DBMONEY *src, DBMONEY *dest)
Negate a DBMONEY value.
RETCODE dbmny4sub(DBPROCESS *dbproc, DBMONEY4 *m1, DBMONEY4 *m2, DBMONEY4 *diff)
Subtract two DBMONEY4 values.
RETCODE dbmnyzero(DBPROCESS *dbproc, DBMONEY *dest)
Set a DBMONEY value to zero.
RETCODE dbmnycopy(DBPROCESS *dbproc, DBMONEY *src, DBMONEY *dest)
Copy a DBMONEY value.
RETCODE dbmny4copy(DBPROCESS *dbproc, DBMONEY4 *src, DBMONEY4 *dest)
Copy a DBMONEY4 value.
RETCODE dbmnymaxneg(DBPROCESS *dbproc, DBMONEY *amount)
Get maximum negative DBMONEY value supported.
RETCODE dbmnydec(DBPROCESS *dbproc, DBMONEY *amount)
Subtract $0.0001 from a DBMONEY value.
RETCODE dbmnyinc(DBPROCESS *dbproc, DBMONEY *amount)
Add $0.0001 to a DBMONEY value.
int dbmnycmp(DBPROCESS *dbproc, DBMONEY *m1, DBMONEY *m2)
Compare two DBMONEY values.
DBINT dbretstatus(DBPROCESS *dbproc)
Fetch status value returned by query or remote procedure call.
RETCODE dbrpcinit(DBPROCESS *dbproc, const char rpcname[], DBSMALLINT options)
Initialize a remote procedure call.
BYTE * dbretdata(DBPROCESS *dbproc, int retnum)
Get value of an output parameter filled by a stored procedure.
char * dbretname(DBPROCESS *dbproc, int retnum)
Get name of an output parameter filled by a stored procedure.
DBBOOL dbhasretstat(DBPROCESS *dbproc)
Determine if query generated a return status number.
int dbrettype(DBPROCESS *dbproc, int retnum)
Get datatype of a stored procedure's return parameter.
int dbretlen(DBPROCESS *dbproc, int retnum)
Get size of an output parameter filled by a stored procedure.
RETCODE dbrpcparam(DBPROCESS *dbproc, const char paramname[], BYTE status, int db_type, DBINT maxlen, DBINT datalen, BYTE *value)
Add a parameter to a remote procedure call.
RETCODE dbrpcsend(DBPROCESS *dbproc)
Execute the procedure and free associated memory.
int dbnumrets(DBPROCESS *dbproc)
Get count of output parameters filled by a stored procedure.
unsigned int
A callback function used to compare two keys in a database.
<!DOCTYPE HTML >< html > n< header > n< title > PubSeq Gateway Help Page</title > n< style > n table
static void text(MDB_val *v)
constexpr auto sort(_Init &&init)
const string version
version string
const struct ncbi::grid::netcache::search::fields::SIZE size
const GenericPointer< typename T::ValueType > T2 value
static PCRE2_SIZE bufsize
#define row(bind, expected)
DBSMALLINT offset
time offset
DBUBIGINT time
time, 7 digit precision
DBINT date
date, 0 = 1900-01-01
struct dbstring * strnext
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4