DB-Library API Implementation Summary

Microsoft's version of DB-Library is online. Sybase's is both online. [26]

Table 11.1. DB-Library API Implementation Summary

CategoryMicrosoft nameSybase nameStatusComments
(none) n/adb12hour 
(none) n/adbaltbind_ps 
(none) n/adbbind_ps 
(none) n/adbbufsize 
(none) n/adbcharsetconv 
(none) n/adbcoltypeinfoOK 
(none) n/adbconvert_psOK 
(none) n/adbfreesortnever
(none) n/adbfree_xlatenever
(none) n/adbgetcharset 
(none) n/adbgetloginfonever
(none) n/adbgetlusername 
(none) n/adbgetnatlang 
(none) n/aDBIORDESCOK 
(none) n/aDBIOWDESCOK 
(none) n/adbloadsortnever
(none) n/adbload_xlatenever
(none) n/adbnpcreatenever
(none) n/adbnpdefinenever
(none) n/adbpoll 
(none) n/aDBRBUFnever
(none) n/adbreadpagenever
(none) n/adbrecftosOK 
(none) n/adbrecvpassthrunever
(none) n/adbregdropnever
(none) n/adbregexecnever
(none) n/adbreghandlenever
(none) n/adbreginitnever
(none) n/adbreglistnever
(none) n/adbregnowatchnever
(none) n/adbregparamnever
(none) n/adbregwatchnever
(none) n/adbregwatchlistnever
(none) n/adbrpwclrnever
(none) n/adbrpwsetnever
(none) n/adbsafestrOK 
(none) n/adbsechandle 
(none) n/adbsendpassthrunever
(none) n/adbsetbusy 
(none) n/adbsetdefcharset 
(none) n/adbsetdeflang 
(none) n/adbsetidle 
(none) n/adbsetifileOK 
(none) n/adbsetinterruptOK 
(none) n/aDBSETLCHARSET 
(none) n/aDBSETLENCRYPT 
(none) n/adbsetloginfonever
(none) n/adbsetrowOK
(none) n/adbsetversionOK 
(none) n/adbspr1rowOK 
(none) n/adbspr1rowlenOK 
(none) n/adbsprheadOK 
(none) n/adbsprlineOK 
(none) n/adbstrcmpnever
(none) n/adbstrsortnever
(none) n/adbtextsize 
(none) n/adbwritepagenever
(none) n/adbxlatenever
bcp bcp_batch(same)OK
bcp bcp_bind(same)OK
bcp bcp_colfmt(same)OK
bcp n/abcp_colfmt_ps 
bcp bcp_collen(same)OK
bcp bcp_colptr(same)OK
bcp bcp_columns(same)OK
bcp bcp_control(same)OK
bcp bcp_done(same)OK
bcp bcp_exec(same)OK
bcp n/abcp_getlOK
bcp bcp_init(same)OK
bcp bcp_moretext(same)stub
bcp n/abcp_optionspartial
bcp bcp_readfmt(same)OK
bcp bcp_sendrow(same)OK
bcp BCP_SETL(same)OK
bcp bcp_writefmt(same) 
browse dbcolbrowsen/anever
browse dbcolsourcen/anever
browse dbfreequaln/anever
browse dbqualn/anever
browse dbtabbrowsen/anever
browse dbtabcountn/anever
browse dbtabnamen/anever
browse dbtabsourcen/anever
browse dbtsnewlenn/anever
browse dbtsnewvaln/anever
browse dbtsputn/anever
core dbadata(same)OK
core dbadlen(same)OK
core dbaltbind(same)OK
core dbaltcolid(same)OK
core dbaltlen(same)OK
core dbaltop(same)OK
core dbalttype(same)OK
core dbaltutype(same)OK
core dbanullbind(same)OK
core dbbind(same)OK
core dbbylist(same)OK
core dbcancel(same)OK
core dbcanquery(same)OK
core dbchange(same)OK
core dbclose(same)OK
core dbclrbuf(same)OK
core dbclropt(same)partial
core dbcmd(same)OK
core dbcmdrowDBCMDROWOK
core dbcolinfon/aOK
core dbcollen(same)OK
core dbcolname(same)OK
core dbcoltype(same)OK
core dbcolutype(same)OK
core dbconvert(same)OK
core dbcountDBCOUNTOK
core dbcurcmdDBCURCMDstub
core dbcurrowDBCURROWstub
core dbdata(same)OK
core dbdatareadyn/a 
core dbdatecrack(same)OK
core dbdatlen(same)OK
core dbdeadDBDEADOK
core dbenlisttransn/anever
core dbenlistxatransn/anever
core dberrhandle(same)OK
core dbexit(same)OK
core dbfcmd(same)OK
core dbfirstrowDBFIRSTROWOK
core dbfreebuf(same)OK
core dbgetchar(same)OK
core dbgetmaxprocs(same)OK
core dbgetoff(same)never
core dbgetpacket(same)OK
core dbgetrow(same)OK
core dbgettimeDBGETTIMEOK
core dbgetuserdata(same)OK
core dbinit(same)OK
core dbisavailDBISAVAILOK
core dbiscountn/aOK
core dbisopt(same)partial
core dblastrowDBLASTROWOK
core dblogin(same)OK
core dbfreelogindbloginfreeOK
moneyn/adbmny4addOK
moneyn/adbmny4cmpOK
moneyn/adbmny4copyOK
moneyn/adbmny4dividestub
moneyn/adbmny4minusOK
moneyn/adbmny4mulstub
moneyn/adbmny4subOK
moneyn/adbmny4zeroOK
moneyn/adbmnyaddstub
moneyn/adbmnycmpOK
moneyn/adbmnycopyOK
moneyn/adbmnydecOK
moneyn/adbmnydividestub
moneyn/adbmnydownstub
moneyn/adbmnyincOK
moneyn/adbmnyinitstub
moneyn/adbmnymaxnegOK
moneyn/adbmnymaxposOK
moneyn/adbmnyminusOK
moneyn/adbmnymulstub
moneyn/adbmnyndigitstub
moneyn/adbmnyscalestub
moneyn/adbmnysubstub
moneyn/adbmnyzeroOK
core dbmorecmdsDBMORECMDSOK
core dbmsghandle(same)OK
core dbname(same)OK
core dbnextrow(same)OK
core dbnullbind(same)OK
core dbnumalts(same)OK
core dbnumcols(same)OK
core dbnumcompute(same)OK
core dbnumordersDBNUMORDERSnever
core dbopen(same)OK
core dbordercol(same)never
core dbprhead(same)OK
core dbprocerrhandlen/aaliases dberrhandle
core dbprocinfon/anever
core dbprocmsghandlen/aaliases dbmsghandle
core dbprrow(same)OK
core dbprtype(same)OK
core dbresults(same)OK
core dbrowsDBROWSOK
core dbrowtypeDBROWTYPEOK
core n/adbservcharsetOK
core dbserverenumn/anever
core dbsetavail(same)OK
core dbsetlappDBSETLAPPOK
core dbsetlfallbackn/anever
core dbsetlhostDBSETLHOSTOK
core dbsetlnatlangDBSETLNATLANGOK
core dbsetlogintime(same)OK
core dbsetlpacketDBSETLPACKETOK
core dbsetlpwdDBSETLPWDOK
core dbsetlsecuren/a 
core dbsetltimen/a 
core dbsetluserDBSETLUSEROK
core dbsetlversionn/aOK
core dbsetmaxprocs(same)OK
core dbsetnull(same)OK
core dbsetopt(same)partial
core dbsettime(same)OK
core dbsetuserdata(same)OK
core n/adbspidOK
core dbsqlexec(same)OK
core dbsqlok(same)OK
core dbsqlsend(same)OK
core n/adbstrbuildOK
core dbstrcpy(same)OK
core dbstrlen(same)OK
core n/aDBTDSOK
core dbuse(same)OK
core dbvarylen(same)OK
core n/adbversionOK
core dbwillconvert(same)OK
core dbwinexit (Windows only)n/ano-op macro
cursor dbcursor(same)never
cursor dbcursorbind(same)never
cursor dbcursorclose(same)never
cursor dbcursorcolinfo(same)never
cursor dbcursorfetch(same)never
cursor dbcursorfetchexn/anever
cursor dbcursorinfo(same)never
cursor dbcursorinfoexn/anever
cursor dbcursoropen(same)never
datetime n/adbdate4cmpnever
datetime n/adbdate4zeronever
datetime n/adbdatecharnever
datetime n/adbdatecmpOK 
datetime n/adbdatenamenever
datetime n/adbdateordernever
datetime n/adbdatepartnever
datetime n/adbdatezeronever
datetime n/adbdaynamenever
datetime n/adbmonthnameOK
proceduredbhasretstat(same)OK
proceduredbnumrets(same)OK
proceduredbretdata(same)OK
proceduredbretlen(same)OK
proceduredbretname(same)OK
proceduredbretstatus(same)OK
proceduredbrettype(same)OK
proceduredbrpcexecn/a 
proceduredbrpcinit(same)OK
proceduredbrpcparam(same)OK
proceduredbrpcsend(same)OK
text dbmoretext(same)OK
text dbreadtext(same)OK
text dbtxptr(same)OK
text dbtxtimestamp(same)OK
text dbtxtsnewval(same) 
text dbtxtsput(same) 
text dbupdatetextn/a 
text dbwritetext(same)OK



[26] Links such as these are quite perishable. Should you find them broken, please check the FreeTDS™ User Guide posted on our website. If it's out of date, please let us know, so we can correct it. Thanks.